IBM Support

PH06368: DISPLAY USE COMMAND DURING REORG INDEX GIVES UNEXPECTED RESULTS

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • During REORG INDEX, some displays are not providing expected
    information for that index (IXYYYYYY).
                                                                   .
    Example 1) :
     -DSN  DIS DB(DBXXXXXX) SP(*) LIMIT(*) USE ONLY
     DSNT360I  -DSN  ***********************************
     DSNT361I  -DSN  *  DISPLAY DATABASE SUMMARY 780
                     *    GLOBAL USE
     DSNT360I  -DSN  ***********************************
     DSNT362I  -DSN      DATABASE = DBXXXXXX  STATUS = RW
                        DBD LENGTH = 238232
     DSNT397I  -DSN  783
     NAME     TYPE PART  STATUS  CONNID   CORRID     USERID
     -------- ---- ----- ------- -------- ---------- --------
     ******** NO SPACES FOUND
     ******* DISPLAY OF DATABASE DBXXXXXX ENDED    **********
     .
     In the DIS USE ONLY the expected index is not in the list.
    Example 2) :
     -DSN  DIS DB(DBXXXXXX) SP(*) LIMIT(*) RESTRICT USE
     DSNT360I  -DSN  ***********************************
     DSNT361I  -DSN  *  DISPLAY DATABASE SUMMARY 590
                     *    RESTRICTED USE
     DSNT360I  -DSN  ***********************************
     DSNT362I  -DSN      DATABASE = DBXXXXXX  STATUS = RW 592
                        DBD LENGTH = 238232
     DSNT397I  -DSN  593
     NAME     TYPE PART  STATUS   CONNID   CORRID     USERID
     -------- ---- ----- -------- -------- ---------- --------
     IXYYYYYY IX   L0001 RW,UTRW
         -THRU      0006
     IXYYYYYY IX    L*
     ******* DISPLAY OF DATABASE DBXXXXXX ENDED      *********
     .
     In the DIS RESTRICT USE the expected index is present but not
    the corrid / userid .
    

Local fix

  • N/A
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All Db2 11 and 12 for z/OS users who use     *
    *                 Display Database command with USE or         *
    *                 RESTRICT USE keyword.                        *
    ****************************************************************
    * PROBLEM DESCRIPTION: Display database USE or RESTRICT USE    *
    *                      command issued on non partitioned       *
    *                      secondary index during REORG INDEX      *
    *                      gives unexpected results.               *
    ****************************************************************
    * RECOMMENDATION: Apply corrective PTF when available.         *
    ****************************************************************
    During REORG INDEX for non partitioned secondary index(NPI),
    Display database command with USE or RESTRICT USE keyword
    does not provide expected information for the NPI.
    Db2 does not return correct NPI claims/drains information
    internally. This causes the display database command to not
    reflect the NPI index related information in the list.
    
    Here is an example:
    -db2adis db(DB42PCT) SP(*) RESTRICT USE
    DSNT360I  -DB2A ***********************************
    DSNT361I  -DB2A *  DISPLAY DATABASE SUMMARY
                    *    RESTRICTED USE
    DSNT360I  -DB2A ***********************************
    DSNT362I  -DB2A     DATABASE = DB42PCT  STATUS = RW
                        DBD LENGTH = 16142
    DSNT397I  -DB2A
    NAME     TYPE PART  STATUS          CONNID   CORRID     USERID
    -------- ---- ----- -------------- -------- ----------  -------
    ******** NO SPACES FOUND
    ******* DISPLAY OF DATABASE DB42PCT  ENDED      ***************
    
    Please note that the expected index is not in the above list.
    
    Here follows the expected output list:
    -db2adis db(DB42PCT) SP(*) RESTRICT USE
    DSNT360I  -DB2A ***********************************
    DSNT361I  -DB2A *  DISPLAY DATABASE SUMMARY
                    *    RESTRICTED USE
    DSNT360I  -DB2A ***********************************
    DSNT362I  -DB2A     DATABASE = DB42PCT  STATUS = RW
                        DBD LENGTH = 16142
    DSNT397I  -DB2A
    NAME     TYPE PART  STATUS       CONNID   CORRID   USERID
    -------- ---- ----- ----------- -------- --------- --------
    PXPXPKPT IX   L0001 RW,UTRW
    PXPXPKPT IX    L*                UTILITY  REORG1   ADMF001
    - ******* DISPLAY OF DATABASE DB42PCT  ENDED  *****************
    

Problem conclusion

  • Fix made in Db2 to correctly display the expected information
    on the NPI for the Display Database command with USE or
    RESTRICT USE keyword during REORG INDEX.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PH06368

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    B10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2018-12-11

  • Closed date

    2019-03-25

  • Last modified date

    2019-05-02

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

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

    UI62142 UI62143

Modules/Macros

  •    DSNIDSTT
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • RB10 PSY UI62143

       UP19/04/12 P F904

  • RC10 PSY UI62142

       UP19/04/12 P F904

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.

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSEPEK","label":"Db2 for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M","label":"APARs - z\/OS environment"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.0","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
02 May 2019