Why can't I produce a PXX dump for DB Return Code xx?
search cancel

Why can't I produce a PXX dump for DB Return Code xx?

book

Article ID: 200697

calendar_today

Updated On:

Products

Datacom Datacom/AD Datacom/DB

Issue/Introduction

We have a production job that terminated with a DVW RC=22(025) but I cannot figure out what element is bad or missing. Trying to look at this error in the PXX. Where did my PXX go to? (Note: I am not using the SYSOUT MUF startup option)

I did the following:

1) Executed COMM OPTION=ALTER,RCERROR=22025,MASTERL=YES,BUFFERS=YES

2) I reran the job

3) Did a PXX Report with :REPORT AREA=PXX,DUMPS=FULL,JOBNAME=PBLJB093,RTNCODE=22

and it ultimately generated:

PXX END, PXX NOT CLOSED (MUF STILL ENABLED OR PXX WAS FULL AT EOJ) 0/00/0000 0.00.00

 

Environment

Datacom/AD 15.1

Datacom/DB 15.1

Cause

Normally, if you are not using the SYSOUT option, a snap DUMP would be written to the PXX (which requires executing a DBUTLTY PXX report to read the output). Since a RCERROR was done to overwrite the default parameter for master list dump (M) and master list dump with buffers (B), a system DUMP was taken. Buffer dumps are very large with the use of 64-bit memory for both the index and data areas and the Mult-User Facility (MUF) handles this most efficiently by requesting a system dump (IPCS) of z/OS

 

 

Resolution

Regardless of whether the SYSOUT or PXX is used to view RC xx, If the default master list dump with buffers column (B) parameter is changed, a system DUMP will be created. Reasoning behind the default setting of 'N' for column (B) is that, most of the time, it will be a user error. There could be rare instances where Datacom R&D will require you to send in a DUMP if all options have been exhausted or if the R&D team suspect that a code problem might be the issue

[NOTE: best practice recommends that you use SYSOUT instead of a physical PXX] 

Additional Information

Related article 103458: How to manage PXX Master List dumps in CA Datacom linked here

Description for return codes can be found here under Datacom messages

RCERROR Documentation can be found here

Example to (M) - (B) columns for return code 22(025) can be seen below and here in Datacom messages: 

Return Code 22 Internal Return Codes
Dec Hex Master List Dump (M) Master List Dump with Buffer (B) Explanation User Response
25 19 N N Element on the Element List is not valid for the table. Correct the program and rerun.