PI21795: SQLCODEN604 CM RUN GENERATES MSG ADB5185E RC08 CREATING TABLE WITH COLUMN LENGTH GT 4K IN A 4K BP

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DB2 ADMINISTRATION TOOL for z/OS Change Management RUN function
  generates RC08 and error message:
    ADB5185E The run is ending due to errors.
    DSNT408I SQLCODE = -604, ERROR:  A DATA TYPE DEFINITION
    SPECIFIES AN INVALID LENGTH, PRECISION, OR SCALE ATTRIBUTE
  when attempting to create a Table which has a VARCHAR column
  value greater than 4K in a 4K Bufferpool.
  

Local fix

• Change Varchar value or Bufferpool
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS and DB2 Object Comparison Tool for      *
  *                 z/OS who make a change to the page size      *
  *                 of a table space or columns of a table.      *
  ****************************************************************
  * PROBLEM DESCRIPTION: The Change Management RUN function      *
  *                      generates a Return Code 8 / RC08,       *
  *                      error message ADB5185E / msgadb5185e:   *
  *                                                              *
  *                      ADB5185E The run is ending due          *
  *                      to errors.                              *
  *                                                              *
  *                      and SQLCODE=-604 / SQLCODEN604:         *
  *                                                              *
  *                      DSNT408I SQLCODE = -604,                *
  *                      ERROR:  A DATA TYPE                     *
  *                      DEFINITION SPECIFIES AN                 *
  *                      INVALID LENGTH, PRECISION,              *
  *                      OR SCALE ATTRIBUTE                      *
  *                                                              *
  *                      when attempting to create a table       *
  *                      which has a VARCHAR column length       *
  *                      greater than 4K in a 4K Bufferpool.     *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  The Change Management RUN function generates a Return Code 8 /
  RC08, error message ADB5185E / msgadb5185e:
  
  ADB5185E The run is ending due to errors.
  
  and SQLCODE=-604 / SQLCODEN604 :
  
  DSNT408I SQLCODE = -604, ERROR:  A DATA TYPE
  DEFINITION SPECIFIES AN INVALID LENGTH, PRECISION,
  OR SCALE ATTRIBUTE
  
  when attempting to create a table which has a VARCHAR column
  length greater than 4K in a 4K Bufferpool.
  

Problem conclusion

• The problem has been resolved. When making a change to the
  columns of a table or the Buffer Pool of a table space, the
  DB2 Administration Tool and DB2 Object Comparison Tool for
  z/OS change process will check if the record length of the
  table exceeds the page size limit of the table space post-
  change and issue error message ADB7168E to prevent failure
  during the APPLY.
  
  The page size of the table space would be unknown to Compare
  if the table space is not included in the compared objects.
  In this case, a new warning message ADB7169W will be displayed
  to warn the user to check the page size settings before
  running APPLY.
  
  Error message ADB7168E / msgadb7168e and new warning message
  ADB7169W / msgadb7169w:
  
  ADB7168E
  
  The source table space cannot contain the table record length.
  Specify a larger buffer pool to ensure that the page size is
  suitable for the table record length and that the table
  space can contain the record.
  
  Explanation
  
  This change cannot be applied until you choose a proper
  buffer pool for table space.
  
  System action
  
  Processing stops.
  
  User response
  
  Choose a proper buffer pool for table space before applying
  the changes to the table.
  
  ADB7169W
  
  The page size of the table space is unknown because the table
  space is not included in the compared objects.  Ensure that the
  row length for the table does not exceed the page size limit.
  
  Explanation
  
  Object Compare checks that the row length of the table
  does not exceed the page size limit. This message is
  displayed when Object Compare cannot determine the
  page size of the table space because the table space is
  not included in compared objects.
  
  System action
  
  Processing continues.
  
  User response
  
  Review the message. Ensure that the table space is specified
  in compared objects. If necessary, specify a buffer pool
  with proper page size before running the apply jobs.
  

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:

  UI22287 UI22288

Modules/Macros

•    ADB2CMR  ADB2CMT  ADB7000
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA20 PSY UI22287

     UP14/10/22 P F410

• RB10 PSY UI22288

     UP14/10/22 P F410

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.