PI74845: REORG DISPLAY CLAIMERS GETS MSGDSNT325I 17/01/12 PTF PECHANGE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• APAR PI66432 tightened syntax checking on the DISPLAY DATABASE
  command.  As a result REORG use of DISPLAY CLAIMERS when using a
  range of parts fails with
  
  DSNT325I  INVALID PARTITION SPECIFICATION - CHECK SYNTAX
  DSN9023I  DSNTDDIS 'DISPLAY DATABASE' ABNORMAL COMPLETION
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All DB2 12 for z/OS users of REORG SHRLEVEL REFERENCE or     *
  * CHANGE utility with PI66432/UI41281 applied.                 *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * After applying PI66432/UI41281, MSGDSNT325I and MSGDSN9023I  *
  * were issued during the -DISPLAY CLAIMERS command from a      *
  * REORG SHRLEVEL CHANGE on a range of partitions of a          *
  * partitioned table space after a drain failure.               *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply corrective PTF when available.                         *
  ****************************************************************
  After PI66432/UI41281 was applied, the DISPLAY DB SP CLAIMERS
  command issued during a REORG SHRLEVEL CHANGE on a range of
  partitions failed.  REORG was unable to obtain a drain on the
  object during the SWITCH phase and issued MSGDSNU590I - RESOURCE
  NOT AVAILABLE, REASON= X'00C200EC'.  This was followed by
  DSNT325I - INVALID PARTITION SPECIFICATION - CHECK SYNTAX and
  DSN9023I - DSNTDDIS 'DISPLAY DATABASE' ABNORMAL COMPLETION.
  PI66432 changed the specification of the PART range delivered to
  the -DISPLAY DB command.  The REORG utility was not changed to
  support this change. The same problem can happen for REORG
  SHRLEVEL REFERENCE.
  Additional Keywords: DSNT325I DSN9023I RC00C200EC DSNU590I
  

Problem conclusion

• The REORG utility has been modified to pass the part range
  correctly when issuing a -DISPLAY DATABASE SPACE CLAIMERS
  command after a drain failure.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

  PI74760

• APAR is sysrouted TO one or more of the following:

  UI44766

Modules/Macros

• DSNUGDSP DSNTDDIS
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RC10 PSY UI44766

     UP17/03/04 P F703 {

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.