PM63168: DSNU076I KEYWORD='STATISTICS' INVALID FOR REORG LOB TABLE SPACE=DSNDB01.SYSDBDXA

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When using Automation Tool to build a Reorg for database DSNDB01
  on DB2 V10 and requesting inline statistics, the following error
  can occur when the Reorg is executed:
  DSNU076I- KEYWORD='STATISTICS' INVALID FOR REORG LOB TABLE
  SPACE=DSNDB01.SYSDBDXA
  
  The STATISTICS keyword is not valid for LOB table spaces.
  Automation Tool should separate SYSDBDXA into a LISTDEF that
  does not include the STATISTICS keyword.
  

Local fix

• Manually update the Reorg job to remove the STATISTICS keyword
  for tablespace DSNDB01.SYSDBDXA.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Automation Tool.                *
  ****************************************************************
  * PROBLEM DESCRIPTION: When using Automation Tool to build a   *
  *                      Reorg for database DSNDB01 on DB2 V10   *
  *                      and requesting inline statistics, the   *
  *                      following error can occur when the      *
  *                      Reorg is executed:                      *
  *                      DSNU076I- KEYWORD='STATISTICS' INVALID  *
  *                       FOR REORG LOB TABLE                    *
  *                       SPACE=DSNDB01.SYSDBDXA                 *
  *                      The STATISTICS keyword is not valid for *
  *                      LOB table spaces. Automation Tool       *
  *                      should separate SYSDBDXA into a         *
  *                      LISTDEF that does not include the       *
  *                      STATISTICS keyword.                     *
  ****************************************************************
  * 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:

  UK79919 UK79920

Modules/Macros

• HAA#LDEP HAA#LOBC HAA#OBEX
  

Fix information

• Fixed component name

  DB2 AUTOMATION

• Fixed component ID

  5697G6300

Applicable component levels

• R310 PSY UK79919

     UP12/07/08 P F207

• R410 PSY UK79920

     UP12/07/08 P F207

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.