IBM 000-8697 Log-Record Display Filters

7-54 IBM Informix OnLine Database Server Administrator’s Guide
Log-Record Display Filters
Log-Record Display Filters
You can combine options with any other options to produce more selective
filters.
Forexample, if you use both -u and -x options, only the activities initiated by
username during the specified transaction are displayed.
Ifyou use both the -u and -t options, only the activities initiated by username
and associated with the specified tblspace are displayed.
-l directstblog to display the long listing of the logical log
record, both heading and associated data.
-ttblspace
num directstblog to display only records associated with the specified tblspace. The tbspace number can be specified as
eithera decimal or hexadecimal value. (If you do not use an 0x
prefix, the value is interpreted as a decimal.)
-u username directstblog to display only records associated with activity
initiated by the specified user.
-xtransaction
num directstblog to display only records associated with the specified transaction. The transaction number must be a
decimal value. (Refer totbstat -u.)
Log-Record
Display Filters
-t tblspace num
1
-u username
1
-x transaction num
1
1-l