PI06386: GEN DDL INLINE LENGTH LOB SPRMRRF ZPARM SQLCODEN20016.

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
  

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 a table that has a LOB column    *
  *                 with the INLINE LENGTH attribute and run     *
  *                 the DDL on a DB2 subsystem which has the     *
  *                 ZPARM SPRMRRF set to DISABLE.                *
  ****************************************************************
  * PROBLEM DESCRIPTION: DB2 Admin does not check the ZPARM      *
  *                      value for SPRMRRF before generating     *
  *                      DDL with the INLINE LENGTH attribute    *
  *                      for CLOB columns, causing the CREATE    *
  *                      statement to fail with a                *
  *                      a 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 the INLINE LENGTH attribute for LOB columns
  which can not be run on a DB2 subsystem which has the 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:

  UI23839 UI23840

Modules/Macros

•    ADBCCMM  ADBCDTS  ADBCP    ADBCVCT  ADBCVEY
  ADBCVIC  ADBCVOC  ADBVFC   ADBVFCA  ADBVFCF  ADB2CDC  ADB2CMF
  ADB2CMP  ADB2CMR  ADB2CMS  ADB2CMT  ADB2DEP  ADB2MSK  ADB2RE
  ADB2REE  ADB2REG  ADB2REH  ADB2REM  ADB2REP  ADB2RER  ADB2RES
  ADB2RET  ADB2REU  ADB2REY  ADB2REZ  ADB2RGC  ADB2RPT  ADB2WCL
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA20 PSY UI23839

     UP14/12/16 P F412

• RB10 PSY UI23840

     UP14/12/16 P F412

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.