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 8 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.
| Record Type | Action | Additional Columns | Format |
|---|---|---|---|
| ADDCHK | Add chunk. | chunk number | Decimal |
| chunk name | ASCII | ||
| ADDDBS | Add dbspace. | dbspace name | ASCII |
| ADDITEM | Add item to index. | tblspace ID | Hexadecimal |
| rowid | Hexadecimal | ||
| logical page | Decimal | ||
| key number | Decimal | ||
| key length | Decimal | ||
| ADDLOG | Add log. | log number | Decimal |
| log size (pages) | Decimal | ||
| pageno | Hexadecimal | ||
| ALLOCGENPG | Allocate a generic page. | tblspace ID | Decimal |
| rowid | Decimal | ||
| slot flags and length | Decimal | ||
| page version if delete | Decimal | ||
| flags, vimage record | Decimal | ||
| rowid for previous | Decimal | ||
| data | ASCII | ||
| ALTERDONE | Alter of fragment complete. | tblspace ID | Hexadecimal |
| physical page number previous page | Hexadecimal | ||
| logical page number | Decimal | ||
| version of alter | Decimal | ||
| ALTSPCOLSNEW | Changed columns in an alter table. | number of columns | Decimal |
| special column list | array | ||
| ALTSPCOLSOLD | Changed columns in an alter table. | number of columns | Decimal |
| special column list | array | ||
| BADIDX | Bad index | tblspace ID | Hexadecimal |
| BEGCOM | Begin commit. | (None) | (None) |
| BEGIN | Begin work. | date | Decimal |
| time | Decimal | ||
| SID | Decimal | ||
| user | ASCII | ||
| BEGPREP | Written by the coordinator database server to record the start of the two-phase commit protocol. | flags | Decimal (Value is 0 in a distributed transaction.) |
| number of participants | Decimal | ||
| BEGWORK | Begin a transaction. | begin transaction time | Decimal |
| user ID | Decimal | ||
| process ID | Decimal | ||
| BFRMAP | Simple-large-object free-map change. | tblspace ID | Hexadecimal |
| bpageno | Hexadecimal | ||
| status | USED/FREE | ||
| log ID | Decimal | ||
| prev page | Hexadecimal | ||
| BLDCL | Build tblspace. | tblspace ID | Hexadecimal |
| fextsize | Decimal | ||
| nextsize | Decimal | ||
| row size | Decimal | ||
| ncolumns | Decimal | ||
| table name | ASCII | ||
| BMAPFULL | Bitmap modified to prepare for alter. | tblspace ID | Hexadecimal |
| bitmap page num | Decimal | ||
| BMAP2TO4 | 2-bit bitmap altered to two 4-bit bitmaps. | tblspace ID | Hexadecimal |
| 2-bit bitmap page number | Decimal | ||
| flags | Decimal | ||
| BSPADD | Add blobspace. | blobspace name | ASCII |
| BTCPYBCK | Copy back child key to parent. | tblspace ID | Hexadecimal |
| parent logical page | Decimal | ||
| child logical page | Decimal | ||
| slot | Decimal | ||
| rowoff | Decimal | ||
| key number | Decimal | ||
| BTMERGE | Merge B-tree nodes. | tblspace ID | Hexadecimal |
| parent logical page | Decimal | ||
| left logical page | Decimal | ||
| right logical page | Decimal | ||
| left slot | Decimal | ||
| left rowoff | Decimal | ||
| right slot | Decimal | ||
| right rowoff | Decimal | ||
| key number | Decimal | ||
| BTSHUFFL | Shuffle B-tree nodes. | tblspace ID | Hexadecimal |
| parent logical page | Decimal | ||
| left logical page | Decimal | ||
| right logical page | Decimal | ||
| left slot | Decimal | ||
| left rowoff | Decimal | ||
| key number | Decimal | ||
| flags | Hexadecimal | ||
| BTSPLIT | Split B-tree node. | tblspace ID | Hexadecimal |
| rowid | Hexadecimal | ||
| parent logical page | Decimal | ||
| left logical page | Decimal | ||
| right logical page | Decimal | ||
| infinity logical page | Decimal | ||
| rootleft logical page | Decimal | ||
| midsplit | Decimal | ||
| key number | Decimal | ||
| key length | Decimal | ||
| CDINDEX | Create detached index. | database name | ASCII |
| owner | ASCII | ||
| table name | ASCII | ||
| index name | ASCII | ||
| CDR | Captures the set of table columns modified
by an update statement such as a bitvector. This log
record allows Enterprise Replication to capture only the changed data to avoid transmitting
the unchanged columns to a target site.
In the example, the first six columns of the table are unchanged (6 leftmost bits in the bitvector are 0), the seventh and eighth columns have been updated (seventh and eighth bits are 1), and so on. The onlog output displays as many bits of bitvector as fit in a single line of the output. To see the entire bitvector displayed in hexadecimal, use the onlog -l command. |
name of CDR record | ASCII |
| partition number | Hexadecimal | ||
| bitvector | Binary | ||
|
Sample onlog output for CDR log record: adr len type xid id link name partno bitvector 40 36 CDR 14 0 18 UPDCOLS 10009a 000000110100110100 |
|||
| CHALLOC | Chunk extent allocation. | pageno | Hexadecimal |
| size | Hexadecimal | ||
| CHCOMBINE | Chunk extent combine. | pageno | Hexadecimal |
| CHFREE | Chunk extent free. | pageno | Hexadecimal |
| size | Hexadecimal | ||
| CHKADJUP | Update chunk adjunct on disk. The database server writes this record when it moves space from the reserved area to the metadata or user-data area or when the user adds an sbspace chunk. | chunk number | Integer |
| ud1_start_page | Integer | ||
| ud1_size | Integer | ||
| md_start_page | Integer | ||
| md_size | Integer | ||
| ud2_start_page | Integer | ||
| ud2_size | Integer | ||
| flags | Hexadecimal | ||
| CHPHYLOG | Change physical-log location. | pageno | Hexadecimal |
| size in kilobytes | Hexadecimal | ||
| dbspace name | ASCII | ||
| CHRESERV | Reserve extent for metadata stealing. This record is written when you add an sbspace chunk. | chunk number | Integer |
| page number | Integer | ||
| length | Integer | ||
| CHSPLIT | Chunk extent split. | pageno | Hexadecimal |
| CINDEX | Create index. | tblspace ID | Hexadecimal |
| low rowid | Decimal | ||
| high rowid | Decimal | ||
| index descriptor | ASCII | ||
| COARSELOCK | Coarse-grain locking | tblspace ID | Hexadecimal |
| old coarse-locking flag value | Decimal | ||
| new coarse-locking flag value | Decimal | ||
| CKPOINT | Checkpoint. | max users | Decimal |
| number of active transactions | Decimal | ||
| CLR | Compensation-log record; created during a rollback. | (None) | (None) |
| CLUSIDX | Create clustered index. | tblspace ID | Hexadecimal |
| key number | Decimal | ||
| COLREPAI | Adjust BYTE, TEXT, or VARCHAR column. | tblspace ID | Hexadecimal |
| number of columns adjusted | Decimal | ||
| COMMIT | Commit work. | date | Decimal |
| time | Decimal | ||
| COMTAB | Compact slot table on a page. | logical page number | Decimal |
| number slots moved | Decimal | ||
| compressed slot pairs | ASCII | ||
| COMWORK | End a transaction and commit work. | end transaction time | Decimal |
| begin transaction time | Decimal | ||
| DELETE | Delete before-image. | tblspace ID | Hexadecimal |
| rowid | Hexadecimal | ||
| DELITEM | Delete item from index. | tblspace ID | Hexadecimal |
| rowid | Hexadecimal | ||
| logical page | Decimal | ||
| key number | Decimal | ||
| key length | Decimal | ||
| DERASE | Drop tblspace in down dbspace. | tblspace number | Hexadecimal |
| table lock number | Decimal | ||
| DINDEX | Drop index. | tblspace ID | Hexadecimal |
| key number | 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 |
| DRPBSP | Drop blobspace. | blobspace name | ASCII |
| DRPCHK | Drop chunk. | chunk number | Decimal |
| chunk name | ASCII | ||
| DRPDBS | Drop dbspace. | dbspace name | ASCII |
| DRPLOG | Drop log. | log number | Decimal |
| log size (pages) | Decimal | ||
| pageno | Hexadecimal | ||
| ENDTRANS | Written by both the coordinator and participant database
servers to record the end of the transaction. ENDTRANS instructs the database
server to remove the transaction entry from its shared-memory transaction
table and close the transaction.
In the coordinator logical log, each BEGPREP that results in a committed transaction is paired with an ENDTRANS record. If the final decision of the coordinator is to roll back the transaction, no ENDTRANS record is written. In the participant logical log, each ENDTRANS record is paired with a corresponding HEURTX record. |
(None) | (None) |
| ERASE | Drop tblspace. | tblspace ID | Hexadecimal |
| FREE_RE | Allocate extent from reserve extent to metadata or user-data area of an sbspace chunk. | chunk number | Integer |
| page number | Integer | ||
| length | Integer | ||
| flag | Hexadecimal | ||
| HDELETE | Delete home row. | tblspace ID | Hexadecimal |
| rowid | Hexadecimal | ||
| slotlen | Decimal | ||
| HEURTX | Written by a participant database server to record a heuristic decision to roll back the transaction. It should be associated with a standard ROLLBACK record indicating that the transaction was rolled back. | flag | Hexadecimal (Value is always 1.) |
| HINSERT | Home row insert. | tblspace ID | Hexadecimal |
| rowid | Hexadecimal | ||
| slotlen | Decimal | ||
| HUPAFT | Home row update, after-image. | tblspace ID | Hexadecimal |
| rowid | Hexadecimal | ||
| slotlen | Decimal | ||
| HUPBEF | Home row update, before-image. | tblspace ID | Hexadecimal |
| rowid | Hexadecimal | ||
| slotlen | 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 | Hexadecimal |
| rowid | Hexadecimal | ||
| forward ptr rowid | Hexadecimal | ||
| old slotlen | Decimal | ||
| new slotlen | Decimal | ||
| number of pieces | Decimal | ||
| IDXFLAGS | Index flags. | tblspace ID | Hexadecimal |
| key number | Hexadecimal | ||
| INSERT | Insert after-image. | tblspace ID | Hexadecimal |
| rowid | Hexadecimal | ||
| ISOSPCOMMIT | Log an isolated save-point commit. | end transaction time | Decimal |
| begin transaction time | Decimal | ||
| LCKLVL | Locking mode (page or row). | tblspace ID | Hexadecimal |
| old lockmode | Hexadecimal | ||
| new lockmode | Hexadecimal | ||
| LG_ADDBPOOL | Add a buffer pool online. | page size in bytes | Decimal |
| number of buffers in the pool | Decimal | ||
| number of lru queues | Decimal | ||
| percent of lru_max_dirty | Decimal | ||
| percent of lru_min_dirty | Decimal | ||
| 4LG_PTRUNCATE | 4Identifies an intention to truncate a table. The partitions 4are marked to be dropped or reused, according to the specified command option. | 4tblspace ID | 4Hexadecimal |
| 4LG_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 | Hexadecimal |
| old page number | Decimal | ||
| new page number | Decimal | ||
| parent page number | Decimal | ||
| parent slot number | Decimal | ||
| parent slot offset | Decimal | ||
| key number | Decimal | ||
| PBDELETE | Delete tblspace blobpage. | bpageno | Hexadecimal |
| status | USED/FREE | ||
| unique ID | Decimal | ||
| PBINSERT | Insert tblspace blobpage. | bpageno | Hexadecimal |
| tblspace ID | Hexadecimal | ||
| rowid | Hexadecimal | ||
| slotlen | Decimal | ||
| pbrowid | Hexadecimal | ||
| PDINDEX | Predrop index. | tblspace ID | Hexadecimal |
| PGALTER | Page altered in place. | tblspace ID | Hexadecimal |
| physical page number | Hexadecimal | ||
| PGMODE | Page mode modified in bitmap. | tblspace ID | Hexadecimal |
| logical page number | Decimal | ||
| old mode | Hexadecimal | ||
| new mode | Hexadecimal | ||
| PERASE | Preerase old file. Mark a table that is to be dropped. The database server frees the space on the commit. | tblspace ID | Hexadecimal |
| PNGPALIGN8 | Use the pages in this tblspace as generic pages. | None | |
| PNLOCKID | Change tblspaces lockid. | tblspace ID | Hexadecimal |
| old lock ID | Hexadecimal | ||
| new lock ID | Hexadecimal | ||
| PNSIZES | Set tblspace extent sizes. | tblspace ID | Hexadecimal |
| fextsize | Decimal | ||
| nextsize | Decimal | ||
| PREPARE | Written by a participant database server to record the ability of the participant to commit the transaction, if so instructed. | DBSERVERNAME of coordinator | ASCII |
| PTADESC | Add alter description information. | tblspace ID | Hexadecimal |
| physical page number of previous page | Hexadecimal | ||
| logical page number | Decimal | ||
| number of columns added | Decimal | ||
| PTALTER | Alter of fragment begun. | tblspace ID | Hexadecimal |
| physical page number previous page | Hexadecimal | ||
| logical page number | Decimal | ||
| alter desc page number | Decimal | ||
| num columns added | Decimal | ||
| version of alter | Decimal | ||
| added rowsize | Decimal | ||
| PTALTNEWKEYD | Update key descriptors in a tblspace header after an alter table command. | bytes in key descriptor | Decimal |
| data in key descriptor | ASCII | ||
| PTALTOLDKEYD | Update key descriptors after an alter table command. | bytes in key descriptor | Decimal |
| data in key descriptor | ASCII | ||
| PTCOLUMN | Add special columns to fragment. | tblspace ID | Hexadecimal |
| number of columns | Decimal | ||
| PTEXTEND | Tblspace extend. | tblspace ID | Hexadecimal |
| last logical page | Decimal | ||
| first physical page | Hexadecimal | ||
| PTRENAME | Rename table. | tblspace ID | Hexadecimal |
| old table name | ASCII | ||
| new table name | ASCII | ||
| RDELETE | Remainder page delete. | tblspace ID | Hexadecimal |
| rowid | Hexadecimal | ||
| slotlen | Decimal | ||
| RENDBS | Rename dbspace. | new dbspace name | ASCII |
| REVERT | Logs the reversion of a database space to a database space of an earlier version. | type of reversion event | Decimal |
| arg1 | Decimal | ||
| arg2 | Decimal | ||
| arg3 | Decimal | ||
| RINSERT | Remainder page insert. | tblspace ID | Hexadecimal |
| rowid | Hexadecimal | ||
| slotlen | Decimal | ||
| ROLLBACK | Rollback work. | date | Decimal |
| time | Decimal | ||
| ROLWORK | End a transaction and roll back work. | end transaction time | Decimal |
| begin transaction time | Decimal | ||
| RSVEXTEND | Logs the extension to the reserved pages. | number of pages | Decimal |
| physical page number of extent | Hexadecimal | ||
| RTREE | Logs inserts and deletions for R-tree index
pages. (Other operations on R-tree indexes are physically logged.) The record
subtypes are:
|
record subtype | ASCII |
| [index page rowid | Hexadecimal | ||
| tuple length | Decimal | ||
| base table rowid | Decimal | ||
| base table fragid | Decimal | ||
| delete flag] | Decimal | ||
| RUPAFT | Remainder page update, after-image. | tblspace ID | Hexadecimal |
| rowid | Hexadecimal | ||
| slotlen | Decimal | ||
| RUPBEF | Remainder page update, before-image. | tblspace ID | Hexadecimal |
| rowid | Hexadecimal | ||
| slotlen | 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 | Hexadecimal |
| rowid | Hexadecimal | ||
| forward ptr rowid | Hexadecimal | ||
| old slotlen | Decimal | ||
| new slotlen | Decimal | ||
| number of pieces | Decimal | ||
| SBLOB | Indicates a subsystem log record for a smart large object.
The various record subtypes are:
|
Varies
For more information, see Log Record Types for Smart Large Objects. |
Varies |
| 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) |
| TABLOCKS | Written by either a coordinator or a participant database server. It is associated with either a BEGPREP or a PREPARE record and contains a list of the locked tblspaces (by tblspace number) held by the transaction. (In a distributed transaction, transactions are shown as the owners of locks.) | number of locks | Decimal |
| tblspace number | Hexadecimal | ||
| UDINSERT | Append new user data. | chunk | Decimal |
| page within chunk | Hexadecimal | ||
| offset within page | Hexadecimal | ||
| data length | Hexadecimal | ||
| UDUPAFT | Update user data after-image if a UDWRITE is too expensive. | chunk | Decimal |
| page within chunk | Hexadecimal | ||
| offset within page | Hexadecimal | ||
| data length | Hexadecimal | ||
| UDUPBEF | Update user-data before-image if a UDWRITE is too expensive. | chunk | Decimal |
| page within chunk | Hexadecimal | ||
| offset within page | Hexadecimal | ||
| data length | Hexadecimal | ||
| UDWRITE | Update user data (difference image). | chunk | Decimal |
| page within chunk | Hexadecimal | ||
| offset within chunk | Hexadecimal | ||
| length before write | Hexadecimal | ||
| length after write | Hexadecimal | ||
| 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 | Hexadecimal |
| unique ID | Decimal | ||
| UPDAFT | Update after-image. | tblspace ID | Hexadecimal |
| rowid | Hexadecimal | ||
| UPDBEF | Update before-image. | tblspace ID | Hexadecimal |
| rowid | Hexadecimal | ||
| XAPREPARE | Participant can commit this XA transaction. | (None) | (None) |