PK99595: GENERATING A REORG WITH SORTDATA Y COULD RESULT IN CONFUSING INFORMATIONAL MESSAGE - HAAB169I

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Generating a REORG with SORTDATA Y could result in confusing
  informational message - HAAB169I.  HAAB169I currently contains
  this text:
  "HAAB169I TS xxxxxxxx yyyyyyyy 00000 Reorg Tablespace Option
  SORTDATA is not supported on LOB Tablespaces; Option removed"
  The SORTDATA option is, in fact, included for the REORG of the
  tablespace, it is just included as "SORTDATA NO".
  The text for this message will now read:
  "HAAB169I TS xxxxxxxx yyyyyyyy 00000 Reorg Tablespace Option
  SORTDATA has been set to SORTDATA NO for this LOB Tablespace"
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Automation Tool.                *
  ****************************************************************
  * PROBLEM DESCRIPTION: Generating a REORG with SORTDATA Y      *
  *                      could result in confusing informational *
  *                      message - HAAB169I.  HAAB169I currently *
  *                      contains this text:                     *
  *                      "HAAB169I TS xxxxxxxx yyyyyyyy 00000    *
  *                      Reorg Tablespace Option SORTDATA is not *
  *                      supported on LOB Tablespaces; Option    *
  *                      removed"                                *
  *                      The SORTDATA option is, in fact,        *
  *                      included for the REORG of the           *
  *                      tablespace, it is just included as      *
  *                      "SORTDATA NO". The text for this        *
  *                      message will now read:                  *
  *                      "HAAB169I TS xxxxxxxx yyyyyyyy 00000    *
  *                      Reorg Tablespace Option SORTDATA has    *
  *                      been set to SORTDATA NO for this LOB    *
  *                      Tablespace"                             *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  Code has been changed to correct this condition.
  

Problem conclusion

• APPLY the PTF.
  

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

• HAA#OBEX
  

Fix information

• Fixed component name

  DB2 AUTOMATION

• Fixed component ID

  5697G6300

Applicable component levels

• R310 PSY UK51734

     UP09/11/10 P F911

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.