Utilities 7-57
Interpreting tblog Output
■Remainder page update
■Before update record
■After update record
Record ContentsThe table below liststblog record types as they appear in the log. The
contentsof 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 chunknumber
chunkname
decimal
ASCII
ADDDBS adddbspace dbspacename ASCII
ADDITEM additem to index tblspaceid
rowid
logicalpage
keynumber
keylength
hexadecimal
hexadecimal
decimal
decimal
decimal
ADDLOG addlog lognumber
logsize (pages)
pageno
decimal
decimal
hexadecimal
BADIDX badindex tblspace id hexadecimal
BEGIN beginwork date
time
PID
user
decimal
decimal
decimal
ASCII
BEGPREP begin a global
transaction flags
no. of participants
decimal
decimal
(1 of 7)