Interpreting trace messages

One class of messages is particularly significant because it helps identify where an error occurred (in Db2 or in an application address space, such as the call attachment facility).

This class of messages contains a line of equal signs and indicates events that occurred before and after calls to the Db2 program request handler. These messages occur in BEFORE/AFTER pairs:

BEFORE some event =====================
AFTER  some event =====================

After the BEFORE message is written, control passes from the call attachment facility to Db2. After the AFTER message is written, control has returned from Db2. If an abend occurs just after a DSNA810I BEFORE message is written, the problem probably is in Db2. Otherwise, the problem is probably in the call attachment facility or an application.

The following figure illustrates a stream of trace messages.

Figure 1. Sample call attachment facility trace stream
DSNA800I DSNACA00 TCB=008F28E8 ENTERED DSNACA00 ACTION=CONNECT R1=000082A0 CABPTR=00014360 CABFLAG1=0B CABFLAG2=00
DSNA805I DSNACA00 TCB=008F28E8 CONNECT REQUEST    SSID=AAAA  TECBP=0000740C  SECBP=00007408  RIBW=00007420
DSNA826I DSNACA00 TCB=008F28E8 BEFORE VALIDITY CHECKING THE START-UP ECB AT ADDRESS 00007408
DSNA827I DSNACA00 TCB=008F28E8 AFTER  VALIDITY CHECKING THE START-UP ECB WHICH CONTAINS 00000000
DSNA826I DSNACA00 TCB=008F28E8 BEFORE VALIDITY CHECKING THE TERMINATE ECB AT ADDRESS 0000740C
DSNA827I DSNACA00 TCB=008F28E8 AFTER  VALIDITY CHECKING THE TERMINATE ECB WHICH CONTAINS 00000000
DSNA825I DSNACA70 TCB=008F28E8 CABSSID=AAAA CABREL=310 CABDECPP=00000000
DSNA813I DSNACA70 TCB=008F28E8 FRBP=000144F8 RAL=00000000 RALE=0001 FVLE=0002 PARM=00000000 PCNT=0000
DSNA814I DSNACA70 TCB=008F28E8 RC1=0000 RC2=00000000 FBACK=00000000 RHPC=00000000 QUAL=0001 RSV1=00
DSNA810I DSNACA70 TCB=008F28E8 BEFORE IDENTIFY ==============================
DSNA811I DSNACA70 TCB=008F28E8 AFTER  IDENTIFY ==============================
DSNA813I DSNACA70 TCB=008F28E8 FRBP=000144F8 RAL=00000000 RALE=0001 FVLE=0002 PARM=000058F8 PCNT=0006
DSNA814I DSNACA70 TCB=008F28E8 RC1=0000 RC2=00000000 FBACK=008DBF90 RHPC=00000E05 QUAL=0001 RSV1=00
DSNA828I DSNACA70 TCB=008F28E8 RIB ADDRESS=00BFF220  RIBPTR ADDR=00007420
DSNA813I DSNACA70 TCB=008F28E8 FRBP=000144F8 RAL=00000000 RALE=0001 FVLE=000B PARM=00000000 PCNT=0000
DSNA814I DSNACA70 TCB=008F28E8 RC1=0000 RC2=00000000 FBACK=008DBF90 RHPC=00000E05 QUAL=0001 RSV1=00
DSNA810I DSNACA70 TCB=008F28E8 BEFORE ESTABLISH EXIT ========================
DSNA811I DSNACA70 TCB=008F28E8 AFTER  ESTABLISH EXIT ========================
DSNA813I DSNACA70 TCB=008F28E8 FRBP=000144F8 RAL=00000000 RALE=0001 FVLE=000B PARM=000058F8 PCNT=0001
DSNA814I DSNACA70 TCB=008F28E8 RC1=0000 RC2=00000000 FBACK=008DBF90 RHPC=00000E05 QUAL=0001 RSV1=00
DSNA801I DSNACA00 TCB=008F28E8 LEAVE DSNACA00  CABFLAG1=CF  CABFLAG2=00  CABPTR=00014360
DSNA800I DSNACA00 TCB=008F28E8 ENTERED DSNACA00 ACTION=OPEN R1=000082A0 CABPTR=00014360 CABFLAG1=CF CABFLAG2=00
DSNA208E DSNACA00 TCB=008F28E8 CANNOT HAVE 2 SSIDS (AAAA AND BBBB) FROM 1 TCB
DSNA807I DSNACA00 TCB=008F28E8 OPEN REQUEST   SSID=BBBB  PLAN=PLANNAME
DSNA801I DSNACA00 TCB=008F28E8 LEAVE DSNACA00  CABFLAG1=CF  CABFLAG2=00  CABPTR=00014360

Each of the four wall messages shown is either preceded by or followed by a dump of the FRB (this is dummy data). Further, message DSNA208E shows that the user committed an error: the user specified two different SSIDs on the CONNECT and OPEN calls. CAF user error messages begin with DSNA2... .

If a Db2 abend occurred during establish exit, then no trace messages appear after the second BEFORE message (DSNA810I ... BEFORE ESTABLISH EXIT =========).