PowerExchange for CDC and Mainframe
- PowerExchange for CDC and Mainframe 10.5.1
- All Products
Controls whether PowerExchange activates additional error routines to handle abends.
An Adabas optimization statement that controls whether PowerExchange uses Adabas L3 commands to read records from a file in logical sequence by descriptor value.
Controls whether PowerExchange issues the PWX-03206 message only once for each Adabas database that it accesses that does not have an Adabas DD statement for timezone (//TZINFO DD) defined.
Specifies the DBID value that PowerExchange uses when a data map specifies 0 in the
Database IDproperty and the bulk data movement session does not specify an override value.
Specifies whether Adabas multi-value (MU) fields are included in search functions. An MU field is a single field that occurs a variable number of times in a record. The MU field name is prefixed with a $ symbol and is allowed in searches. The MU field must be an Adabas descriptor field.
Specifies the prefix that PowerExchange uses to construct a user ID to access Adabas files.
Specifies the single-byte and multibyte code pages to use for an Adabas database.
An Adabas optimization statement that controls whether PowerExchange uses Adabas L3 commands to read records from a file in logical sequence by descriptor value.
Deprecated. Exists for backward compatibility.
Controls whether PowerExchange uses the Adabas prefetch feature when reading records.
Controls whether PowerExchange writes statistical information about Adabas operations to the PowerExchange message log file.
Controls whether PowerExchange uses the job name as the Adabas user ID to access Adabas files in a netport job.
Specifies the maximum data buffer size in bytes.
For supported data sources, specifies whether to dynamically increase the maximum data buffer size.
Specifies an event message queue on an i5/OS system to which PowerExchange writes messages that do not require an operator reply.
Specifies two-character journal entry type codes that identify add library and delete library operations in a DB2 for i5/OS journal. Use this statement to override the default codes that are used for refreshing the CDC library interest list after adding or deleting libraries that contain instances of the same source table.
Specifies the message queue on an i5/OS system to which PowerExchange writes messages that require an operator reply.
Specifies the block size that PowerExchange uses when dynamically allocating target data sets on z/OS if you do not provide a block size.
Specifies the default CAPI_CONNECTION statement for all data source types.
CAPI_CONNECTION - AS4J
Specifies the Consumer API (CAPI) parameters to use for DB2 for i5/OS CDC sources.
CAPI_CONNECTION - CAPX
Specifies the CAPI parameters to use for continuous extraction of change data from PowerExchange Logger for Linux, UNIX, and Windows log files.
CAPI_CONNECTION - HANA
Specifies the CAPI parameters to use for PowerExchange SAP HANA CDC sources.
CAPI_CONNECTION - LRAP
Specifies the CAPI parameters to use for the Log Read API (LRAPI) component of the PowerExchange Logger for z/OS.
CAPI_CONNECTION - MSQL
Specifies the CAPI parameters to use for Microsoft SQL Server CDC sources.
CAPI_CONNECTION - MYSQL
Specifies the CAPI parameters to use for MySQL CDC sources.
CAPI_CONNECTION - ORAD
Specifies the CAPI parameters to use for PowerExchange Express CDC for Oracle sources.
CAPI_CONNECTION - PG
Specifies the CAPI parameters to use for PowerExchange PostgreSQL CDC sources.
CAPI_CONNECTION - UDB
Specifies the CAPI parameters to use for DB2 for Linux, UNIX, and Windows (LUW) CDC sources.
CAPI_CONNECTION - UOWC
Specifies the CAPI parameters to use for the UOW Cleanser.
Specifies the default CAPI_CONNECTION statement for a specific data source type.
Specifies the path to the local directory on a Linux, UNIX, and Windows system that contains the control files for CDC.
Specifies the path to the local directory on a Linux, UNIX, and Windows system that stores extraction maps for CDC.
Specifies connection information for a PowerExchange process that can be the target of pwxcmd commands. Process types include the PowerExchange Listener, PowerExchange Condense, Power Exchange ECCRs on z/OS (Adabas, IDMS, or IMS log-based ECCRs, or Datacom table-based ECCR), and PowerExchange Logger for Linux, Unix and Windows.
Specifies the code pages that PowerExchange uses for operating system information, data, and literal values in SQL statements.
Defines the character that PowerExchange uses as a the delimiter character for time values in times and time stamp fields.
Controls whether PowerExchange uses its proprietary compression routines to compress data that it transmits across the network.
Specifies the code page that PowerExchange uses to display message text on consoles.
Specifies whether to write certain messages to the domain log in addition to writing them to the PowerExchange log file on the Integration Service machine.
Controls whether PowerExchange writes messages from TRACE statements to the DTLOUT data set for z/OS or to the QPRINT output for i5/OS, in addition to writing these messages to the PowerExchange message log file.
Controls how PowerExchange handles conversion errors for CHAR and VARCHAR columns that PowerExchange detects during bulk data movement read operations.
Specifies the name of the library that PowerExchange uses on i5/OS to read and store the extraction maps for DB2 for i5/OS CDC sources.
Controls the case that PowerExchange uses for operating system user IDs and passwords.
Specifies the node name of the PowerExchange Listener that acts as the server for access requests to the file that stores data maps.
Specifies the range of years that PowerExchange uses to validate data in DATE and TIMESTAMP fields if you enable data checking in a data map.
Controls whether PowerExchange considers data in CHAR and VARCHAR columns that you define with the FOR BIT DATA clause as character data.
Defines the single-byte and multibyte CCSID values that PowerExchange uses to process character data in columns that you define with the FOR BIT DATA clause, if you specify Y for the DB2_BIN_AS_CHAR statement.
Specifies the name of the user-customized SQL error file that PowerExchange uses for DB2 bulk data movement operations.
Defines the single-byte, mixed, and graphics CCSID values that PowerExchange uses to process bulk data from the specified DB2 subsystem.
Defines the default encoding scheme that PowerExchange assigns to any DB2 columns without an encoding scheme when you create a DB2 data map.
Defines the DB2 plan and the PowerExchange access method module that PowerExchange uses to process bulk data from the specified DB2 subsystem.
Defines the DB2 plan that PowerExchange uses for bulk data movement processing.
Defines the character that PowerExchange uses as the decimal point character in fields that contain noninteger numbers.
Defines the character that PowerExchange uses to replace any character data in a nonrelational data source that is not valid.
Defines a numeric date string that PowerExchange uses to replace any missing component in a date field.
Controls whether PowerExchange disables partitioning of the source data for bulk data movement operations.
Specifies the status, normal disposition, and abnormal disposition that PowerExchange uses when dynamically allocating target data sets on z/OS, if you do not provide DISP information.
Specifies the suffix that PowerExchange uses to create the PowerExchange-specific resource profile that controls access to the DATAMAPS data set.
Controls how the PowerExchange Listener accesses the file that stores data maps.
Determines whether PowerExchange frees ECSA memory when data maps caching runs in multiple-jobs mode and no files exist with nonzero use counts in ECSA memory
Enables PowerExchange data maps caching and configures the maximum size for the data maps cache in megabytes.
Determines whether PowerExchange runs data maps caching in multiple-jobs or single-job mode.
Specifies the location that PowerExchange uses to read and store data maps.
Specifies the code page identifier that indicates which version of the PowerExchange messages file to use.
Specifies the language that, along with the UTF8 code page identifier, indicates which version of the PowerExchange messages file to use.
Controls whether PowerExchange uses encryption when moving data. In addition to an internal proprietary encryption method, PowerExchange supports AES encryption.
If you enter AES in the ENCRYPT statement, you must include the ENCRYPTLEVEL statement.
Specifies the encryption level to use if you select AES encryption. The encryption level determines the encryption key length.
Specifies the major name for ENQ macros that PowerExchange issues to lock PowerExchange data sets and resources.
Controls whether PowerExchange uses a scope of SYSTEM or SYSTEMS for ENQ macros that it issues to lock PowerExchange data sets and resources.
Specifies whether PowerExchange generates or does not generate errors for UPDATE or DELETE operations on nonexistent rows.
Controls character conversion in
single-bytestatic code pages.
Specifies the directory that stores temporary file-mapped memory files for PowerExchange Listener statistics on AIX PPC64, i5/OS (IBM i), and Solaris SP64 systems.
Controls whether PowerExchange instructs dynamic allocation to use a LOCATE to get the most recent catalog information for generation data set allocation requests.
Enables you to increase the maximum internal buffer size for PowerExchange processing of a row of data when the default buffer size is not adequate.
Specifies an i5/OS host name that overrides the host name that PowerExchange retrieves from the TCP/IP Host table for communications with the PowerExchange Listener on i5/OS.
Adds or deletes an alias that points to a custom ICU code page.
Sets customized properties for an ICU code page.
Adds a code page converter to or deletes a code page converter from an ICU code page.
Defines the directory location for the binary CNV files that makeconv produces.
Controls whether IBM i second-level help information is included in PowerExchange messages that report operating system or API errors.
Suppresses spool file creation for PowerExchange tasks.
Controls whether to use Db2 system column names when performing PowerExchange database row tests and PowerExchange CDC registrations.
Identifies the high-level qualifier of the IMS bootstrap data set, which is used when reading source metadata from the IMS catalog. Also indicates the order in which PowerExchange searches for DBD information in the DBDLIB library or IMS catalog.
Defines the IMS subsystem information that PowerExchange uses for IMS bulk data movement operations and for IMS log-based CDC.
Specifies the job class that PowerExchange uses for CA IDMS/DB metadata and DB2 LOAD utility batch jobs.
Specifies the location within an LDAP directory from which to conduct a PowerExchange user search.
Specifies the distinguished name (DN) of an LDAP user with sufficient access rights to connect to LDAP and conduct a search for the PowerExchange user.
Specifies the encrypted password for the LDAP search user.
Specifies the password for the LDAP search user.
Specifies the number of seconds that a PowerExchange Listener or PowerExchange Logger for Linux, UNIX, and Windows waits to authenticate a search user or PowerExchange user against LDAP.
Specifies a filter to restrict the LDAP search for a PowerExchange user.
Defines TCP/IP host details for any LDAP servers that PowerExchange might use for user validation.
Specifies an LDAP attribute to use as a search key to match against a PowerExchange user ID.
Specifies Transport Layer Security (TLS) certificate information for a TLS connection to an LDAP server when PowerExchange is configured to use the OpenLDAP client.
Defines the TCP/IP port for LDAP servers that PowerExchange might use for user validation.
Specifies the authentication mechanism to use for the Simple Authentication and Security Layer (SASL) that is used with LDAP certificate-based security.
Defines how deep to search in the LDAP tree within the search base in LDAP searches.
Specifies the number of seconds that a PowerExchange Listener waits to receive a search result during PowerExchange user validation against LDAP.
Specifies Transport Layer Security (TLS) certificate information for a TLS connection to an LDAP server when PowerExchange is configured to use the Oracle LDAP client.
Defines the TCP/IP port on which a named PowerExchange Listener process listens for work requests.
Specifies the PDS data set that contains the control card template member for DB2 for z/OS LOAD utility batch jobs.
Specifies the PDS data set that contains the JCL template member for DB2 for z/OS LOAD utility and CA IDMS/DB metadata retrieval batch jobs.
Specifies the code page that PowerExchange uses to write messages to the log file.
Specifies the maximum line length for PowerExchange messages in the message log.
Defines the directory location where PowerExchange writes message log files on Linux, UNIX, and Windows systems.
Specifies the location of the CA IDMS/DB logs and the PowerExchange log catalog.
Specifies whether PowerExchange preserves hexadecimal '0' values in a VSAM or sequential data source when writing to a VSAM or sequential target.
Specifies the logical record length that PowerExchange uses when dynamically allocating target data sets on z/OS, if you do not provide LRECL information.
Specifies the partitioned data set extended (PDSE) that you allocated to hold database descriptor (DBD) output from the IMS Catalog Builder Utility, DFS3LU00.
Defines the maximum number of tasks that can run concurrently in a PowerExchange Listener.
Defines the string that PowerExchange uses to prefix PowerExchange messages.
Specifies whether PowerExchange includes or excludes the hyphen character between the message prefix and the message number.
Specifies the name of the user-customized SQL error file that PowerExchange uses for Microsoft SQL Server bulk data movement operations.
Specifies the timeout interval, in seconds, for a PowerExchange Navigator, DTLUCBRG utility, or DTLURDMO utility connection to a Microsoft SQL Server Management Objects (SMO) interface to manage SQL Server publications.
Specifies the timeout interval, in seconds, for processing a Transact-SQL statement issued by the PowerExchange Navigator, DTLUCBRG utility, or DTLURDMO utility to the Microsoft SQL Server Management Objects (SMO) interface.
Specifies which DB2 for z/OS attachment facility PowerExchange uses for DB2 bulk data movement operations.
Defines the character that PowerExchange uses as the negative sign character in fields that contain negative numbers.
Defines information about netport jobs and associates the netport job with a specific listener port.
Defines the TCP/IP host name and port that PowerExchange uses to contact a PowerExchange Listener process.
Controls whether PowerExchange gets the IP address of the local system to verify the license and include it in PowerExchange messages.
Defines the character or hexadecimal value that PowerExchange uses to replace null characters in a field.
Defines the numeric or hexadecimal value that PowerExchange uses to replace null values in an unpacked numeric field.
Controls whether PowerExchange delivers unsigned fields as a positive X’C’ or as unsigned X’F’.
Controls whether PowerExchange can use the Open Database Access (ODBA) interface to access IMS databases and unload data sets for bulk data movement operations.
Specifies additional DataDirect ODBC parameters for connections to Microsoft SQL Server, MySQL, or PostgreSQL sources on selected servers, which are used for change data capture and for creating, deleting, or modifying capture registrations.
Specifies the number of passes the PowerExchange Listener makes in its main polling loop, waiting for an open request for a tape data set to complete on z/OS. To calculate the time limit, the OPENPOLL value is multiplied by the POLLTIME value.
The OPENPOLL statement is intended to relieve constraints on running other workflows in situations where the availability of tape data sets or devices cannot be guaranteed.
Specifies the name of the user-customized SQL error file that PowerExchange uses for Oracle bulk data movement operations.
Specifies that PowerExchange Express CDC for Oracle is the CDC solution to use for a PowerExchange installation.
Controls whether PowerExchange handles the following types of numeric columns in Oracle source tables in a manner that prevents data loss:
Specifies the PowerExchange and PowerCenter code pages to use for a specific Oracle database used in Oracle bulk data movement, if the NLS_LANG environment variable specifies a character set other than UTF8 or AL32UTF8.
Specifies the Oracle source database and connection information for PowerExchange Express CDC for Oracle.
Loads the z/OS OpenEdition security environment when using ADABAS. Use at the direction of Informatica Global Customer Support.
Controls whether the PowerExchange Listener uses its MVS Program Call (PC) services routine to acquire the authorization to access CA IDMS/DB.
Defines the character that PowerExchange uses to separate fields in a TXT output file.
Defines the amount of time, in milliseconds, that the PowerExchange Listener waits before polling for outstanding connections.
Controls whether PowerExchange automatically attempts to use offload processing in PowerExchange 8.6.1 and later.
Controls whether PowerExchange writes or does not write read progress messages to the PowerExchange message log file.
Defines the interval after which PowerExchange writes read progress messages to the PowerExchange message log file, if requested.
Specifies the maximum number of TCP/IP socket connections that a PowerExchange Listener uses to listen for work.
Specifies the library name that contains the QAQQINI query options file for an IBM i system.
Specifies the RACF class name that PowerExchange uses when checking PowerExchange-specific resource profiles.
Controls whether PowerExchange uses DB2 default values for DB2 columns that you define with the WITH DEFAULT clause.
Specifies the record format that PowerExchange uses when dynamically allocating target data sets on z/OS, if you do not provide RECFM information.
Defines the character that PowerExchange uses as the default delimiter character in a reject file.
Controls whether PowerExchange requests or does not request to release unused space for data sets that it dynamically allocates.
Defines the name of the DB2 for i5/OS database on the local system that contains the source tables for CDC in a remote journaling environment.
Defines the name of the i5/OS host system that contains the DB2 source tables for CDC, local journals, and journal receivers.
Controls whether PowerExchange completes user authentication, and controls access to resources and commands.
Controls whether to suppress the messages that are issued by RACF or a similar z/OS security product, such as CA Top Secret or ACF2, when verifying the logon credentials of a PowerExchange job or started task.
Specifies the time, in seconds, that a PowerExchange Listener or Logger waits to receive heartbeat data from the associated Listener Service or Logger Service before shutting down and issuing an error message.
Specifies the value to use as the DB2 Correlation ID for DB2 requests.
Specifies the number of records PowerExchange processes before writing statistics messages about multithreaded processing to the PowerExchange message log file.
Specifies the units and the primary and secondary space values that PowerExchange uses when dynamically allocating target data sets on z/OS, if you do not provide SPACE information.
Specifies SSL certificate information for a Secure Sockets Layer (SSL) connection.
Specifies the type of certificate to use for SSL security. You can use either self-signed certificates or certificates from a commercial certificate authority that the system trusts.
Restricts the available ciphers that a client offers to a server during an SSL handshake to the specified list.
Selects the TLS version that the peer supports for PowerExchange SSL communication.
Controls whether to continue or stop processing after a certificate error 6000 has been reported. This situation occurs when SSL_REQ_CLNT_CERT=Y and the partner CA is not present among the trusted CAs on the IBM i machine.
Controls whether a PowerExchange server authenticates the identity of a PowerExchange client by using an SSL certificate.
Controls whether a PowerExchange client authenticates the identity of a PowerExchange server by using an SSL certificate.
Specifies the name and programming language of a user exit program that PowerExchange calls each time the PowerExchange Listener starts or shuts down.
Use this statement to enable the PowerExchange Listener to decrypt an Adabas database that is encrypted with an Adabas cipher code.
Controls whether PowerExchange writes SMF statistics records for the PowerExchange Listener to SMF or to a file.
Specifies the time, in seconds, that a PowerExchange Listener waits to receive notification from a spawned batch job that it has started.
Defines the function name of the zIIP enclave for the PowerExchange Listener to the IBM Workload Manager.
Defines the name of the requestor for zIIP facilities.
Defines the subsystem name that identifies the PowerExchange Listener started task to the IBM Workload Manager when zIIP exploitation is enabled.
Defines the name that the IBM Workload Manager uses as the subsystem type for the enclave for zIIP.
Controls whether PowerExchange writes a message that displays the first 40 characters of any row that fails the data checking options specified in a data map.
Specifies the TCP/IP port on which a PowerExchange process listens for pwxcmd or infacmd commands. Process types include the PowerExchange Listener, PowerExchange Condense, Power Exchange ECCRs on z/OS (Adabas, IDMS, or IMS log-based ECCRs, or Datacom table-based ECCR), and PowerExchange Logger for Linux, Unix and Windows.
You can include up to 30 SVCNODE entries in the DBMOVER configuration file.
Controls whether PowerExchange includes time stamp information in output files and console output.
Controls whether netport jobs wait or do not wait for tape volumes.
Specifies whether TCP/IP ports on which the PowerExchange Listener listens are blocking or nonblocking.
Controls the issuing of network diagnostic messages PWX-33316, PWX-33317, and PWX-33318.
Controls the number of trace records to keep for network send and receive operations.
Deprecated. Exists for backward compatibility.
Specifies alternative TCP/IP socket code that PowerExchange uses instead of the standard IBM TCP/IP UNIX socket code.
Overrides the high-level qualifier that PowerExchange uses by default when creating a temporary file for CA IDMS/DB metadata.
Specifies the directory location where PowerExchange writes temporary files if the TMPDIR or TMP environment variable is not set on a Linux, UNIX, or Windows system.
Controls whether PowerExchange ignores hexadecimal value 1A when reading binary flat files on Linux, UNIX, or Windows.
Specifies a local time zone that PowerExchange uses for reading or writingSpecifies the directory location where PowerExchange writes temporary files if the TMPDIR or TMP environment variable is not set. Adabas date-time values for bulk data movement sessions.
Activates traces in PowerExchange code paths for diagnostic purposes.
Activates PowerExchange alternative logging and specifies attributes for the alternative log files.
Specifies the generic or esoteric unit name that PowerExchange uses when dynamically allocating target data sets on z/OS, if you do not provide UNIT information.
Controls whether the LAST-ACCESS date in RACF is updated when a user connection is made to a PowerExchange Listener on z/OS.
When LDAP authentication is enabled, controls whether or not LDAP validation applies to relational connections.
Enables type 1 fallback mappings for all code pages.
Controls whether PowerExchange uses zIIP for zIIP-enabled PowerExchange Listener functions.
Specifies the volume serial number that PowerExchange uses when dynamically allocating target data sets on z/OS, if you do not provide VOLSER information.
Specifies the number of buffers that PowerExchange uses for data and index control intervals when processing VSAM data sets.
Controls whether netport jobs wait for in-use data sets.
Defines the transaction name for Workload Manager classification when zIPP exploitation is enabled.
Indicates whether to use an alternative method of handling error messages returned from the PowerExchange Listener for bulk data movement sessions that use writer partitioning.