IMS attachment facility trace diagnosis guidelines

Several steps can be taken to use the IMS attachment facility trace to help diagnose problems.

  1. To determine if the problem occurred in the application program, see if the address in the PSW at the time of error falls within the address range of the application program.
  2. Try to determine the cause of failure by reviewing abend completion code at the beginning of the dump.
    • If the abend completion code indicates a user abend, then try to find an explanation for that user abend completion code in the IMS messages and codes publication.
    • If the abend completion code is a system X'04E' or X'04F', locate the Db2 abend reason code value in register 15 and look up the reason code value in Db2 reason codes.
  3. Locate the application program's last (most recent) save area.
  4. Determine the last event the application program performed before the failure.
  5. If the last event was a SQL call, locate the highest sequence number in the IMS attachment facility trace table. (The entry with the highest sequence number is the most recent.) Look at the WALTAREA trace area first to find the connection status.
  6. Analyze that entry to see at what control status point the call is, by using the information in Table 2.
  7. If the trace entry is complete (control status points A and E are nonblank), then analyze the WAU trace.
  8. Looking at these trace tables should help in identifying where the problem occurred (that is, if it occurred in Db2, in the IMS attachment facility, or in IMS), and it should help identify the events that were occurring at the time of the failure (for example, a trace identifier of TRMT indicates that a thread has been terminated).
  9. The Db2-DL/I batch support is packaged as part of the Db2 IMS attachment facility. Follow the procedures in Type-of-failure keywords when reporting problems with the Db2-DL/I batch support. Abends produced by the Db2-DL/I batch support are either SYSABEND or SYSUDUMP dumps. A SYS1.LOGREC entry is normally not produced.