Finding the SQLCA

The SQLCA is especially valuable for diagnosing abends with a completion code of X'04E' and an abend reason code that begins with X'00E7'.

About this task

When abends occur, the SQLERRP field contains the name of the CSECT for the code that issued the abend. The SQLERRD1 field contains an internal subcode that uniquely identifies the location within the CSECT where the error was detected. The SQLERRM field contains an optional error description.

Procedure

To find the SQLCA:

  1. Start of changeLocate the CTRDSP field at offset X'30' in the CT. This field contains the address of the RDA (relational data area). End of change

    If this field contains a fullword of zero, there is no SQLCA associated with this dump. Do not continue with this procedure.

  2. Start of changeFind the RDASQLCA field at offset X'158' in the RDA. This field contains the address of the SQLCA. At that address, the SQLCA eye-catcher is displayed.End of change

Results

Figure 1. Finding the SQLCA
Begin figure description. This figure displays how to find the SQLCA. End figure description.

The SQLCA is especially valuable for abends with a completion code of X'04E' and an abend reason code that begins with X'00E7' (for example, 00E70005).

Sample SQLCA control blocks

The following figure shows a portion of an SQLCA in the formatted section of an SVC dump.

Figure 2. Sample SQLCA control block (formatted)
SQLC (00675) ADDR=7F6446A0 ASID=0016 VVV=00   FROM: RDA  (00673) OFFSET=0008
    0000  E2D8D3C3 C1404040 00000088 00000000   00004040 40404040 40404040 40404040  *SQLCA   ........        *
    0020  40404040 40404040 40404040 40404040   40404040 40404040 40404040 40404040  *                        *
             0040 TO 005F  SAME AS ABOVE
    0060  00000000 00000000 00000000 FFFFFFFF   00000000 00000000 40404040 40404040  *....................... *
    0080  00000000 00000000                                                          *.......                 *
The following figure shows this portion of the SQLCA as it is displayed in the unformatted section of the SVC dump. Notice the eye-catcher, SQLCA.
Figure 3. Sample SQLCA control block (unformatted)
7F6446A0  E2D8D3C3 C1404040 00000088 00000000   00004040 40404040 40404040 40404040  
7F6446C0  40404040 40404040 40404040 40404040   40404040 40404040 40404040 40404040  
********  LINES FROM 7F6446E0 TO 7F644700 ARE THE SAME AS THE ABOVE LINE
7F644700  00000000 00000000 00000000 FFFFFFFF   00000000 00000000 40404040 40404040  
7F644720  00000000 00000000 00280400 001EC4E2   D5E3C5D7 F2F2137E A1681D9C 3E200001