Filter
Top Products
Utilities 7-57
Interpreting tblog Output
■ Remainder page update
■ Before update record
■ After update record
Record Contents
The table below lists tblog record types as they appear in the log. The
contents ofthe log record indicatethe type of operation that generated the log
entry. The additional column and format information describes what is
displayed for each record type if you request the -l option (long listing).
Type Contents Additional Columns Format
ADDCHK add chunk chunk number
chunk name
decimal
ASCII
ADDDBS add dbspace dbspace name ASCII
ADDITEM add item to index tblspace id
rowid
logical page
key number
key length
hexadecimal
hexadecimal
decimal
decimal
decimal
ADDLOG add log log number
log size (pages)
pageno
decimal
decimal
hexadecimal
BADIDX bad index tblspace id hexadecimal
BEGIN begin work date
time
PID
user
decimal
decimal
decimal
ASCII
BEGPREP begin a global
transaction
flags
no. of participants
decimal
decimal
(1 of 7)