onbar -P syntax: Printing backed-up logical logs

You can use the onbar -P command to print logical logs that are backed up using the ON-Bar utility.

To run ON-Bar commands, you must be user root, user informix, a member of the bargroup group on UNIX, or a member of the Informix®-Admin group on Windows.

Figure 1. Print backed-up logical logs

1  onbar -P +  -n
2.1 unique_id
2.1 starting_id-ending_id ? -l? -q? -b? -c?  -u username?  -t tblspace_num?  -x transaction_num
Table 1. Options for the onbar -P command
Option Purpose
-b Print logical-log records associated with blobspace blobpages.

The database server stores these records on the logical-log backup media as part of blobspace logging.

-c Use the compression dictionary to expand compressed data.
-l Print the long listing of the logical-log record.

The long listing of a log record includes complex hexadecimal and ASCII dumps of the entire log record.

-n starting_id-ending_id Print the logical-log records contained in the specified range of log files. The starting_id option is the ID of the first log to print. The ending_id option is ID of the last log to print. The value of the starting_id option must be smaller than the value of the ending_id option.

Separate the starting and ending ID values with a hyphen. Do not include blank spaces.

-n unique_id Print the logical-log records contained in the specified log file. The unique_id option is the unique ID number of the logical log. To determine the unique ID of a specific logical-log file, use the onstat -l command.
-P Print backed-up logical log information
-q Do not print the program header
-t tblspace_num Print the records associated with the tblspace that you specify with the tblspace_num option.

Specify the tblspace_num value as either an unsigned integer or hexadecimal value. If you do not use a prefix of 0x, the value is interpreted as an integer. The integer must be greater than zero and must exist in the partnum column of the systables system catalog table.

-u username Print the records for a specific user. The user name must be an existing login name and conform to operating-system-specific rules for login names.
-x transaction_num Print only the records associated with the transaction that you specify. The transaction_num must be an unsigned integer between zero and TRANSACTIONS -1, inclusive.

Additional Information: Use the -x option only in the unlikely situation of an error being generated during a roll-forward. 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 to investigate the cause of the error.

Usage

To view the backed-up logical logs, the storage manager must be running.

The output of this command is printed to stdout.

Example: Print a specific transaction

The following command prints information about a single transaction that was performed by the user informix against the tblspace 1048722 and is contained in the logical log file 2:
onbar -P -n 2 -l -q -b -u "informix" -t 1048722 -x 1
The output for this command might be:
log uniqid: 2.
1665d0   120  DPT      1        2  0        5 
         00000078 0002006c 00000010 0000fefe ...x...l ........ 
         00000001 00000000 000077e3 00000000 ........ ..w..... 
         00000005 00000005 00002a24 00000001 ........ ..*$.... 
         00100004 0a0c21b8 00002a48 00000001 ......!. ..*H.... 
         00100006 0a0c2288 00002ea1 00000001 ......". ........ 
         0010001b 0a0c3810 00002bee 00000001 ......8. ..+..... 
         00100015 0a0c3a18 00002a3d 00000001 ......:. ..*=.... 
         00100005 0a0c57c0                   ......W. 
166648   60   CKPOINT  1        0  1665d0   1       
         0000003c 00000042 00000010 0000fefe ...<...B ........ 
         00000001 001665d0 000077e3 00000000 ......e. ..w..... 
         00010005 00000002 00000002 001665a0 ........ ......e. 
         00000007 ffffffff 00084403          ........ ..D.

Example: Print multiple logical log files

The following command prints the logical log records for the logical logs files that have IDs of 2, 3, 4, 5, 10, 11, and 12:

onbar -P -n 2-5 -n 10-12