PM89539: DB2 ADMINISTRATION TOOL FOR Z/OS DOES NOT CHECK ZPARM VALUE FOR RRF SETTING WHEN GEN DDL WITH INLINE LENGTH FOR CLOB COLUMNS

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DB2 Administration Tool for z/OS does not check ZPARM value for
  RRF
  setting before GENerating DDL with INLINE LENGTH for CLOB
  Columns
  

Local fix

• Edit out references to "INLINE LENGTH nnnnn"
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS who use the Generate (GEN) function     *
  *                 to generate the table that has a LOB column  *
  *                 with INLINE LENGTH and run the DDL on the    *
  *                 DB2 system which set ZPARM SPRMRRF to        *
  *                 DISABLE.                                     *
  ****************************************************************
  * PROBLEM DESCRIPTION: DB2 Administration Tool for z/OS does   *
  *                      not check the ZPARM value for SPRMRRF   *
  *                      before generating the DDL with INLINE   *
  *                      LENGTH for CLOB columns, causing the    *
  *                      CREATE statement to fail with           *
  *                      SQLCODE=-20016 / SQLCODEN20016 error:   *
  *                                                              *
  *                      DSNT408I SQLCODE = -20016,              *
  *                      ERROR:  THE VALUE OF THE INLINE         *
  *                      LENGTH ASSOCIATED WITH TABLE            *
  *                      IS TOO BIG OR THE INLINE LENGTH         *
  *                      CLAUSE IS NOT ALLOWED IN THE            *
  *                      CONTEXT                                 *
  *                      DSNT418I SQLSTATE = 429B2               *
  *                      SQLSTATE RETURN CODE                    *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  GEN generates INLINE LENGTH for LOB columns which can not be
  run on the system which has ZPARM value SPRMRRF set to DISABLE.
  

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:

Modules/Macros

• ADBCDTS  ADB2CMF  ADB2CMP  ADB2CMR  ADB2CMT  ADB2IGN  ADB2RE
  ADB2REE  ADB2REG  ADB2REZ
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA10 PSY UI11968

     UP13/11/01 P F310

• RA20 PSY UI11969

     UP13/11/01 P F310

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.