The available trace points and the resulting trace data are as follows:
Trace Point | Trace Data |
---|---|
Point 1 | Start of VSAM Call Data presented:
|
Point 3 | Open a DB2® cursor Data presented:
|
Point 4 | DB2 Cursor Fetch Data presented:
|
Point 5 | Close DB2 Cursor Data presented:
|
Point 6 | Build Record Field from DB2 Record
Data presented:
|
Point 7 | Build DB2 Column from Record Field Data presented:
|
Point 8 | End of Call Data presented:
|
Point 9 | After a DB2 INSERT, REPLACE or DELETE call Data presented:
|
Trace points 3, 4, and 5 trace SQL events and show the SQL code returned by DB2. Trace point 6 for GET type calls and point 7 for WRITE or REWRITE calls can produce many lines of output. Only use these when it is essential to see data at the field level.