PowerExchange for CDC and Mainframe
- PowerExchange for CDC and Mainframe 10.5.2
- All Products
CRNAME=registration_nameSTATUS=statusCNDSOPT=condense_optionTAG=registration_tagTABLE=schema.table_nameUser Name: 'user' Last Updated: 'date' VRM: 'version' Edit Sequence: 'edit_seqno' Registration Type: 'type' Data Columns: 'number'
Field
| Description
|
---|---|
CRNAME
| The user-defined name of the capture registration.
|
STATUS
| The status of the capture registration, which can be one of the following values:
|
CNDSOPT
| The Condense option in effect that is set in the capture registration, which can be one of the following values:
|
TAG
| The capture registration tag name.
|
TABLE
| The source table name for which the capture registration was created. This value is in the format
schema.table_name .
|
User name
| The user name that is specified for the registration group that contains the registration. This field is printed only for the first registration entry and for any subsequent entry in which the user name changed.
|
Last Updated
| The timestamp for the most recent change to the capture registration.
|
VRM
| The PowerExchange version.release.modification level in which the capture registration was most recently updated.
|
Edit Sequence
| The value of the edit sequence (edit_seqno) field for the capture registration. This value is incremented each time the capture registration is edited and prevents concurrent updates to the registration by different users.
|
Registration Type
| Whether the registration is used for log-based or synchronous CDC.
|
Data Columns
| The total number of data columns in each row of the registered table, as recorded in the CCT file.
|
Database Type
| Summary Report Information
|
---|---|
ADA
| DBID
FILENO
|
DCM
| Database ID
Table ID
Table Name
Number of Elements
Record Length
Recovery Flag
|
AS4
| File Name, if different than table name
Journal Library
Journal Name
Receiver Library
Receiver Name
Start Position
DBDID
OBID
|
DB2
| DBID
OBID if nonzero
These fields are zero if the capture registration was added earlier than DB2 Version 8.
|
IDL
| Subschema
Base Record Name
Record ID
Area Name
Page Group
Key Radix
Compression Indicator
Variable Indicator
|
IMS
| IMS Version
Database Name
IMS Database Type
System Type
Segment Name
Segment Level
Segment Code
Parent Code
Spans Segments, if present
Key Starting Position
Key Length
DBD Dataset Name, if present
Collector Start Time, if present
|
VSM
| Dataset Name
|
DBTYPE=ORA INSTANCE=NA123DTL ================================= CRNAME=emp1 STATUS=A CNDSOPT=Part TAG=ORANA123DTLemp11 TABLE=HRDA.EMP ------------------------------------------------------------------------------- User Name: 'user1' Last Updated: '20161208122155' VRM: 'V10.2.0' Edit Sequence: '1' Registration Type: 'SYNCHRONOUS' Data Columns: '8'