PowerExchange for CDC and Mainframe
- PowerExchange for CDC and Mainframe 10.4.0 HotFix 1
- All Products
Parameter
| Default
| Tokens
| Usage
|
---|---|---|---|
CAPXIMAGETYPE
| None
| BA, AI, or TU
| The capture image type for accessing PowerExchange CDC or live data. The options are:
|
CAPXTYPE
| None
| SL or RS
| The type of extraction. The options are:
|
COMPATIBILITY
| None
| -
| The integration mask. Includes the following options:
In addition, you can enable the following COMPATIBILITY options by specifying either the specific option or the ILMBRIDGE option:
|
COMPRESS
| N
| Y, N
| Set this parameter to compress data.
Default is N.
|
CONFIRMWRITE
| Y
| Y, N, or T
| For DB2, DB2UDB, DB2400C, MSSQL, NRDB, NRDB2, ODBC, or ORACLE data source types only.
The write mode.
The options are:
Default is Y.
|
DATABASE
| -
| -
| For DB2 for Linux, UNIX, and Windows only. Overrides the database connection value specified in the PowerExchange extraction map.
|
DB2DEGREE
| None
| Any string of text up to 30 characters
| For DB2 for i5/OS and DB2 for z/OS only. Sends the following SQL command to DB2, specifying whether DB2 should use, or not use, inter-partition parallel processing:
For more information about the effect of each value in the SQL command, see the relevant IBM DB2 documentation for the "SET CURRENT DEGREE" and "CHGQRYA DEGREE" commands.
For z/OS only:
Any text following the equals sign is taken as text to follow a
'SET CURRENT DEGREE =' .
For example, specifying
DB2DEGREE=ANY runs the statement
"SET CURRENT DEGREE = 'ANY'" , and would set DB2 to be able to use parallel processing.
For i5/OS only:
Any text following the equals sign is taken as text to follow a
'CHGQRYA DEGREE' statement.
For example, specifying
DB2DEGREE=SYSTEM runs the statement
"CHGQRYA DEGREE(*SYSTEM)" .
To maintain compatibility with previous releases, if the parameter begins with a digit, it is appended to a
"CHGQRYA DEGREE(*NBRTASKS)" statement. Thus a
"CHGQRYA DEGREE(*NBRTASKS 1)" statement can be generated with either a
DB2DEGREE=1 or
DB2DEGREE="*NBRTASKS 1" statement.
|
DBQUAL1
| None
| See subsequent table.
| See subsequent table.
|
DBQUAL2
| None
| See subsequent table.
| See subsequent table.
|
DESCRIPTION
| None
| Text
| Descriptive text.
|
DRIVER
| None
| Path/File
| The path and file name of the PowerExchange ODBC driver. The file name can have the suffix.so or .sl according to the version of UNIX being run. Review the suffixes on the existing PowerExchange shared libraries to choose the correct one.
|
DTLAPP
| -
| -
| Application name. Specifying the application name that identifies extracts increases the ability to identify individual use of a single connection. This is then available to task control.
|
DTLCONN_OVR
| None
| Not applicable
| The name in the CAP_CONNECTION statement in the DBMOVER configuration file that points to the relevant data source.
|
DTLIMGOV
| N
| Y or N
| For DB2390IMG only.
If the image copy data set is specified, PowerExchange checks that the image copy file exists and that a consistent image copy is selected. If either of these is not true, such as when the image copy file does not exist or is inconsistent, the request is rejected and a message is displayed.
You can override this behavior by setting the DTLIMGOV parameter to Y. This setting enables inconsistent image copies to be read.
|
ENCRYPT
| N
| N, Y, AES
| The encryption option. The options are:
If you specify an encryption option, you must also specify an encryption level in the ENCRYPTLEVEL parameter.
The values of DES and RC2 are deprecated. PowerExchange converts a value of DES or RC2 to AES.
|
ENCRYPTLEVEL
| -
| 1, 2 or 3
| The encryption level. Required if the ENCRYPT parameter is set to DES or RC2.
The options are:
|
INTERPRETASROWS
| N
| Y, N
| Indicates whether to interpret the pacing size in rows or kilobytes. The options are:
Default is Y.
|
ISOLATION
| NONE
| ALL, CHG, CS, NONE, or RR
| For DB2 for i5/OS only. The commit scope of the transaction. This parameter is typically set to CS.
|
JRNL
| -
| LIBRARY/JOURNAL
| For i5/OS only. The fully qualified library and journal name that is to be used instead of that specified in the PowerExchange capture registration.
For example:
|
LIBRARYLIST
| Maximum of 34 libraries.
Each library name is a maximum length of ten characters.
| A space-delimited list of libraries that PowerExchange searches to qualify the first table name, if the table name is unqualified, on a select, insert, delete, or update statement.
If you specify a library list in both the LIBRARYLIST and OVRDBF parameters, and a table is found in both lists, the table found in the OVRDBF parameter takes precedence.
| |
LOCALCODEPAGE
| None
| -
| A number that identifies the code page to be used. For example 41 represents UTF-8.
Specify NONE to use the code page value specified in the DBMOVER configuration file at run time.
You can use the icucheck.exe command-line utility to generate a lookup list of numbers with the corresponding code page names. You can pipe the results of the utility to a file as follows:
|
LOCATION
| None
| None
| The location of the data source.
The location is defined by a NODE statement in the dbmover.cfg configuration file on the local system.
|
MAXROWS
| 0
| 0 to 2147483647
| The maximum number of rows for retrieval.
Default is 0, which indicates unlimited rows.
|
MQGETOPT
| R
| B or R
| The type of read operation to be performed from an MQSeries queue.
The options are:
Default is R.
|
NOUPDATECDEP
| N
| Y or N
| Indicates whether database row test output is to be added to the PowerExchange CDC audit trail.
The options are:
|
ORACOLL
| -
| -
| Overrides the value specified in the ORACOLL parameter in the ORAD CAPI_CONNECTION statement in the DBMOVER configuration file.
Enables the use of a single set of capture registrations to capture data from up to ten Oracle instances at once.
|
ORACONN
| -
| -
| Overrides the Oracle connection string value in the third positional parameter in the ORACLEID statement in the dbmover.cfg configuration file. For example:
Used in conjunction with the ORAINST value to enable the use of a single set of capture registrations to capture data from multiple Oracle instances.
If you specify an ORACONN value without an ORAINST value, Oracle capture uses the Oracle connection string value specified in the ORACLEID statement in the dbmover.cfg file.
|
ORAINST
| -
| -
| Overrides the Oracle instance value in the second positional parameter in the ORACLEID statement in the dbmover.cfg configuration file.
For example:
Used in conjunction with the ORACONN value to enable the use of a single set of capture registrations to capture data from multiple Oracle instances.
If you specify an ORAINST value, but no ORACONN value, Oracle capture uses the Oracle connection string value specified in the ORACLEID statement in the dbmover.cfg file.
|
ORASCHEMA
| -
| -
| Overrides the Oracle schema value in a PowerExchange registration group to enable the use of a single set of capture registrations to capture data from multiple schemas that might exist in an Oracle instance.
|
OVRDBF
| -
| Maximum of eight files. Each file specification is a maximum length of 43 characters, as follows:
| Space-delimited list of file overrides in the following format:
Alternatively, you can use the following format:
In this format, the member defaults to *FIRST.
When you use this override, any occurrence of the specified file name in a SQL statement is overridden with the
newlibrary/newfilename/newmembername combination, regardless of whether the file is qualified or not. This includes any files that are specified in the LIBRARYLIST override.
If you specify a library list in both the LIBRARYLIST and OVRDBF parameters, and a table is found in both lists, the table found in the OVRDBF parameter takes precedence.
|
PACESIZE
| Value of the API rows_requested parameter.
| Numeric
| The number of rows or kilobytes. Set this parameter when an application, such as an interactive application, cannot keep pace with the flow of data from the PowerExchange Listener.
For maximum performance, set this parameter to 0.
|
PWXOVERRIDES
| None
| -
| Overrides that apply to PowerExchange ODBC connections for bulk data movement and CDC sessions:
Use the following syntax:
If you specify multiple overrides, use a semicolon (;) as a separator, for example:
|
REJECTFILE
| None
| Up to 384 characters
| Available only if the CONFIRMWRITE parameter is set to T, which enables asynchronous with fault tolerance mode.
The location and file name of the reject file that is used during asynchronous write operations.
Enter a value of PWXDISABLE to disable reject file logging.
For more information, see the
PowerExchange Bulk Data Movement Guide .
|
STOPONERRORS
| 0
| 0 to 2147483647
| Available only if the CONFIRMWRITE parameter is set to T, which enables asynchronous with fault tolerance mode.
The number of non-fatal errors that are allowed in the write phase before processing is terminated.
For more information, see the
PowerExchange Bulk Data Movement Guide .
|
UAP
| None
| -
| For DB2 for i5/OS data sources only. Overrides the fully qualified library and journal name specified in the PowerExchange capture registration.
For example:
|
WAITTIME
| -
| 0
2 to 86399
86400
| The maximum approximate time, in seconds, to wait for data before returning end-of-file (EOF). The options are:
|
XTRASCHEMA
| -
| Up to 128 characters with no spaces allowed.
| Overrides the schema defined in the extraction map.
|
Tokens
| DBType
|
---|---|
i5/OS Library/Filename
| CAPX and CAPX/RT
|
SSID or DBName
| DB2, DB2400C, and DB2UDB
|
Not applicable
| DB2390IMG
|
Not applicable
| IMSUNLD
|
DSN
| MSSQL
|
Not applicable
| NRDB and NRDB2
|
SQL *Net Name
| ORACLE
|
Tokens
| DBType
|
---|---|
Application name
| CAPX and CAPX/RT
|
Not applicable
| DB2, DB2400C, and DB2UDB
|
SSID
| DB2390IMG
|
Not applicable
| IMSUNLD
|
Database
| MSSQL
|
Not applicable
| NRDB and NRDB2
|
Not applicable
| ORACLE
|
Any supported data source, such as DB2
| Access method for file or database.
|