|
|
|
The format of keywords for defining a transaction log dump is the same as the dynamic dump script file, but they are not put in a separate file or script. Instead, they are entered along with the name of the program when starting the program.
The keywords and arguments for ctldmp, the transaction log dump utility, are:
DATE <mm/dd/yyyy>
Begin dumping transactions as of the date specified. If no date is specified, begin dumping transactions from the beginning of the log file.
LOG <number>
Dump transactions beginning with the specified log. If no log number is specified, dump all log files meeting all other specifications.
OFF
Value of the position entry, offset, in the log dump that must be matched for the transaction to be listed. It is the ‘P’ field which follows the transaction number in the dump listing.
POS
Byte position in log to start the dump.
TIME <hh:mm:ss>
Begin dumping transaction as of the time specified. If a date is specified, then the date and time are used in conjunction with each other. If a date is not specified the current date is the default.
TRAN
Transaction number which must be matched in order for the transaction to be listed.
TYPE
Transaction type, which must be matched for the transaction to be listed. The following code numbers correspond to the specified transaction type:
TYPE Value |
Explanation |
|---|---|
02 |
Add key value. |
04 |
Delete key value. |
07 |
Begin transaction. |
08 |
Commit transaction. |
09 |
Abort transaction. |
12 |
New record image. |
14 |
Old record image. |
15 |
Difference of old/new record images. |
26 |
Server checkpoint. |
27 |
Open file. |
28 |
Create file. |
29 |
Delete file. |
30 |
Close file. |
31 |
Client login. |
32 |
Client logoff. |
34 |
End of log segment. |
40 |
Abandon transaction. |
CHKPNT yes
Outputs detailed information for each checkpoint encountered during a dump. For example, by using the following command line, the log dump begins with log file L0000100.FCS; only dumps checkpoints, and lists detailed information about checkpoints. tran types are found in ctopt2.h and the table above.
ctldmp log 100 type 26 chkpnt yes
