DB2 abend completion codes (X'04E' and X'04F)

X'04E' and X'04F' system abend completion codes identify internal errors encountered during DB2® operation, diagnostic information for problem determination, and subsystem actions initiated by the DB2 subcomponent involved in the error.

An X'04E' abend completion code indicates that DB2 detected an internal error and abended a DB2 internal task (TCB) or a user-connected task. Errors associated with an X'04E' abend completion code might be preceded by an MVS™ system code or by internal errors. The diagnostic material generated by the X'04E' abend must be examined to determine the source of the error that actually resulted in a subsequent task or subsystem termination.

An X'04F' abend completion code indicates that DB2 detected a severe error and abended the entire DB2 subsystem. When an X'04F' is issued, DB2 determined that continued operation could result in the loss of data integrity. Errors associated with an X'04F' abend completion code might be preceded by an MVS system error or by one or more DB2 X'04E' abend completion codes.

The following table summarizes the diagnostic information and subsystem actions available to DB2 when these abend completion codes are issued. Some pieces of this information are not relevant to some error situations and will not help in problem diagnosis. In these cases, DB2 does not produce any diagnostic information that is unnecessary. The information that DB2 produces for a given error depends upon the specific problem. The MVS services that provide diagnostic information are discussed in z/OS diagnostic services

Table 1. Abend completion codes
  X'04E' X'04F'
Explanation Error during DB2 normal operation Severe error; continued operation may jeopardize data integrity
System action
  • Internal DB2 task is abended
  • Connected user task is abended
  • The entire DB2 subsystem is abended
  • User task with an active DB2 connection may be abnormally terminated with an X'04F'
  • Possible MEMTERM (memory termination) of connected allied address space
Diagnostic information
  • SVC dump
  • SYS1.LOGREC entries
  • VRA data entries
  • SYS1.LOGREC entries
  • VRA data entries
Associated reason codes
  • DB2 abend reason code
  • Associated MVS system codes
  • Subsystem termination reason code
  • MVS system completion codes and X'04E' codes that precede the X'04F' abend
Location of accompanying codes
  • SVC dump title
  • Message DSNW050I
  • Register 15 of SDWA section "General Purpose Registers at Time of Error"
  • SYS1.LOGREC entries
  • VRA data entries
  • SYS1.LOGREC entries
  • VRA data entries
  • Message DSNV086E, which is sent to MVS system operator