PM89188: ALT DOES NOT WARN OF CHANGE WHICH WILL EXCEED DB2 LIMITS RESULTI NG APPLY JOB FAILS WITH SQLCODEN680 TOO MANY COLUMNS SPECIFIED

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Administration Tool for z/OS' ALT function does not warn
  customers that a change will exceed the DB2 limits resulting in
  the APPLY job failing with a SQLCODEN680 / SQLCODE -680:
  DSNT408I SQLCODE = -680, ERROR:  TOO MANY COLUMNS SPECIFIED FOR
  A TABLE, VIEW,
           OR TABLE FUNCTION
  DSNT418I SQLSTATE   = 54011 SQLSTATE RETURN CODE
  DSNT415I SQLERRP    = DSNXIAB3 SQL PROCEDURE DETECTING ERROR
  DSNT416I SQLERRD    = 135  0  0  -1  0  0 SQL DIAGNOSTIC
  INFORMATION
  DSNT416I SQLERRD    = X'00000087'  X'00000000'  X'00000000'
  X'FFFFFFFF'
           X'00000000'  X'00000000' SQL DIAGNOSTIC INFORMATION
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS who use 'ALT Alter Table' (ALT) to      *
  *                 alter the table or use the DB2 Object        *
  *                 Comparison Tool to compare two tables.       *
  ****************************************************************
  * PROBLEM DESCRIPTION: When a user alters a table that         *
  *                      contains more than 750 columns on       *
  *                      panel ADB27C 'ALTER Table' or uses DB2  *
  *                      Object Comparison Tool to compare two   *
  *                      tables table has more than 750 columns, *
  *                      the DB2 Admin Tool analyzes the change  *
  *                      with no errors, but the APPLY job       *
  *                      fails with a SQLCODEN680 /              *
  *                      SQLCODE=-680:                           *
  *                                                              *
  *                      DSNT408I SQLCODE = -680, ERROR:         *
  *                      TOO MANY COLUMNS SPECIFIED              *
  *                      FOR A TABLE, VIEW, OR TABLE             *
  *                      FUNCTION                                *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When a user alters a table that contains more than 750 columns
  on panel ADB27C 'ALTER Table' or uses DB2 Object Comparison
  Tool to compare two tables table has more than 750 columns,
  the DB2 Admin Tool analyzes the change with no errors, but
  the APPLY job fails with a SQLCODEN680 / SQLCODE=-680.
  

Problem conclusion

• Problem has been resolved.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

  UI13020 UI13021

Modules/Macros

•    ADB2CMP  ADB2CMR  ADB2CMT  ADB21TA  ADB27C
  ADB27DUP ADB7000  ADB90
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA10 PSY UI13021

     UP13/11/30 P F311

• RA20 PSY UI13020

     UP13/11/30 P F311

Fix is available

• Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.