PK99594: SYSREC KEYWORD MAY BE GENERATED UNNECCESSARILY

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When performing a tablespace REORG with SHRLEVEL CHANGE
  specified and no CLUSTERING INDEX exists, SYSREC is not required
  as DB2 will use the first NPI as an implicit clustering index
  during REORG, making the SYSREC file unnecessary.
  Automation Tool generates the SYSREC DD and suppresses the
  NOSYSREC keyword.  This behavior will change so that Automation
  Tool will now generate the NOSYSREC keyword and suppress the
  SYSREC DD.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Automation Tool.                *
  ****************************************************************
  * PROBLEM DESCRIPTION: When performing a tablespace REORG      *
  *                      with SHRLEVEL CHANGE specified and no   *
  *                      CLUSTERING INDEX exists, SYSREC is not  *
  *                      required as DB2 will use the first NPI  *
  *                      as an implicit clustering index during  *
  *                      REORG, making the SYSREC file           *
  *                      unnecessary. Automation Tool generates  *
  *                      the SYSREC DD and suppresses the        *
  *                      NOSYSREC keyword.  This behavior will   *
  *                      change so that Automation Tool will     *
  *                      now generate the NOSYSREC keyword and   *
  *                      suppress the SYSREC DD.                 *
  ****************************************************************
  * 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

• HAA483E
  

Fix information

• Fixed component name

  DB2 AUTOMATION

• Fixed component ID

  5697G6300

Applicable component levels

• R310 PSY UK55506

     UP10/03/30 P F003

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.