PI31598: CORRECT INCONSISTENCIES FOR ADB1945W WARNING MESSAGE.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• WARNING MESSAGE ADB1945W HAS FOLLOWING INCONSISTENCY:
  LEMSG says: "When zparm SPRMRRF is disabled, INLINE LENGTH
  clauses for column are not generated..."
  
  Should say "When zparm SPRMRRF is disabled, INLINE
  LENGTH clauses for the columns are not generated."
  

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: DB2 Administration issues a warning     *
  *                      message ADB1945W / msgadb1945w that is  *
  *                      not the same as the message referenced  *
  *                      in DB2 Administration Tool for z/OS     *
  *                      User's Guide and Reference.  In the     *
  *                      GEN job's output, the message           *
  *                      ADB1945W below is seen:                 *
  *                                                              *
  *                      ADB1945W  "INLINE LENGTH                *
  *                      >length<" clause for column             *
  *                      >col_name< is not generated             *
  *                      because SPRMRRF is set to               *
  *                      disable.                                *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Message ADB1945W / msgadb1945w  is not the same as the message
  referenced in the DB2 Administration Tool for z/OS User's Guide
  and Reference.
  

Problem conclusion

• Problem has been resolved.
  
  Message ADB1945W / msgadb1945w has been updated to the
  following:
  
  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.
  

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:

  UI29312 UI29313

Modules/Macros

• ADB1000
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA20 PSY UI29312

     UP15/07/15 P F507

• RB10 PSY UI29313

     UP15/07/15 P F507

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.