PK77534: ERROR MESSAGE HAA947E FOR REORG UTILITY WHEN SORTDATA = NO AND SHARELEVEL= CHANGE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Error Message HAA947E will still be issued when creating the
  Util Profile if SHARELEVEL CHANGE and SORTDATA = NO  are both
  selected for REORG TS. If SHARELEVEL CHANGE is selected and this
  Util Profile is used with LOB TS, the following Build messages
  will now be generated and Inline copies and SORTDATA will be
  turned of and LOG willturned off and LOG will be set to YES:
  HAAB095I TS dbname tsname 00000 Online Reorg Tablespace Utility
  notsupported on LOB Tablespaces; Share level changed to NONE.
  HAAB091I TS dbname tsname  00000 Logging for Reorg Tablespace
  Utilityhas been set to LOG YES for this LOB Tablespace.
  HAAB169I TS dbname tsname  00000 Reorg Tablespace Option
  SORTDATA is not supported on LOB Tablespaces; Option removed.
  HAAB092I TS CSMARKQM CQM22ET2 00000 Inline copy for Reorg
  Tablespace Utility has been turned off for this LOB Tablespace.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Query Monitor.                  *
  ****************************************************************
  * PROBLEM DESCRIPTION: Error Message HAA947E will still be     *
  *                      issued when creating the Util Profile   *
  *                      if SHARELEVEL CHANGE and SORTDATA = NO  *
  *                      are both selected for REORG TS. If      *
  *                      SHARELEVEL CHANGE is selected and this  *
  *                      Util Profile is used with LOB TS, the   *
  *                      following Build messages will now be    *
  *                      generated and Inline copies and         *
  *                      SORTDATA will be turned of and LOG      *
  *                      will turned off and LOG will be set to  *
  *                      YES:                                    *
  *                      HAAB095I TS dbname tsname 00000 Online  *
  *                      Reorg Tablespace Utility not supported  *
  *                      on LOB Tablespaces; Share level         *
  *                      changed to NONE.                        *
  *                      HAAB091I TS dbname tsname  00000        *
  *                      Logging for Reorg Tablespace Utility    *
  *                      has been set to LOG YES for this LOB    *
  *                      Tablespace.                             *
  *                      HAAB169I TS dbname tsname  00000        *
  *                      Reorg Tablespace Option SORTDATA is     *
  *                      not supported on LOB Tablespaces;       *
  *                      Option removed.                         *
  *                      HAAB092I TS CSMARKQM CQM22ET2 00000     *
  *                      Inline copy for Reorg Tablespace        *
  *                      Utility has been turned off 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:

  UK44004

Modules/Macros

• HAA#UTED HAAALA
  

Fix information

• Fixed component name

  DB2 AUTOMATION

• Fixed component ID

  5697G6300

Applicable component levels

• R220 PSY UK44004

     UP09/02/19 P F902

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.