DSNV086E message
When a Db2 or IRLM abend occurred, you might receive a DSNV086E message, DB2 ABNORMAL TERMINATION REASON=xxxxxxxx.
Procedure
To locate the abend completion code and the abend reason code, if there is one, and use the code in a set of keywords:
- Issue the z/OS® DISPLAY DUMP command to see whether any SVC dumps occurred near the time the message appeared. Refer to the z/OS. system commands publication, if necessary.
- If there were no SVC dumps for the abend, follow the steps
below. Otherwise, go to Step 3.
- Locate the 4-byte reason code in the message.
- Review the diagnostic information. Follow any recommended procedures.
- Build a keyword similar to ABEND04F RCxxxxxxxx,
replacing xxxxxxxx with the reason code.
Add this keyword to the string, and turn to Searching the IBM Support site for known problems and solutions.
5740XYR00 R111 ABEND04F RC00D93001 (free format) PIDS/5740XYR00 LVLS/111 AB/S004F PRCS/00D93001 (structured format)
- If there was only one SVC dump for the abend,
follow the steps below. Otherwise, go to Step 4.
- Review the dump title and verify that COMP=XYR00 or COMP=XYR01. If not, the problem might not be Db2. Use the z/OS diagnostic techniques publication to determine the failing product.
- Locate the three-character completion code that follows
the word
ABND.- If the completion code is X'071' or X'122', the operator pressed the RESTART key or canceled the job, probably to break a loop. Turn to WAIT/LOOP keywords.
- If the completion code is anything exceptX'04E', build
a keyword similar to ABENDxxx,
replacing xxx with the completion code.
Add this information to the keyword string and turn to CSECT keyword.
5740XYR00 R111 ABEND0C4 (free format) PIDS/5740XYR00 LVLS/111 AB/S00C4 (structured format) - If the completion code is X'04E', find the 4-byte reason code that follows it. For an example, see SVC dump titles that are issued by Db2.
- Review the diagnostic information for this reason code in Db2 Codes. Follow any recommended procedures.
- If the reason code is not in the ranges that are shown above,
build a keyword similar to ABEND04F RCxxxxxxxx,
replacing xxxxxxxx with the reason code.
Add this information to the keyword string and turn to CSECT keyword.
5740XYR00 R111 ABEND04E RC00E20015 (free format) PIDS/5740XYR00 LVLS/111 AB/S004E PRCS/00E20015 (structured format)
- If there were two or more SVC dumps, follow
the steps below. Otherwise, go to Step 5.
- Read the sections in Db2 Codes that describe (1) the reason code appearing in the message, and (2) any reason codes appearing in the SVC dump titles. Reason codes appear after the completion code in the SVC dump title. For an example, see SVC dump titles that are issued by Db2.
- Compare the reason codes in the SVC dumps to determine which dump relates to the DSNV086E message. Correlate the SYS1.LOGREC entry with console log time stamps.
- Use that SVC dump and follow Step 3 above.
- If there were two or more different abends,
follow the steps below:
- Determine which abend was the original cause by reviewing the time stamps in the SYS1.LOGREC entries.
- Follow Step 3 in this section, DSNV086E message.