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.

Table 1. Description of an RRSAF trace record
Bytes Contents of Field
1-4 Abbreviation for the RRSAF function performed:
  • 'SQL ' - SQL operation
  • 'IFCA' - IFC API call
  • 'IFCX' - IFC Translate call
  • 'IDEN' - IDENTIFY
  • 'CTHD' - CREATE THREAD
  • 'TTHD' - TERMINATE THREAD
  • 'TIDY' - TERMINATE IDENTIFY
  • 'SIGN' - SIGNON
  • 'ASIN' - AUTH SIGNON
  • 'XLAT' - TRANSLATE
  • 'S_ID' - SPAS_ID
  • 'S_IN' - SPAS_INIT_SP
  • 'S_TM' - SPAS_TERM_SP
  • 'S_SV' - SPAS_SERV_SP
  • 'S_DS' - SPAS_DISC
  • 'ASSO' - ASSOCIATE THREAD
  • 'DSSO' - DISSOCIATE THREAD
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.

Figure 1. Sample RRSAF trace stream
                                                          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