Interpreting trace messages
Use the RRSAF trace messages to help diagnose a problem.
Each entry in the trace table has the format shown in the following table.
| Bytes | Contents of Field |
|---|---|
| 1-4 | Abbreviation for the RRSAF function performed:
|
| 5-8 | If the function is 'SQL ', the SQLCODE. Otherwise, the RRSAF return code. |
| 9-12 | RRSAF reason code. |
| 13 | Value of flag RRBFLAG1 after function completes |
| 14 | Value of flag RRBFLAG1 before function starts |
| 15 | Value of flag RRBFLAG2 after function completes |
| 16 | Value of flag RRBFLAG2 before function starts |
All functions that begin with SPAS are
functions that Db2 performs
for stored procedures running in a WLM-established address space.
RRSAF writes one entry before it runs a function and another entry after it runs the function.
After the before entry
is written, control passes from RRSAF to Db2.
After the after entry is written, control has returned
from Db2. If an abend occurs
just after a before message is written, the problem
is probably in Db2. Otherwise,
the problem is probably in RRSAF or the application.
The following figure shows an example of RRSAF trace output in a dump.
1 2 3
43301D20 43301BB0 43300CAE 43301BB8 00000000 C3300C08 0000000D 0000000C D9D9E2C1 *................C...........RRSA*
4 5 6 7
43301D40 C640E3D9 C1C3C540 6E6E6E6E C9C4C5D5 00000000 00000000 CB000100 E2C9C7D5 *F TRACE >>>>IDEN............SIGN*
43301D60 00000000 00000000 CFCB0101 C3E3C8C4 00000000 00000000 EFCF0101 E2D8D340 *............CTHD............SQL *
43301D80 00000000 00000000 FFFF0101 E2D8D340 00000000 00000000 FFFF0101 E2D8D340 *............SQL ............SQL *
43301DA0 00000000 00000000 FFFF0101 E2D8D340 00000000 00000000 FFFF0101 E2D8D340 *............SQL ............SQL *
43301DC0 00000000 00000000 FFFF0101 E2D8D340 00000000 00000000 FFFF0101 E2D8D340 *............SQL ............SQL *
43301DE0 00000000 00000000 FFFF0101 E2D8D340 00000000 00000000 FFFF0101 E2D8D340 *............SQL ............SQL *
8
43301E00 00000000 00000000 FFFF0101 E2D8D340 00000000 00000000 FFFF0101 00000000 *............SQL ................*
| Figure Label | Description |
|---|---|
| 1 | Number of entries in the trace table |
| 2 | Index of the last entry in the trace table |
| 3 | Eye-catcher RRSAF TRACE >>>> |
| 4 | Beginning of the first trace record, which records an RRSAF IDENTIFY function |
| 5 | Return code for the IDENTIFY function |
| 6 | Reason code for the IDENTIFY function |
| 7 | RRSAF flags |
| 8 | Beginning of the last trace record, which records an SQL statement |