PH35140: DISPLAY DB(*) SP(TSNAME) RES COMMAND GOT AN ABENDS0C4 AND AN INCORRECT OUTPUT

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DISPLAY DATABASE(*) SP(tsname) RES command get an abend0C4 or
  incorrect output.
  -- sample incorrect output --
  DIS DB(*) SP(tsname) RES
  DSNT360I  +DB2A ***********************************
  DSNT361I  +DB2A *  DISPLAY DATABASE SUMMARY
                  *    RESTRICTED
  DSNT360I  +DB2A ***********************************
  DSNT362I  +DB2A     DATABASE = DSN01000  STATUS = RW
    :
    :
  DSNT311I  -DB2A MESSAGE LIMIT EXCEEDED.  ISPLAY IS TERMINATED.
  ******** TABLESPACE TSNAME NOT RESTRICTED
  ******** TABLE=   E TSNAME NOT RESTRICTED
  ABLE=   E TSMANY NOT RESTRICTED ?  ******* DISPLAY OF DATABASE
  DBPBG00
  
  IEA794I SVC DUMP HAS CAPTURED:
  DUMPID=001 REQUESTED BY JOB (DB2AMSTR)
  DUMP TITLE DB2A ABND 0C4 00000004 U=USER000 M=N C=121.GCPC
  CS-CON M=DSN9SCN9 LOC=DSN9SCN7 DSN9SCN7 OFFSET00892
  
  Additional keywords: DSNT311I MSGDSNT311I
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Db2 12 for z/OS Administrators that                      *
  * execute DISPLAY DB(*) SP(SPNAME) with                        *
  * ACTIVE, RESTRICT or ADVISORY specified.                      *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * DISPLAY DB(*) SP(SPNAME) command with                        *
  * ACTIVE, RESTRICT or ADVISORY specified                       *
  * can cause an incorrect output with                           *
  * ABEND0C4.                                                    *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply corrective PTF when available                          *
  ****************************************************************
  When the message counter hits the limit, the current command
  processor needs to return a correct return code to its caller.
  If the improper return code was returned, the output structure
  would format incorrectly and cause incorrout and ABEND0C4 in
  DSN9SCN7+00892.
  

Problem conclusion

• All the users of DISPLAY DB command should apply this PTF so
  it can fix the problem ABEND0C4 in DSN9SCN7 and incorrect
  messages.
  

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:

  UI75441

Modules/Macros

• DSNTDCST
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RC10 PSY UI75441

     UP21/05/26 P F105

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.