PI12812: SQLCODEN670 WHEN CHANGING BUFFERPOOL SIZE FROM 4K TO 32K AND ADD ING A VARCHAR(30000) COLUMN

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Administration Tool for z/OS' Change Management function
  builds an APPLY job which fails with a SQLCODEN670/SQLCODE -670
  ADB5044I *** INPUT STATEMENT:
     ALTER TABLE >schema<.>table<
       ADD
         FNEW                 VARCHAR(30000) FOR SBCS DATA NOT
  NULL
           WITH DEFAULT ;
  sqlerror on ALTER      command, EXECUTE    function
  DSNT408I SQLCODE = -670, ERROR:  THE RECORD LENGTH OF THE TABLE
  EXCEEDS THE
           PAGE SIZE LIMIT
  DSNT418I SQLSTATE   = 54010 SQLSTATE RETURN CODE
  DSNT415I SQLERRP    = DSNXIAB3 SQL PROCEDURE DETECTING ERROR
  DSNT416I SQLERRD    = 35  0  0  -1  0  0 SQL DIAGNOSTIC
  INFORMATION
  DSNT416I SQLERRD    = X'00000023'  X'00000000'  X'00000000'
  X'FFFFFFFF'
           X'00000000'  X'00000000' SQL DIAGNOSTIC INFORMATION
  when the change involves changing the bufferpool size and a
  long column is added to the table.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool and     *
  *                 DB2 Object Comparison Tool for z/OS who      *
  *                 change the bufferpool size for the table     *
  *                 space and add a long column into a table     *
  *                 under such table space.                      *
  ****************************************************************
  * PROBLEM DESCRIPTION: The DB2 Administration Tool for z/OS    *
  *                      Change Management (CM) function builds  *
  *                      an APPLY job which fails with a         *
  *                      SQLCODEN670 / SQLCODE -670:             *
  *                                                              *
  *                      ADB5044I *** INPUT STATEMENT:           *
  *                      ALTER TABLE >schema<.>table<            *
  *                           ADD                                *
  *                           >column<  VARCHAR(30000) FOR       *
  *                           SBCS DATA                          *
  *                           NOT NULL WITH DEFAULT ;            *
  *                      sqlerror on ALTER      command,         *
  *                           EXECUTE    function                *
  *                                                              *
  *                      DSNT408I SQLCODE = -670, ERROR:         *
  *                      THE RECORD LENGTH OF THE TABLE          *
  *                        EXCEEDS THE PAGE SIZE LIMIT           *
  *                      DSNT418I SQLSTATE   = 54010             *
  *                      SQLSTATE RETURN CODE                    *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  The change operation for ALTER TABLE in the change file
  generated by the compare program is incorrect.
  

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:

  UI19337 UI19338

Modules/Macros

•    ADBCDTS  ADB2CMT  ADB7000
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA20 PSY UI19337

     UP14/07/08 P F407

• RB10 PSY UI19338

     UP14/07/08 P F407

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.