PI51255: DB2 ADMIN TOOL IMPORT DDL WITH SUM(LENGTH OF COLUMNS) > 32K GIVING ADB7350E

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• IMPORT DDL with this table definition (SUM(LENTH of COLUMNS) >
  32K):
  CREATE TABLE PMRONC01.AN_PAM_JOB_EXECUTION_CONTEXT
   (CONTEXT_ID              BIGINT  NOT NULL
    , JOB_EXECUTION_ID       BIGINT  NOT NULL
    , SHORT_CONTEXT          VARCHAR(2500) NOT NULL
    , SERIALIZED_CONTEXT     CLOB(100M) INLINE LENGTH 32000
                                    NOT NULL FOR MIXED DATA
    )
  IN PMRONC01.T0012733
      CCSID UNICODE
  ;
  
  Returns:
    ADB7350E Module : ADB2CMF detected an ONCODE condition 340 in
             GET_COL_BYTE_COUNTS at 37467
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool         *
  *                 for z/OS.                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION: When the users IMPORT DDL and the sum   *
  *                      of the length of the columns in the     *
  *                      table is greater than 32K, the analyze  *
  *                      change fails with error ADB7350E /      *
  *                      msgadb7350e:                            *
  *                                                              *
  *                      ADB7350E Module : ADB2CMF detected an   *
  *                               ONCODE condition 340 in        *
  *                               GET_COL_BYTE_COUNTS at 37467   *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When the users IMPORT DDL and the sum of the length of the
  columns in the table is greater than 32K, the analyze change
  fails with error ADB7350E / msgadb7350e.
  

Problem conclusion

• Problem has been resolved.
  
  When the users IMPORT DDL and the sum of the length of the
  columns in the table is greater than 32K, the analyze change
  will now issue a new error message ADB7168E / msgadb7168e:
  
  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 the table space.
  
  System action
  Processing stops.
  
  User response
  Choose a proper buffer pool for the table space before
  applying the changes to the table.
  

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:

  UI36154 UI36155

Modules/Macros

•    ADB2CME  ADB2CMF  ADB2CMO  ADB2CMP  ADB2CMR
  ADB2CMS  ADB2CMT  ADB2CMU  ADB2CM3
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB10 PSY UI36154

     UP16/03/16 P F603

• RB20 PSY UI36155

     UP16/03/16 P F603

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.