PK59061: ADMIN UTIL REORG DEFAULTS OPTIONS CAUSE RC=08 DSNU076I DSNURFIT MESSAGES FOR LOB TABLESPACES KEYWORD='LOG NO' INVALID

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Administration Tool UTIL command generated REORG syntax
  which is invalid for LOB tablespaces resulting in a RC=08and
  DSNU076I  ssid- DSNURFIT - KEYWORD='LOG NO' INVALID FOR REORG
  LOB TABLE SPACE=aaaaaaaa.aaaaaaaa
  error messages.
  

Local fix

• Remove the following keywords from the REORG syntax:
  'LOG NO'
  'SORTDEVT'
  'SORTNUM'
  'SORTDATA'
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: DB2 Admin Tool and Object Compare            *
  *                 users who perform REORGs on LOB              *
  *                 tablespaces.                                 *
  ****************************************************************
  * PROBLEM DESCRIPTION: DB2 Admin Tool created control cards    *
  *                      for REORG of a LOB tablespace which     *
  *                      were incorrect.                         *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  DB2 Admin Tool created control cards with LOG NO SHRLEVEL NONE
  for REORG of a LOB tablespace when Review/Change Options was
  set to NO.
  

Problem conclusion

• Changed code generates LOG YES SHRLEVEL NONE for REORG of LOB
  tablespaces with Options set to 'NO', except when done with
  inline copy in DB2 Version 9, in which case LOG NO SHRLEVEL
  REFERENCE are generated.
  

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:

  UK36513

Modules/Macros

•    ADB2AUH  ADB2US   ADB2USOP
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• R710 PSY UK36513

     UP08/05/28 P F805

• R720 PSY UK36514

     UP08/05/30 P F805

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.