Logical-Log Record Types and Additional Columns

Home | Previous Page | Next Page Database Reference > Interpreting Logical-Log Records > Logical-Log Record Structure >

Logical-Log Record Types and Additional Columns

In addition to the six header columns that display for every record, some record types display additional columns of information. The information that appears varies, depending on record type. Table 3 lists all the record types and their additional columns.

The Action column indicates the type of database server action that generated the log entry. The Additional Columns and Format columns describe what information appears for each record type in addition to the header described in Logical-Log Record Header.

Table 3. Logical-Log Record Types
Record Type	Action	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
ALTERDONE	Alter of fragment complete.	tblspace ID physical page number previous page logical page number version of alter	hexadecimal hexadecimal decimal decimal
BADIDX	Bad index	tblspace ID	hexadecimal
BEGCOM	Begin commit.	(none)	(none)
BEGIN	Begin work.	date time PID user	decimal decimal decimal ASCII
BFRMAP	Simple-large-object free-map change.	tblspace ID bpageno status log ID prev page	hexadecimal hexadecimal USED/FREE decimal hexadecimal
BLDCL	Build tblspace.	tblspace ID fextsize nextsize row size ncolumns table name	hexadecimal decimal decimal decimal decimal ASCII
BMAPFULL	Bitmap modified to prepare for alter.	tblspace ID bitmap page num	hexadecimal decimal
BMAP2TO4	2-bit bitmap altered to two 4-bit bitmaps.	tblspace ID 2-bit bitmap page number flags	hexadecimal decimal decimal
BTCPYBCK	Copy back child key to parent.	tblspace ID parent logical page child logical page slot rowoff key number	hexadecimal decimal decimal decimal decimal decimal
BTMERGE	Merge B-tree nodes.	tblspace ID parent logical page left logical page right logical page left slot left rowoff right slot right rowoff key number	hexadecimal decimal decimal decimal decimal decimal decimal decimal decimal
BTSHUFFL	Shuffle B-tree nodes.	tblspace ID parent logical page left logical page right logical page left slot left rowoff key number flags	hexadecimal decimal decimal decimal decimal decimal decimal hexadecimal
BTSPLIT	Split B-tree node.	tblspace ID rowid parent logical page left logical page right logical page infinity logical page rootleft logical page midsplit key number key length	hexadecimal hexadecimal decimal decimal decimal decimal decimal decimal decimal decimal
CHALLOC	Chunk extent allocation.	pageno size	hexadecimal hexadecimal
CHCOMBINE	Chunk extent combine.	pageno	hexadecimal
CHFREE	Chunk extent free.	pageno size	hexadecimal hexadecimal
CHPHYLOG	Change physical-log location.	pageno size in kilobytes dbspace name	hexadecimal hexadecimal ASCII
CHSPLIT	Chunk extent split.	pageno	hexadecimal
CINDEX	Create index.	tblspace ID low rowid high rowid index descriptor	hexadecimal decimal decimal ASCII
COARSELOCK	Coarse-grain locking	tblspace ID old coarse-locking flag value new coarse-locking flag value	hexadecimal decimal decimal
CKPOINT	Checkpoint.	max users number of active transactions	decimal decimal
CLR	Compensation-log record; part of a rollback.	(none)	(none)
CLUSIDX	Create clustered index.	tblspace ID key number	hexadecimal decimal
COLREPAI	Adjust BYTE, TEXT, or VARCHAR column.	tblspace ID no. of columns 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
DERASE	Drop tblspace in down dbspace.	tblspace ID lockid	hexadecimal hexadecimal
DINDEX	Drop index.	tblspace ID key number	hexadecimal decimal
DPT	List all dirty pages not flushed to disk during a fuzzy checkpoint. This record is written just before the CKPOINT record and linked to it. The DPT records are not written during a full checkpoint because all the dirty pages are flushed to disk	number of dirty pages	hexadecimal
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
ERASE	Drop tblspace.	tblspace ID	hexadecimal
HDELETE	Delete home row.	tblspace ID rowid slotlen	hexadecimal hexadecimal decimal
HINSERT	Home row insert.	tblspace ID rowid slotlen	hexadecimal hexadecimal decimal
HUPAFT	Home row update, after-image.	tblspace ID rowid slotlen	hexadecimal hexadecimal decimal
HUPBEF	Home row update, before-image.	tblspace ID rowid slotlen	hexadecimal hexadecimal decimal
HUPDATE	If the home row update before-images and after-images can both fit into a single page, the database server writes a single HUPDATE record.	tblspace ID rowid forward ptr rowid old slotlen new slotlen no. of pieces	hexadecimal hexadecimal hexadecimal decimal decimal decimal
IDXFLAGS	Index flags.	tblspace ID key number	hexadecimal hexadecimal
INSERT	Insert after-image.	tblspace ID rowid	hexadecimal hexadecimal
LCKLVL	Locking mode.	tblspace ID old lockmode new lockmode	hexadecimal hexadecimal hexadecimal
LG_CDINDEX	Create detached index.	database name owner table name index name	ASCII ASCII ASCII ASCII
LG_DERASE	Drop tblspace in disabled dbspace.	tblspace number table lock number	hexadecimal decimal
LG_ENDTRUNCATE	Indicate that the TRUNCATE TABLE operation, which removes all the rows from tables and indexes, completed.	tblspace ID	hexadecimal
LG_PTRUNCATE	Mark tblspace for truncation at commit time.	tblspace ID	hexadecimal
LG_TRUNCATE	Truncate has freed the extents and the transaction will be committed.	tblspace ID	hexadecimal
MVIDXND	Index node moved to allow for 2-bit to 4-bit bitmap conversion.	tblspace ID old page number new page number parent page number parent slot number parent slot offset key number	hexadecimal decimal decimal decimal decimal decimal decimal
PBDELETE	Delete tblspace blobpage.	bpageno status unique ID	hexadecimal USED/FREE decimal
PBINSERT	Insert tblspace blobpage.	bpageno tblspace ID rowid slotlen pbrowid	hexadecimal hexadecimal hexadecimal decimal hexadecimal
PDINDEX	Predrop index.	tblspace ID	hexadecimal
PGALTER	Page altered in-place.	tblspace ID physical page number	hexadecimal hexadecimal
PGMODE	Page mode modified in bitmap.	tblspace ID logical page number old mode new mode	hexadecimal decimal hexadecimal hexadecimal
PERASE	Preerase old file.	tblspace ID	hexadecimal
PNLOCKID	Change tblspaces lockid.	tblspace ID old lock ID new lock ID	hexadecimal hexadecimal hexadecimal
PNSIZES	Set tblspace extent sizes.	tblspace ID fextsize nextsize	hexadecimal decimal decimal
PTADESC	Add alter description information.	tblspace ID physical page number of previous page logical page number number of columns added	hexadecimal hexadecimal decimal decimal
PTALTER	Alter of fragment begun.	tblspace ID physical page number previous page logical page number alter desc page number num columns added version of alter added rowsize	hexadecimal hexadecimal decimal decimal decimal decimal decimal
PTCOLUMN	Add special columns to fragment.	tblspace ID number of columns	hexadecimal decimal
PTEXTEND	Tblspace extend.	tblspace ID last logical page first physical page	hexadecimal decimal hexadecimal
PTRENAME	Rename table.	tblspace ID old table name new table name	hexadecimal ASCII ASCII
RDELETE	Remainder page delete.	tblspace ID rowid slotlen	hexadecimal hexadecimal decimal
REVERT	Logs the reversion of a database space to a database space of an earlier version.	type of reversion event arg1 arg2 arg3	decimal decimal decimal decimal
RINSERT	Remainder page insert.	tblspace ID rowid slotlen	hexadecimal hexadecimal decimal
ROLLBACK	Rollback work.	date time	decimal decimal
RSVEXTEN	Logs the extension to the reserved pages.	no. of pages physical page number of extent	decimal hexadecimal
RUPAFT	Remainder page update, after-image.	tblspace ID rowid slotlen	hexadecimal hexadecimal decimal
RUPBEF	Remainder page update, before-image.	tblspace ID rowid slotlen	hexadecimal hexadecimal decimal
RUPDATE	If the remainder page update before-images and after-images can both fit into a single page, the database server writes a single RUPDATE record.	tblspace ID rowid forward ptr rowid old slotlen new slotlen no. of pieces	hexadecimal hexadecimal hexadecimal decimal decimal decimal
SYNC	Written to a logical-log file if that log file is empty and administrator instructs the database server to switch to next log file.	(none)	(none)
UNDO	Header record to a series of transactions to be rolled back.	count	decimal
UNDOBLDC	This record is written if a CREATE TABLE statement should be rolled back but cannot be because the relevant chunk is down. When the log file is replayed, the table will be dropped.	tblspace number	hexadecimal
UNIQID	Logged when a new serial value is assigned to a row.	tblspace ID unique ID	hexadecimal decimal
UPDAFT	Update after-image.	tblspace ID rowid	hexadecimal hexadecimal
UPDBEF	Update before-image.	tblspace ID rowid	hexadecimal hexadecimal
XAPREPARE	Participant can commit this XA transaction.	(none)	(none)