7-60 IBM Informix OnLine Database Server Administrator’s Guide
Interpreting tblog Output
CKPOINT checkpoint max users
number of
active transactions
decimal
decimal
CLR compensation log
record; part of a roll
back
none
CLUSIDX create clustered index tblspace id hexadecimal
COLREPAI adjustment of BYTE,
TEXT, or VARCHAR
column
tblspace id
no. of columns that
were adjusted
hexadecimal
decimal
COMMIT commit work date
time
decimal
decimal
DELETE delete before image tblspace id
rowid
hexadecimal
hexadecimal
DELITEM delete item from index tblspace id
rowid
logical page
key number
key length
hexadecimal
hexadecimal
decimal
decimal
decimal
DINDEX drop index tblspace id hexadecimal
DRPBSP drop blobspace blobspace name ASCII
DRPCHK drop chunk chunk number
chunk name
decimal
ASCII
DRPDBS drop dbspace dbspace name ASCII
DRPLOG drop log log number
log size (pages)
pageno
decimal
decimal
hexadecimal
ENDTRANS end the transaction none
Type Contents Additional Columns Format
(4 of 7)