PowerExchange for CDC and Mainframe
- PowerExchange for CDC and Mainframe 10.4.1
- All Products
Field
| Description
|
---|---|
Name
| Required. A user-defined name for the capture registration. The name must be from one to eight lowercase alphanumeric characters in length and begin with a letter.
|
Table Filter
| Optional. To filter the tables, enter values in any of the following filter fields, depending on the source type:
In any filter field, you can include the following wildcards to create a mask:
|
Respect Case
| By default, PowerExchange converts text that you enter in the filter boxes to the standard case for the data source. For example, on Oracle, uppercase is the standard. A value of
scott or
SCOTT would both produce
SCOTT .
Select the
Respect Case option for the filter fields for which you do
not want PowerExchange to use the standard case for the data source.
|
Escape Character
| Enter the escape character to use in the filter boxes to delimit an asterisk (*) or question mark (?) that is used a literal value instead of a wildcard.
For example, if you specify an escape character of
~ , a filter value of
tab* returns all tables that have table names beginning with
tab . A filter value of
tab~* returns the table that has the name
tab* .
Do not use an escape character with multibyte-enabled data sources.
|
Column
| Description
|
---|---|
Creator Name
| The creator name for the table
|
Schema
| The schema name
|
Name or Table
| The table name
|
Type
| The object type, such as TABLE
|
DataSet Name
| The data set name
|
Field
| Description
|
---|---|
Select Column
| A check box next to each column for selecting columns for registration.
Index columns are selected by default.
|
Name
| The column name.
|
CCSID
| For a DB2 source, the coded character set identifier (CCSID) related to the column.
|
PWXCP
| For a DB2 source, the PowerExchange internal representation of the code page.
|
Codepage
| For a DB2 source, the code page related to the column.
|
Check Box
| Description
|
---|---|
Select All Columns
| Available for source types that support selective column capture. Selects all columns in the
Columns list for change capture.
After you add the registration, any columns that are added to the source table are ignored until you edit the capture registration to select them.
|
Select all and notify changes
| Available for DB2 and Oracle sources. If you select this option, PowerExchange captures changes for all columns. Any change to the schema for the table causes PowerExchange CDC to fail and log an error message.
For a DB2 for z/OS source, the DB2 ECCR abnormally ends after it reads the first change record for the table after the schema change.
For an Oracle source, Oracle CDC fails and logs an error message in the following situations:
For Oracle CDC, if a definition for a table changes in a way that is compatible with the PowerExchange capture registration, Oracle CDC continues to capture changes for that table.
For example, if the length of a character column decreases but the capture registration does not reflect this change, Oracle CDC continues to capture changes for the table.
Conversely, if the datatype of a column changes from numeric to character without a change in the capture registration, Oracle CDC continues to capture changes for the table until it encounters the first change record that contains nonnumeric data for the column. When Oracle CDC encounters a change record containing nonnumeric data for the column, it fails and logs an error message.
If you clear the
Select all and notify changes option, the check boxes appear next to the columns are cleared. To select the columns again, you must select their check boxes.
|
Field
| Source Type
| Description
|
---|---|---|
Condense
| All
| Whether PowerExchange Condense or the PowerExchange Logger for Linux, UNIX, and Windows is used and the type of PowerExchange Condense processing on i5/OS or z/OS. Options are:
You can change the
Condense option later without incrementing the registration version number. For more information, see
Condense Options.
|
Status
| All
| The status of the capture registration with regard to availability for change capture use. Options are:
Default is
Inactive .
You can change the status from
Inactive to
Active later to make it eligible for change capture processing.
For more information about status settings, see
Status Options.
|
Comment
| All
| User-defined comments about the capture registration.
|
Database ID
| Adabas
| The DBID of the Adabas database that contains the file from which changes are captured.
|
File Number
| Adabas
| The file number of the Adabas file in the database identified by the
Database ID field.
|
Primary Dataset Name
| IMS synchronous
| The name of the primary data set for the IMS database. This name can be up to 44 characters in length. Depending on the database type, the primary data set is one of the following:
|
Supplement Log Group Name
| Oracle
| The name of the supplemental log group that you will create for the source. PowerExchange generates DDL for creating supplemental log groups when you complete the capture registration.
You must define a supplemental log group for each table for which you want PowerExchange to capture Oracle change data. This supplemental log group must contain all table columns for which change data is to be captured.
|
Execute DDL now
| Oracle
| For an Oracle source, select this option to run DDL to create a supplemental log group when you complete the capture registration.
Clear this option to run the DDL later.
You must also enter a value in the
Supplement Log Group Name box.
The GRANT statements in the ORACAPT.SQL file for the Oracle capture user do not include the authority that is required to run the DDL.
|