Syntax

>>-onlog-------------------------------------------------------->
 
                               (1)                                  (2)
>--| Log-Record Read Filters |-------| Log-Record Display Filters |------->
 
>--+-----+-----------------------------------------------------><
   '- -q-'
 

1. See page Log-Record Read Filters
2. See page Log-Record Display Filters

Read Filters

You direct onlog to read the following portions of the logical log as it searches for records to display:

• Records stored on disk
• Records stored on backup media
• Records from the specified logical-log file

By default, onlog displays the logical-log record header, which describes the transaction number and the record type. The record type identifies the type of operation performed.

In addition to the header, you can use the read filters to direct onlog to display the following information:

• Logical-log record header and data (including copies of simple large objects stored in a dbspace or tblspace)
• Copies of blobpages from blobspaces

  They are copied from the logical-log backup only. They are not available from disk.

Display Filters

You can display every logical-log record header, or you can specify output based on the following criteria:

• Records associated with a specific table
• Records initiated by a specific user
• Records associated with a specific transaction

If an Error Is Detected

If onlog detects an error in the log file, such as an unrecognizable log type, it displays the entire log page in hexadecimal format and terminates.