PM56159: SQLCODEN670 ON SYSPACKSTMT TABLE WHILE PERFORMING CATALOG COPY USING DB2 ADMINISTRATION TOOL V10.1 FOR Z/OS IN DB2 V10 CM8

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• sqlerror on CREATE     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    = DSNXICB3 SQL PROCEDURE DETECTING ERROR
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS who use Catalog Copy in DB2 10 CM8 /    *
  *                 Compatibility Mode 8.                        *
  ****************************************************************
  * PROBLEM DESCRIPTION: Users of the DB2 Administration Tool    *
  *                      for z/OS who use Catalog Copy in DB2    *
  *                      10 CM8, and submit the DDLBNDxx job     *
  *                      received a SQLCODE=-670 / SQLCODEN670   *
  *                      error:                                  *
  *                                                              *
  *                      sqlerror on CREATE     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:                                              *
  ****************************************************************
  A SQLCODE = -670 / SQLCODEN670 error occurred because a 4K
  buffer pool was specified for table space SYSPKAGE.
  

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:

  UK77285

Modules/Macros

•    ADBHCCJ  ADB2CCI  ADB2CJDB
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA10 PSY UK77285

     UP12/03/25 P F203

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.