PowerExchange for CDC and Mainframe
- PowerExchange for CDC and Mainframe 10.4.0 HotFix 1
- 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' Column Name. Type. Precision Scale CPN Nulls Key Seqcol1 type precision scale Y|N Y|N sequence col2 type precision scale Y|N Y|N sequence
Item
| 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 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.
|
Version
| 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.
|
Column Name
| The column name.
|
Type
| The column data type.
|
Precision
| The precision of the column, if applicable.
|
Scale
| The scale of the column, if applicable.
|
CPN
| The column code page number, if applicable.
|
Nulls
| Whether the column accepts null values. Valid values: Y or N.
|
Key
| Whether the column is a key column. Valid values: Y or N.
|
Sequence
| For key columns, the column sequence, if available.
|
Offset
| For key columns, the column offset, if available.
|
Length
| For key columns, the key length, if available.
|
Key Name
| For key columns, the key name, if available.
|
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.
|
IDM
| 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=MSS INSTANCE=QA02CYR ================================ CRNAME=alltype1 STATUS=A CNDSOPT=Part TAG=MSS02CYRalltype11 TABLE=dbo.alltypes ----------------------------------------------------------------------------------- User Name: 'stuser' Last Updated: '20170505095940' VRM: 'V10.1.1' Edit Sequence: '2' Registration Type: 'SYNCHRONOUS' Data Columns: '4' Column Name Type Precision Scale CPN Nulls Key Seq ROW_ID char 4 0 N Y 1 tbit bit 1 0 N N ttinyint tinyint 3 0 N N tsmallint smallint 5 0 N N