Include=Action=include-type
Specifies if deleted or modified records or transaction commit
information is to be extracted from the after-image journal. The
following keywords can be specified:
o Commit
NoCommit
If you specify Commit, a transaction commit record is
written to each output stream as the final record for each
transaction. The commit information record is written to
output streams after all other records for the transaction
have been written. The default is NoCommit.
Because output streams are created with a default file name
of the table being extracted, it is important to specify a
unique file name on each occurrence of the output stream.
The definition of "unique" is such that when you write to a
non-file-oriented output device (such as a pipe or mailbox),
you must be certain to specify a specific file name on each
output destination. This means that rather than specifying
Output=MBA1234: for each output stream, you should use
Output=MBA1234:MBX, or any file name that is the same on all
occurrences of MBA1234:.
Failure to use a specific file name can result in additional,
and unexpected, commit records being returned. However, this
is generally a restriction only when using a stream-oriented
output device (as opposed to a disk file).
The binary record format is based on the standard LogMiner
output format. However, some fields are not used in the commit
action record. The binary format and contents of this record
are shown in Commit Record Contents. This record type is
written for all output data formats.
Table 20 Commit Record Contents
Length (in
Field bytes) Contents
ACTION 1 "C"
RELATION 31 Zero
RECORD_TYPE 4 Zero
DATA_LEN 2 Length of RM_TID_LEN, AERCP_LEN, RM_
TID, AERCP
NBV_LEN 2 Zero
TID 4 Transaction (Attach) ID
PID 4 Process ID
START_TAD 8 Transaction Start Time/Date
COMMIT_TAD 8 Transaction Commit Time/Date
TSN 8 Transaction ID
RM_TID_LEN 4 Length of the Global TID
AERCP_LEN 4 Length of the AERCP information
RM_TID RM_TID_LEN Global TID
AERCP AERCP_LEN Restart Control Information
RDB$LM_ 12 USERNAME
USERNAME
When the original transaction took part in a distributed,
two-phase transaction, the RM_TID component is the Global
transaction manager (XA or DDTM) unique transaction ID.
Otherwise, this field contains binary zeroes.
The AIJ Extract Recovery Control Point (AERCP) information is
used to uniquely identify this transaction within the scope
of the database and after-image journal files. It contains
the .aij sequence number, VBN and TSN of the last "Micro Quiet
Point", and is used by the Continuous LogMiner process to
restart a particular point in the journal sequence.
o Delete
NoDelete
If you specify Delete, pre-deletion record contents are
extracted from the aij file. If you specify NoDelete, no
pre-deletion record contents are extracted. The default is
Delete.
o Modify
NoModify
If you specify Modify, modified or added record contents are
extracted from the .aij file. If you specify NoModify, then no
modified or added record contents are extracted. The default
is Modify.