PH06595: DSNACCOX GETS RC0 WHEN -DIS DB(*) SP(*) LIMIT(*) ADV COMMAND RETURNS DSNT306I MESSAGE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DSNACCOX with RESTRICT option gets DSNT306I message when issuing
  -DIS DB(*) SP(*) LIMIT(*) ADV command.
  
  With this DSNT306I, DSNACCOX returns RC0 or RC4. Output will not
  contain all objects.
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All Db2 11 for z/OS and Db2 12 for z/OS      *
  *                 DSNACCOX stored procedure users.             *
  ****************************************************************
  * PROBLEM DESCRIPTION: DSNACCOX intermittently returned RC=0,  *
  *                      when only checking partial objects with *
  *                      pending state due to storage            *
  *                      limitation.                             *
  ****************************************************************
  * RECOMMENDATION: Apply corrective PTF when available          *
  ****************************************************************
  DSNACCOX checks the objects with pending state using DISPLAY
  DATABASE command. When the DISPLAY DATABASE is prematurely
  terminated because there are more objects than can be
  processed, DSNACCOX does not handle the termination message
  correctly.
  

Problem conclusion

• DSNACCOX has been changed to end with return code 4 when DISPLAY
  DATABASE is prematurely terminated
  

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:

  010PC2Ÿ UI61164 010PC2Ÿ 010PC2Ÿ UI61187

Modules/Macros

•    DSN@CCOX DSNACCOX
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RB10 PSY UI61187

     UP19/02/23 P F902

• RC10 PSY UI61164

     UP19/02/21 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.