PI21166: GEN INLINE LENGTH MISSING DUE TO SPRMRRF DISABLE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Administration Tool for z/OS' GEN and DDL function
  product DDL without the INLINE LENGTH syntax when the DSNZPARM
  SPRMRRF is set to DISABLE.
  
  This APAR will introduce a warning message when the INLINE
  LENGTH is greater than 0 but the syntax is being suppressed
  as a result of SPRMRRF being DISABLE.
  

Local fix

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 when DSNZPARM SPRMRRF              *
  *                 is set to DISABLE.                           *
  ****************************************************************
  * PROBLEM DESCRIPTION: The GEN and DDL function produce DDL    *
  *                      without the INLINE LENGTH syntax        *
  *                      when the DSNZPARM SPRMRRF is set to     *
  *                      DISABLE.                                *
  *                                                              *
  *                      This APAR will introduce a warning      *
  *                      message when the INLINE LENGTH is       *
  *                      greater than 0 but the syntax is        *
  *                      being suppressed as a result of         *
  *                      SPRMRRF being disabled.                 *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  The INLINE LENGTH clause is not generated as DSNZPARM
  parameter SPRMRRF is set to DISABLE.
  

Problem conclusion

• Problem has been resolved.  A new warning message ADB1945W /
  msgadb1945w is added:
  
  ADB1945W The " INLINE LENGTH >length< " clause for
  the column >column_name< in table >table_name< is not
  generated because the zparm SPRMRRF is set to disable.
  
  Explanation: The DB2 zparm SPRMRRF is set to disable.
  When zparm SPRMRRF is disabled, INLINE LENGTH clauses
  for column are not generated.
  
  System action: Processing continue.
  User response: Add 'INLINE LENGTH >length<' clauses
  manually, if needed.
  

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

•    ADB1000  ADB2CMR  ADB2REG
  

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.