First row — Contains information of a single CDC table policy. This row has an identifier or tag called “Table” as a prefix to identify that the policy is a CDC table policy. The value at the end of the row indicates the number of field policies associated with the CDC table policy.
|
Column
|
Description
|
|
Table
|
The identifier or tag to identify that the policy is a CDC table policy.
|
|
Policy Name
|
The name of the table policy.
|
|
Description
|
The description of the policy.
|
|
State
|
The internal state of the policy.
The values are 0 and 1 for Active and Inactive respectively.
|
|
Instance
|
The policy on the source table.
The values are 0, 1, and 2 for Current policy, Previous policy, and Pending policy respectively.
|
|
Source Table
|
The name of the source table.
|
|
Source Table Owner
|
The name of the owner of the source table.
The source table can be a PUB or non-PUB table.
|
|
Data Area
|
The storage area where the change table.
|
|
Index Area
|
The storage area where the change table indices are created.
|
|
Identifying Fields
|
Indicates if the Identifying fields are available for the policy.
The values are Yes and No.
|
|
Level
|
The level of data that is captured on the source table.
The levels are:
Minimal(0)
MinimalWithBitMap(1)
Medium(2)
Maximum(3)
|
|
Change Table
|
The name of the change table.
|
|
Change Table Owner
|
The name of the non-PUB or PUB owner of the change table.
|
|
Encrypt Policy
|
The encryption policy used for the change table.
The values are Yes and No.
|
|
Misc Fields
|
This is an extent [16] field and the values are non-editable.
All values of _Misc fields for _Cdc-Table-Policy are dumped.
|
|
Field Policy Count
|
The number of field policies available for a table policy.
A value of zero (0) indicates that there are no field policies available for that table policy.
|
_Policy-Id
_Last-Modified
_ObjectId
_First-User-Field
Subsequent rows — Contain information of the field policies associated with the CDC table policy. These rows have an identifier or tag called “Field” as a prefix to identify that the policies are field policies, followed by the name of the CDC policy name that they belong to.
|
Column
|
Description
|
|
Field
|
The identifier or tag to identify that the policy is a CDC field policy.
|
|
Policy Name
|
The name of the corresponding CDC table policy.
|
|
Field Name
|
The name of the field.
|
|
Identifying Fields
|
Indicates if the Identifying fields are available for the policy.
The values are from 1 to 15.
|
|
Misc Fields
|
This is an extent [16] field and the values are non-editable.
All values of _Misc fields for _Cdc-Field-Policy are dumped.
|
_Policy-Id
_Field-Position
_Field-Recid
Trailer — Contains information of the .cd file such as its name, the number of CDC table policies available in the file, the name of the database from which the policies are dumped, time and date when the dumping process completed, and format of the code page.
|
Row
|
Description
|
|
filename
|
The name of the .cd dump file.
|
|
records
|
The number of CDC table policies available in the dump file.
|
|
ldbname
|
The name of the database from which the policies are dumped.
|
|
timestamp
|
The time and date when the policies are dumped.
|
|
numformat
|
The numeric format
|
|
dateformat
|
The format of the date when the policies are dumped.
|
|
cpstream
|
The format of the code page in which you want the CDC policies to be dumped.
|
|
"Table" "cust" ? 0 0 "Customer" "PUB" "Order Index Area" "Order Index Area" no 0 ? "PUB" no ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? 0
"Table" "pol" ? 0 0 "Order" "PUB" "Order Index Area" "Order Index Area" no 1 "myCT" "PUB" no ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? 2 "Field" "pol" "Carrier" ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? "Field" "pol" "Cust-Num" ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? . PSC filename=sptest records=0000000000002 ldbname=sptest timestamp=2016/11/24-21:06:42 numformat=44,46 dateformat=mdy-1950 cpstream=ISO8859-1 . 0000000377 |