Dumplf
dumplf#
ABout dumplf#
When a transaction performs an operation that changes the contents of the database, such as an INSERT, DELETE or UPDATE operation, changes are made not only to the database's data buffers, but also to log files. These files are maintained for use in performing recovery if it becomes necessary. To minimize I/O, these logs are recorded in binary format. These log files are stored with the name logfile# (where "#" is the number of the log file, which continuously increments) in the directory specified in the LOG_DIR property in the altibase.properties file.
dumplf is a utility that converts and outputs the contents of these log files in text form. These logs can be used to check the types of operations that are performed on the database and determine the frequency of transactions that change the contents of the database.
dumplf {-f log_file_name} [-t transaction_id][-s] [-l][-S lsn [-F path] [-g]]
Syntax#
Parameters#
| Parameter | Description |
|---|---|
| -f | Specifies the name of the file which is to be output. |
| -t | Specifies the ID of the transaciton for which the logs are to be output. |
| -s | Specifies that only the header of the logs is to be output. If this option is omitted, both the header and the body will be output. |
| -l | Displays only information corresponding to log types (LT field) and sub-logtypes (OPTYPE and UTYPE fields) in the specified log file. |
| -S | Outputs the number of logs of INSERT, UPDATE, DELETE, COMMIT, and ROLLBACK in MMDB. If specified lsn is inserted, only the log after sn is displayed. If '0, 0' is inserted, the entire logs are displayed. |
| -F | Specifies the object target path, and it analyzes $ALTIBASE_HOME/logs if omitted. |
| -g | Outputs ID statistic of table object along with the entire statistics information. The entire statistic information is output if omitted. |
Description#
Converts the contents of a log file to text form and outputs it.
Example#
The following is executed at a shell prompt:
$ dumplf -f logfile0
Output#
The following is an example of dumplf output:
LSN=<0,820>, COMP:N, MAGIC:820, TID: 6400,BE: N, REP: Y, ISVP: N, ISVP_DEPTH: 0 PLSN=<0,739>, LT: SMR_LT_MEMTRANS_COMMIT, SZ: 45
Each field in a log file has the following meaning:다음과 같은 의미를 갖는다.
| Field Name | Value | Description |
|---|---|---|
| LSN | Format: (FileNo, Offset) Offset range: From 0 (zero) to the maximum value of the unsigned int type | This is the log sequence number, which contains information about the physical location of the current log in a log file. The LSN consists of the identifier of the file number and an offset value. |
| COMP | Y|N | Indicates whether logs are compressed. Y: Compressed N: Not compressed |
| MAGIC | From 0 (zero) to the maximum value of the unsigned short type | This value is generated using the log file number and offset portions of the LSN to determine whether a log record is valid. When a Redo or Undo action is performed, even if a log record having garbage data is in a log file, it is possible to determine whether the log record is valid. |
| TID | From 0 (zero) to the maximum value of the unsigned int type | The identifier of the transaction |
| BE | Y|N | Y: Indicates that the Sender must check whether to send this log to the Receiver. N: This log is not used by the replication Sender. |
| REP | Y|N | Y: Indicates that the Sender must check whether to send this log to the Receiver. N: This log is not used by the replication Sender. |
| ISVP | Y|N | Y: Indicates that this log is an Implicit Savepoint Log, that is, the first log that is recorded after the start of execution of a statement. If an error occurs while the statement is executing, the transaction is partially rolled back; that is, it is rolled back only as far as this log. |
| ISVP_DEPTH | 0 - 255 | Implicit Savepoint Depth, that is, the nesting depth when a statement is nested within one or more other statements |
| PLSN | Format: (FileNo, Offset) Offset range: From 0 (zero) to the maximum value of the unsigned int type | This value is used to connect all of the logs recorded by the same transaction in a chain. |
| LT | String | Indicates the Log Type (LT). |
| SZ | From 0 (zero) to the maximum value of the unsigned int type | Indicates the size of the log, in bytes |
| RdSz | From 0 (zero) to the maximum value of the unsigned int type | indicates the size of the redo log record, in bytes |
| DMIOff | From 0 (zero) to the maximum value of the unsigned int type | Indicates the location of the logical log that is used to undo a transaction, or is used for replication |
| TableOID | From 0 (zero) to the maximum value of the unsigned int type | The object identifier of the table |
| OID | From 0 (zero) to the maximum value of the unsigned int type | The object identifier of all objects other than tables. This includes record objects |
| ContType | 0, 1 | An itnernal vlaue that is used for replicaiton |
| OPTYPE | LogTypeName<LogTypeNumber> | The operation type of a Nested Top Action (NTA) log |
| AFTER | SZ: <size>, Value: <value> | The after name image of the log record |
| BEFORE | SZ: <size>, Value: <value> | The before image of the log record |
| UTYPE | LogTypeName<LogTypeNumber> | The operation type of an UPDATE log |
| UPOS | Format: (SPACEID:<SpaceID>, PID:<PageID>, OFFSET:<Offset> => OID:<OID>) | The address of the object that was updated. Additionally contains information about what happened during an update operation. |
| SPACEID | From 0 (zero) to the maximum value of the unsigned short type | The identifier of the tablespace containing the object that was updated |
| PID | From 0 (zero) to the maximum value of the unsigned int type | The identifier of the page containing the object that was updated |
| Offset | From 0 (zero) to the maximum value of the unsigned short type | The offset from the beginning of the page containing the object that was updated |
| FLISlot PrevPID NextPID | Format: (<BeforePID> => <AfterPID>) | An internal value used for managing MMDB tablespaces |
| ESLSN | Format: (FileNo, Offset) Offset range: From 0 (zero) to the maximum value of the unsigned int type | This is the LSN from which recovery would be performed, if necessary |
| Lob Locator | From 0 (zero) to the maximum value of the unsigned long type | An interally used value related to the use of replication with the LOB type |
The possible values of LT (Log Type) in the dumplf output are as follows:
| Value | Description |
|---|---|
| SMR_LT_DUMMY | Dummy Log |
| SMR_LT_CHKPT_BEGIN | Checkpoint Being Log |
| SMR_LT_DIRTY_PAGE | Dirty Page Log |
| SMR_LT_CHKPT_END | Checkpoint End Log |
| SMR_LT_MEMTRANS_COMMIT | Memory Transaction Commit Log |
| SMR_LT_MEMTRANS_ABORT | Memory Transaction Abort Log |
| SMR_LT_DSKTRANS_COMMIT | Disk Transaction Commit Log |
| SMR_LT_DSKTRANS_ABORT | Disk Transaction Abort Log |
| SMR_LT_SAVEPOINT_SET | Savepoint Set Log |
| SMR_LT_SAVEPOINT_ABORT | Savepoint Abort Begin Log |
| SMR_LT_XA_PREPARE | XA Prepare Log |
| SMR_LT_TRANS_PREABORT | Abort Begin Log |
| SMR_LT_DDL | DDL (Data Definition Language) Log |
| SMR_LT_XA_SEGS | XA Prepare Transaction Segment Information |
| SMR_LT_LOB_FOR_REPL | LOB Log for Replication |
| SMR_LT_UPDATE | MMDB(Main Memory Database) Update Log |
| SMR_LT_NTA | MMDB NTA(Nested Top Action) Log |
| SMR_LT_COMPENSATION | Compensation Log |
| SMR_LT_DUMMY_COMPENSATION | Dummy Compensation Log |
| SMR_LT_FILE_BEGIN | File Begin Log |
| SMR_LT_FILE_TBS_UPDATE | Tablespace Update Log |
| SMR_LT_FILE_END | File End Log |
| SMR_DLT_READONLY | DRDB(Disk Resident Database) Redo Only Log |
| SMR_DLT_UNDOABLE | DRDB Undo Log |
| SMR_DLT_NTA | DRDB NTA Log |
| SMR_DLT_COMPENSATION | DRDB Compensation Log |
| SMR_DLT_REF_NTA | DRDB Reference NTA Log |
| SMR_LT_TABLE_META | Table Meta Log for Replication |
Possible LogTypeName Values for OPTYPE and UTYPE
| Value | Description |
|---|---|
| SMR_OP_SMM_PERS_LIST_ALLOC SMR_OP_SMC_FIXED_SLOT_ALLOC SMR_OP_SMC_VAR_SLOT_ALLOC SMR_OP_SMC_FIXED_SLOT_FREE SMR_OP_SMC_VAR_SLOT_FREE |
Logs related to pages and slots in an MMDB |
| SMR_OP_CREATE_TABLE SMR_OP_CREATE_INDEX SMR_OP_DROP_INDEX SMR_OP_ALTER_TABLE SMR_OP_SMM_CREATE_TBS SMR_OP_INSTANT_AGING_AT_ALTER_TABLE SMR_OP_SMC_TABLEHEADER_ALLOC |
Logs related to the execution of DDL statements in an MMDB |
| SMR_MEM_LOB_CURSOR_OPEN SMR_DISK_LOB_CURSOR_OPEN SMR_LOB_CURSOR_CLOSE SMR_PREPARE4WRITE SMR_FINISH2WRITE |
Logs related to controlling LOB values in an MMDB |
| SDR_OP_SDP_CREATE_TABLE_SEGMENT SDR_OP_SDP_CREATE_LOB_SEGMENT SDR_OP_SDP_CREATE_INDEX_SEGMENT SDR_OP_SDP_ADD_LOB_PAGE_TO_AGINGLIST SDR_OP_SDC_ALLOC_UNDO_PAGE SDR_OP_SDPTB_ALLOCATE_AN_EXTENT_FROM_TBS SDR_OP_SDPTB_ALLOCATE_AN_EXTDIR_FROM_LIST SDR_OP_SDPTB_RESIZE_GG SDR_OP_SDPST_ALLOC_PAGE SDR_OP_SDPSF_ALLOC_PAGE SCT_UPDATE_MRDB_CREATE_TBS SCT_UPDATE_MRDB_CREATE_CIMAGE_FILE SCT_UPDATE_MRDB_DROP_TBS SCT_UPDATE_MRDB_ALTER_AUTOEXTEND SCT_UPDATE_MRDB_ALTER_TBS_ONLINE SCT_UPDATE_MRDB_ALTER_TBS_OFFLINE SCT_UPDATE_DRDB_CREATE_TBS SCT_UPDATE_DRDB_DROP_TBS SCT_UPDATE_DRDB_ALTER_TBS_ONLINE SCT_UPDATE_DRDB_ALTER_TBS_OFFLINE SCT_UPDATE_DRDB_CREATE_DBF SCT_UPDATE_DRDB_DROP_DBF SCT_UPDATE_DRDB_EXTEND_DBF SCT_UPDATE_DRDB_SHRINK_DBF SCT_UPDATE_DRDB_AUTOEXTEND_DBF SCT_UPDATE_DRDB_ALTER_DBF_ONLINE SCT_UPDATE_DRDB_ALTER_DBF_OFFLINE SCT_UPDATE_VRDB_CREATE_TBS SCT_UPDATE_VRDB_DROP_TBS SCT_UPDATE_VRDB_ALTER_AUTOEXTEND SCT_UPDATE_COMMON_ALTER_ATTR_FLAG |
Logs related to tablespaces and segments |
| SDR_OP_SDPST_UPDATE_WMINFO_4DPATH SDR_OP_SDPST_UPDATE_MFNL_4DPATH SDR_OP_SDPST_UPDATE_BMP_4DPATH SDR_OP_SDPSF_ADD_PIDLIST_PVTFREEPIDLIST_4DPATH SDR_OP_SDPSF_MERGE_SEG_4DPATH SDR_OP_SDPSF_UPDATE_HWMINFO_4DPATH SDR_OP_SDP_DPATH_ADD_SEGINFOSET |
Logs related to page management for Direct Page Insert in a DRDB |
| SDR_OP_SDN_INSERT_KEY_WITH_NTA SDR_OP_SDN_DELETE_KEY_WITH_NTA |
NTA Logs for DRDB B-tree Indexes |
| SDR_OP_STNDR_INSERT_KEY_WITH_NTA SDR_OP_STNDR_DELETE_KEY_WITH_NTA |
NTA Logs for DRDB R-tree Indexes |
| SDR_SDP_1BYTE SDR_SDP_2BYTE SDR_SDP_4BYTE SDR_SDP_8BYTE SDR_SDP_BINARY |
Physical DRDB logs |
| SDR_SDP_PAGE_CONSISTENT SDR_SDP_INIT_PHYSICAL_PAGE SDR_SDP_INIT_LOGICAL_HDR SDR_SDP_INIT_SLOT_DIRECTORY SDR_SDP_FREE_SLOT SDR_SDP_FREE_SLOT_FOR_SID SDR_SDP_RESTORE_FREESPACE_CREDIT SDR_SDP_RESET_PAGE SDR_SDP_WRITE_PAGEIMG SDR_SDP_WRITE_DPATH_INS_PAGE |
Logs related to page and slot management in a DRDB |
| SDR_SDPST_INIT_SEGHDR SDR_SDPST_INIT_BMP SDR_SDPST_INIT_LFBMP SDR_SDPST_INIT_EXTDIR SDR_SDPST_ADD_RANGESLOT SDR_SDPST_ADD_SLOTS SDR_SDPST_ADD_EXTDESC SDR_SDPST_ADD_EXT_TO_SEGHDR SDR_SDPST_UPDATE_WM SDR_SDPST_UPDATE_MFNL SDR_SDPST_UPDATE_PBS SDR_SDPST_UPDATE_LFBMP_4DPATH SDR_SDPSC_INIT_SEGHDR SDR_SDPSC_INIT_EXTDIR SDR_SDPSC_ADD_EXTDESC_TO_EXTDIR SDR_SDPTB_INIT_LGHDR_PAGE SDR_SDPTB_ALLOC_IN_LG SDR_SDPTB_FREE_IN_LG |
The log related to segment and tablespace management for DRDB |
| SDR_SDC_INSERT_ROW_PIECE SDR_SDC_INSERT_ROW_PIECE_FOR_UPDATE SDR_SDC_INSERT_ROW_PIECE_FOR_DELETEUNDO SDR_SDC_UPDATE_ROW_PIECE SDR_SDC_OVERWRITE_ROW_PIECE SDR_SDC_CHANGE_ROW_PIECE_LINK SDR_SDC_DELETE_FIRST_COLUMN_PIECE SDR_SDC_ADD_FIRST_COLUMN_PIECE SDR_SDC_DELETE_ROW_PIECE_FOR_UPDATE SDR_SDC_DELETE_ROW_PIECE SDR_SDC_LOCK_ROW |
Logs related to the management of rows in tables in a DRDB |
| SDR_SDC_UPDATE_LOBDESC SDR_SDC_UPDATE_LOBDESC_KEY SDR_SDC_LOB_WRITE_PIECE SDR_SDC_LOB_WRITE_PIECE4DML SDR_SDC_INIT_LOBPAGE SDR_SDC_LOB_PAGE_TO_AGING_LIST |
Logs related to the use of the LOB type in a DRDB |
| SDR_SDC_PK_LOG | Logs related to the use of primary keys for replication in a DRDB |
| SDR_SDC_INIT_CTL SDR_SDC_EXTEND_CTL SDR_SDC_BIND_CTS SDR_SDC_UNBIND_CTS SDR_SDC_BIND_ROW SDR_SDC_UNBIND_ROW SDR_SDC_ROW_TIMESTAMPING SDR_SDC_DATA_SELFAGING |
Logs related to MVCC for records in a DRDB |
| SDR_SDC_BIND_TSS SDR_SDC_UNBIND_TSS SDR_SDC_SET_INITSCN_TO_TSS SDR_SDC_INIT_TSS_PAGE SDR_SDC_INIT_UNDO_PAGE SDR_SDC_INSERT_UNDO_REC |
Logs related to Transaction Status Slots (TSS) and undo records in a DRDB |
| SDR_SDN_INSERT_INDEX_KEY SDR_SDN_FREE_INDEX_KEY SDR_SDN_INSERT_UNIQUE_KEY SDR_SDN_INSERT_DUP_KEY SDR_SDN_DELETE_KEY_WITH_NTA SDR_SDN_FREE_KEYS SDR_SDN_COMPACT_INDEX_PAGE |
Logs related to B-tree indexes in a DRDB |
| SDR_SDN_MAKE_CHAINED_KEYS SDR_SDN_MAKE_UNCHAINED_KEYS SDR_SDN_KEY_STAMPING SDR_SDN_INIT_CTL SDR_SDN_EXTEND_CTL SDR_SDN_FREE_CTS |
Logs related to MVCC for B-tree index keys in a DRDB |
| SDR_STNDR_MAKE_CHAINED_KEYS SDR_STNDR_MAKE_UNCHAINED_KEYS SDR_STNDR_KEY_STAMPING |
Logs related to MVCC for R-tree index keys in a DRDB |
| SMR_PHYSICAL | Physical logs in an MMDB |
| SMR_SMM_MEMBASE_SET_SYSTEM_SCN SMR_SMM_MEMBASE_ALLOC_PERS_LIST SMR_SMM_MEMBASE_ALLOC_EXPAND_CHUNK SMR_SMM_PERS_UPDATE_LINK SMR_SMM_PERS_UPDATE_NEXT_FREE_PAGE_LINK SMR_SMM_MEMBASE_INFO |
Logs related to base information in an MMDB |
| SMR_SMC_TABLEHEADER_INIT SMR_SMC_TABLEHEADER_UPDATE_INDEX SMR_SMC_TABLEHEADER_UPDATE_COLUMNS SMR_SMC_TABLEHEADER_UPDATE_INFO SMR_SMC_TABLEHEADER_SET_NULLROW SMR_SMC_TABLEHEADER_UPDATE_ALL SMR_SMC_TABLEHEADER_UPDATE_ALLOCINFO SMR_SMC_TABLEHEADER_UPDATE_FLAG SMR_SMC_TABLEHEADER_SET_SEQUENCE SMR_SMC_TABLEHEADER_UPDATE_TABLE_COLUMN_COUNT SMR_SMC_TABLEHEADER_UPDATE_TABLE_SEGMENT SMR_SMC_TABLEHEADER_UPDATE_FLAG_FOR_MEDIA_RECV SMR_SMC_TABLEHEADER_SET_SEGSTOATTR SMR_SMC_TABLEHEADER_SET_INSERTLIMIT SMR_SMC_INDEX_SET_FLAG SMR_SMC_INDEX_SET_SEGATTR SMR_SMC_INDEX_SET_SEGSTOATTR SMR_SMC_INDEX_SET_DROP_FLAG |
Logs related to table headers and index headers in an MMDB |
| SMR_SMC_PERS_INIT_FIXED_PAGE SMR_SMC_PERS_INIT_FIXED_ROW SMR_SMC_PERS_UPDATE_FIXED_ROW SMR_SMC_PERS_UPDATE_FIXED_ROW_NEXT_FREE SMR_SMC_PERS_UPDATE_FIXED_ROW_NEXT_VERSION SMR_SMC_PERS_SET_FIX_ROW_DROP_FLAG SMR_SMC_PERS_SET_FIX_ROW_DELETE_BIT SMR_SMC_PERS_INIT_VAR_PAGE SMR_SMC_PERS_UPDATE_VAR_ROW_HEAD SMR_SMC_PERS_UPDATE_VAR_ROW SMR_SMC_PERS_SET_VAR_ROW_FLAG SMR_SMC_PERS_SET_VAR_ROW_NXT_OID SMR_SMC_PERS_WRITE_LOB_PIECE SMR_SMC_PERS_INSERT_ROW SMR_SMC_PERS_UPDATE_INPLACE_ROW SMR_SMC_PERS_UPDATE_VERSION_ROW SMR_SMC_PERS_DELETE_VERSION_ROW |
Logs related to rows in tables in an MMDB |
Please refer to the Atibase Administrator's Manual for more information about MVCC.