PI07115: ALT APPLY JOB FAILS SQLCODEN680 TOO MANY COLUMNS SPECIFIED

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• ALT APPLY job fails with SQLCODEN680 ERROR: TOO MANY COLUMNS
  SPECIFIED FOR A TABLE, VIEW,OR TABLE FUNCTION.
  

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 for z/OS to compare two      *
  *                 tables.                                      *
  ****************************************************************
  * PROBLEM DESCRIPTION: When a user alters a table such that    *
  *                      it will contain more than 750 columns   *
  *                      on panel ADB27C 'ALTER Table' or uses   *
  *                      Object Compare to compare two tables    *
  *                      that have more than 750 columns, DB2    *
  *                      Admin 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 such that it will contain more than
  750 columns on panel ADB27C 'ALTER Table' or uses Object Compare
  to compare two tables that have more than 750 columns, DB2
  Admin analyzes the change with no errors, but the APPLY job
  fails with a SQLCODEN680 / SQLCODE=-680.
  

Problem conclusion

• Problem has been resolved.
  The following error message is displayed when a user alters a
  table that contains more than 750 columns on panel ADB27C:
  
  1- For ALT new message ADB904E / msgadb904e has been
  added:
  
  ADB904E The table >schema<.>tb_name< contains too many
  columns.
  
  Explanation
  You can assign up to 750 columns to a non-dependent table.
  Dependent tables can have up to 749 columns.
  System action
  Processing stops.
  User response
  Limit the number of columns so that the allowed value is not
  exceeded and try the operation again.
  
  2- For Object Compare new message ADB7102e / msgadb7102e has
  been added:
  
  ADB7102E The table >schema<.>tb_name< contains too many
  columns.
  
  Explanation
  You can assign up to 750 columns to a non-dependent table.
  Dependent tables can have up to 749 columns.
  System action
  Processing stops.
  User response
  Limit the number of columns so that the allowed value is not
  exceeded and try the operation again.
  

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:

Modules/Macros

•    ADB2CMF  ADB2CMP  ADB2CMR  ADB2CMT  ADB21TA
  ADB27C   ADB27DUP ADB7000  ADB90
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB10 PSY UI24416

     UP15/01/18 P F501

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.