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:
Locate the CTRDSP field at offset X'30' in the CT. This field contains the address of the RDA (relational data area).
If this field contains a fullword of zero, there is no SQLCA associated with this dump. Do not continue with this procedure.
Find 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.
Results
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.
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.