PM90574: PANEL ADB2USO 'SPECIFY UTILITY OPTIONS - REORG' ALLOWS 'SHRLEVEL N' FOR LOB TABLESPACES DSNU126I NO LONGER SUPPORTED

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Administration Tool for z/OS' panel ADB2USO 'Specify
  Utility Options - REORG' allows 'SHRLEVEL N' to be specified for
  a LOB tablespace in DB2 10 NFM which results in the message:
  
  DSNU126I  >ssid< nnn nn:nn:nn.nn DSNURFIT - REORG SHRLEVEL NONE
  ON LOB TABLE SPACE IS NO LONGER SUPPORTED
  and ends with a return code zero / RC0.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS who use panel ADB2USO 'Specify Utility  *
  *                 Options - REORG' to perform a REORG on a     *
  *                 table space.                                 *
  ****************************************************************
  * PROBLEM DESCRIPTION: The DB2 Administration Tool for z/OS    *
  *                      panel ADB2USO 'Specify Utility Options  *
  *                      - REORG' allows 'SHRLEVEL N' to be      *
  *                      specified for a LOB table space in      *
  *                      DB2 10 New Function Mode (NFM), which   *
  *                      results in the message:                 *
  *                                                              *
  *                      DSNU126I >ssid< nnn nn:nn:nn.nn         *
  *                      DSNURFIT - REORG SHRLEVEL NONE          *
  *                      ON LOB TABLE SPACE IS                   *
  *                      NO LONGER SUPPORTED                     *
  *                                                              *
  *                      and ends with a return code 0 / RC0.    *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Program needs to check whether SHRLEVEL NONE is specified on a
  LOB table space when running on DB2 10 NFM or higher.
  

Problem conclusion

• Panel ADB2USO will issue message ADB346Q when SHRLEVEL NONE is
  specified on a LOB table space when running on DB2 10 NFM or
  higher.
  
  ADB346Q SHRLEVEL NONE is invalid on a LOB table space
  

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:

  UK95884 UK95885

Modules/Macros

• ADB2USO
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA10 PSY UK95884

     UP13/07/18 P F307

• RA20 PSY UK95885

     UP13/07/18 P F307

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.