Log Bytes report
The Log Bytes report supplies information about the distribution of log records in the Db2 log. The Log Bytes report focuses on the type, size and distribution of log records, and not on the actual data contained in the log records.
Filters that you specify in the log scan are not used for selecting records that Log Master reports in a Log Bytes report.
Use the Log Bytes report for tuning purposes, to help you reduce unnecessary overhead in the log. The Log Bytes report displays the following information about log records:
- Counts of log record types
- Total number of bytes used by the log records
- Percentage of space the log records use
To request a Log Bytes report
- From any task dialog (any option from 0 through 7 under the Actions category on the Main Menu), select the Define Report and File Outputs option.
- On the Output Options panel, select Log Bytes.
When you generate a Log Bytes report, Log Master cannot include any other forms of output in the same log scan, such as other reports or SQL. To generate other forms of output for the same work ID add an additional separate log scan step.
Example of a Log Bytes report
Log Bytes report contents
The information presented in the Log Bytes report is grouped into the following sections:
- URID records
- data management records, reported by table space (DBID and PSID), and divided into the following record subtypes:
- inserts, updates, and deletes (This section includes XML records.)
- compensation
- index
- space map
- page format
- pointer update
- page compaction
- pageset (open, close, and write)
- locking
- LOB
- database exception (DBE) table update
- DBE table with piece data
- checkpoint records
- diagnostic records
- SYSCOPY records
- system event records
- miscellaneous records
- DB2 page overhead information, including totals for
- number of pages
- amount of CI bytes on those pages
- amount of free space on the pages
Log Bytes report ordering
Log Master orders most sections of the Log Bytes report by DB2 record type and subtype. Log Master orders records in the diagnostic records section by member ID, and includes information about each member.
You can order this report by the following unit of recovery (URID) options:
- Plan name
- Authorization ID
- Connection type
- Connection ID
- Correlation ID