You can request up to three reports:
- DB2(LIST) requests the DB2® List report (see List report).
- DB2(LONG) requests the DB2 Long Summary report (see Long Summary report).
- DB2(SHORTSUM) requests the DB2 Short Summary report (see Short Summary report). This is the default.
The Recap report is always produced at the end of DB2 report processing (see
Recap report).
In the DB2 report, all numeric
fields are formatted to 8 bytes.
The following abbreviations can appear in numeric fields:
- N/A
- Occurs when the field is not applicable. For example, DB2 Connection Wait Time is not
applicable when DB2REQCT=0. Also, in the Recap report, various DB2 record and matching statistics
are not applicable when no DB2 records
are selected, hence no record matching takes place.
- N/C
- Occurs when a value cannot be calculated. For example, in the
Recap report, when the ‘% of Total' field cannot be calculated
because the total is zero.
- N/P
- Occurs when the data is not present. For example, in the DB2 List or Long Summary reports,
when DB2 details are requested
that are not present in the DB2 Accounting
records. For example, you requested Class 3 details when only DB2 Accounting Classes 1 and 2 were
traced.