PH24705: DISPLAY DATABASE COMMAND WITH RESTRICT LIMIT(*) ABENDS0C4 PIC11 IN DSNTDSTG OFFSET00210

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• ABEND0C4 RC00000011 RC11 DSNTDSTG+00210 seen for -DISPLAY
  DATABASE command with RESTRICT LIMIT(*) and the below dump
  produced :
  
  DT21,ABND=0C4-00000011,U=SYSOPR ,M=N ,C=121.SCC
  -DBCMND ,M=DSNTFRCV,LOC=DSNTDC .DSNTDSTG+00210
  
  Additional symptoms: ABEND0C4 PIC11 DSNTDMST+03F96 OFFSET03F96
                       CLAIMERS LIMIT(*) DSNTDMST+02286
                       OFFSET02286 -DIS DB(xxxxxxx) SPACE(*)
                       LIMIT(*)
  
                       ABEND0C4 PIC04 DSNTDCST+03188 OFFSET03188
                       ABEND0C4 PIC04 DSNXKBLM+00CA2 OFFSET00CA2
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Db2 V12 for z/OS Administrators that                     *
  * execute DISPLAY DB command.                                  *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Several jobs of DISPLAY DB commands                          *
  * were canceled and abended at different                       *
  * modules: DSNTDMST, DSNTDSTG and                              *
  * DSNTDMUL.                                                    *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply corrective PTF when available                          *
  ****************************************************************
  There are multiple workloads that are running multiple jobs
  with the DISPLAY DB commands. Some of them were canceled
  and caused the abends at the different place such as:
  -DIS DATABASE( ) SPACE() RESTRICT LIMIT(*)
  DT21,ABND=0C4-00000011,U=SYSOPR ,M=N ,C=121.SCC -DBCMND ,
  M=DSNTFRCV,LOC=DSNTDC .DSNTDSTG+00210
  -DIS DB(DSNDB06 ) SP() CLAIMERS LIMIT(*)
  DT23,ABND=0C4-00000011,U=SYSOPR ,M=N ,C=121.SCC -DBCMND ,
  M=DSNTFRCV,LOC=DSNTDC .DSNTDMST+03F96
  

Problem conclusion

• The fix is to ensure the buffer pool used
  by DISPLAY DB command is freed only when
  no module is accessing it.
  

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:

  UI69570

Modules/Macros

• DSNTDDIS
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RC10 PSY UI69570

     UP20/05/27 P F005

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.