Log-Record Display Filters

Home | Previous Page | Next Page Administrative Utilities > The onlog Utility > onlog: Display Logical-Log Contents >

Log-Record Display Filters

Log-Record Display Filters:
 
   .------------------------------.
   V                              |
|----+--------------------------+-+-----------------------------|
     |     (1)                  |
     +- -l----------------------+
     |                   (1)    |
     +- -t--tblspace_num--------+
     |               (1)        |
     +- -u--username------------+
     |                     (1)  |
     '- -x--transaction_id------'

Notes:

Only one occurrence of this item allowed

Element	Purpose	Key Considerations
-l	Displays the long listing of the logical-log record.	Additional Information: The long listing of a log record includes a complex hexadecimal and ASCII dump of the entire log record. The listing is not intended for casual use.
-t tblspace_num	Displays records associated with the tblspace that you specify.	Restrictions: Unsigned integer. Number, greater than 0, must be in the partnum column of the systables system catalog table. Additional Information: Specify this value as either an integer or hexadecimal value. (If you do not use a 0x prefix, the value is interpreted as an integer.) To determine the tblspace number of a particular tblspace, query the systables system catalog table as described in Tblspace Numbers.
-u username	Displays records for a specific user.	Restrictions: User name must be an existing login name. User name must conform to operating-system-specific rules for login name.
-x transaction_id	Displays only records associated with the transaction that you specify.	Restriction: Value must be an unsigned integer between 0 and TRANSACTIONS - 1, inclusive. Additional Information: You should need to use the -x option only in the unlikely case that an error is generated during a rollforward. When this situation occurs, the database server sends a message to the message log that includes the transaction ID of the offending transaction. You can use this transaction ID with the -x option of onlog to investigate the cause of the error.

If you do not specify any options, onlog displays a short listing of all the records in the log. You can combine options with any other options to produce more selective filters. For example, if you use both the -u and -x options, onlog displays only the activities that the specified user initiated during the specified transaction. If you use both the -u and -t options, onlog displays only the activities initiated by the specified user and associated with the specified tblspace.