IBM 000-8697 Manual Do Utilizador
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 of the log record indicate the 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).
contents of the log record indicate the 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
transaction
flags
no. of participants
decimal
decimal
(1 of 7)