Output formats
The output format is the same as the online displays; it is 80 characters wide, with the first position reserved for the attribute character. For normal output, the data is printed in columns 2 through 80.
For wide output, the highest level that has been requested is left aligned and lower levels are indented for ease of viewing. STRAC and DTRAC are indented 5 positions and the pop-up displays are indented 40 positions. For example, if DTRAC and pop-up displays are the only reports requested, DTRAC is aligned on the left margin, and pop-up displays are indented 40 positions. If LTRAC, STRAC, DTRAC, and pop-up displays are requested, LTRAC lines are aligned on the left margin, STRAC is indented 5 positions, DTRAC is indented 10 positions, and pop-up displays are indented 50 positions.
The following figure shows the format of the common headers that appear in every report.
REPORT XXXXXXXX SECONDARY TITLE DATE: 17SEP02
TIME:15:31:44
DSNAME: SYS5.PRODSYS.DB2D.BLANK.OCT03.T0501.V01
VOLSER: BAB033
TITLE: ACCOUNTING TRACE TYPE: DETAIL
START: 19SEP02 05:01:00 GROUP SQL: N
STOP: 16SEP02 23:58:55 SCANS: Y
STATUS: USED I/O: Y
DATA LOST: NO LOCKS: Y
REQUESTOR: CIR8 DDF: Y
TRACEID: DDFVTAM: Y
TARGET: DB2D
DB2PLAN:
DB2AUTH:
DB2CONN:
DB2CORR:
DB2LOC:
EXCEPTION FILTERS:
ELAP => GETPAGE => MAXLOCK => SQLDDL =>
CPU => PGUPD => LOCKTBL => SQLDYN =>
ABORT => READIO => INCRBIND => SQLCTL =>
UIDCOM => LOCKSUSP => SQLSEL => SQLFETCH =>
GETRIO => LOCKESCL => SQLUID => SQLTOT =>
RLF => TIMEOUT => RIDFAIL => CLAIMDR =>
PWAITIO => PWAITLK => PWAITPF => PWAITOT =>
PFREQS => PFREADS => HPFAILS => PRLLGRP =>
PRLLRED => PRLLFALB => =>
...FIRST DATA LINE (NEW PAGE IF NEWPAGE ^= NO)
_
_
_
This header is printed as each input data set is processed. If reports other than summary reports are requested, the headings are embedded within the body of the reports. If only summary reports (TSTAT and TSUM) are requested, all heading blocks are shown before the summary reports.
The date and time shown at the top right reflect the time the report is produced. The date and time of the data can be seen within the reports and from the START and STOP time of trace data recording on this data set (as shown in lines 6 and 7 of this header).
Lines 3 and 4 identify the input data sets. The remaining lines show the options specified when the trace was made. For more information, see Db2-application-trace-ATRAC.
For narrow or wide reports, the heading lines fill the entire width of the report. The values on the right are right-justified with the right margin. The main title and the secondary title are centered in the report.
Within the body of the report, the displayed values are identical to the screens from the corresponding online trace display, such as LTRAC or STRAC. If LTRAC or DTRAC is requested, the column headings are shown at the start of each data stream and at the top of each page as secondary headings.
This section contains the following topics: