ABEND_SW

Controls whether PowerExchange activates additional error routines to handle abends.

ADA_L3_ALLOW

An Adabas optimization statement that controls whether PowerExchange uses Adabas L3 commands to read records from a file in logical sequence by descriptor value.

ADA_TIMEZONE_CHECK

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.

ADABAS_DEFAULT_DBID

Specifies the DBID value that PowerExchange uses when a data map specifies 0 in the

Database ID

property and the bulk data movement session does not specify an override value.

ADABAS_PREFIX

Specifies the prefix that PowerExchange uses to construct a user ID to access Adabas files.

ADABASCODEPAGE

Specifies the single-byte and multibyte code pages to use for an Adabas database.

ADAOPT

An Adabas optimization statement that controls whether PowerExchange uses Adabas L3 commands to read records from a file in logical sequence by descriptor value.

ADAOPTM

Deprecated. Exists for backward compatibility.

ADAPREFETCH

Controls whether PowerExchange uses the Adabas prefetch feature when reading records.

ADASTATS

Controls whether PowerExchange writes statistical information about Adabas operations to the PowerExchange message log file.

ADAUSER

Controls whether PowerExchange uses the job name as the Adabas user ID to access Adabas files in a netport job.

APPBUFSIZE

Specifies the maximum data buffer size in bytes.

APPBUFSIZEDYN

For supported data sources, specifies whether to dynamically increase the maximum data buffer size.

AS400EVENTMSGQ

Specifies an event message queue on an i5/OS system to which PowerExchange writes messages that do not require an operator reply.

AS400USRJRNCODE

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.

AS400USRMSGQ

Specifies the message queue on an i5/OS system to which PowerExchange writes messages that require an operator reply.

BS

Specifies the block size that PowerExchange uses when dynamically allocating target data sets on z/OS if you do not provide a block size.

CAPI_CONN_NAME

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 - 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.

CAPI_SRC_DFLT

Specifies the default CAPI_CONNECTION statement for a specific data source type.

CAPT_PATH

Specifies the path to the local directory on a Linux, UNIX, and Windows system that contains the control files for CDC.

CAPT_XTRA

Specifies the path to the local directory on a Linux, UNIX, and Windows system that stores extraction maps for CDC.

CMDNODE

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.

CODEPAGE

Specifies the code pages that PowerExchange uses for operating system information, data, and literal values in SQL statements.

COLON

Defines the character that PowerExchange uses as a the delimiter character for time values in times and time stamp fields.

COMPRESS

Controls whether PowerExchange uses its proprietary compression routines to compress data that it transmits across the network.

CONSOLE_CODEPAGE

Specifies the code page that PowerExchange uses to display message text on consoles.

CONSOLE_TRACE

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.

CONVCHAR

Controls how PowerExchange handles conversion errors for CHAR and VARCHAR columns that PowerExchange detects during bulk data movement read operations.

CPX_DIR

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.

CREDENTIALS_CASE

Controls the case that PowerExchange uses for operating system user IDs and passwords.

DATAMAP_SERVER

Specifies the node name of the PowerExchange Listener that acts as the server for access requests to the file that stores data maps.

DATERANGE

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.

DB2_BIN_AS_CHAR

Controls whether PowerExchange considers data in CHAR and VARCHAR columns that you define with the FOR BIT DATA clause as character data.

DB2_BIN_CODEPAGE

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.

DB2_ERRORFILE

Specifies the name of the user-customized SQL error file that PowerExchange uses for DB2 bulk data movement operations.

DB2CODEPAGE

Defines the single-byte, mixed, and graphics CCSID values that PowerExchange uses to process bulk data from the specified DB2 subsystem.

DB2DEF_ENCODING

Defines the default encoding scheme that PowerExchange assigns to any DB2 columns without an encoding scheme when you create a DB2 data map.

DB2ID

Defines the DB2 plan and the PowerExchange access method module that PowerExchange uses to process bulk data from the specified DB2 subsystem.

DB2PLAN

Defines the DB2 plan that PowerExchange uses for bulk data movement processing.

DECPOINT

Defines the character that PowerExchange uses as the decimal point character in fields that contain noninteger numbers.

DEFAULTCHAR

Defines the character that PowerExchange uses to replace any character data in a nonrelational data source that is not valid.

DEFAULTDATE

Defines a numeric date string that PowerExchange uses to replace any missing component in a date field.

DISABLE_PARTITIONS

Controls whether PowerExchange disables partitioning of the source data for bulk data movement operations.

DISP

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.

DM_RESOURCE

Specifies the suffix that PowerExchange uses to create the PowerExchange-specific resource profile that controls access to the DATAMAPS data set.

DM_SUBTASK

DMXCACHE_DELETEECSA

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

DMXCACHE_MAX_MEMORY_MB

Enables PowerExchange data maps caching and configures the maximum size for the data maps cache in megabytes.

DMXCACHE_MULTIPLEJOBS

Determines whether PowerExchange runs data maps caching in multiple-jobs or single-job mode.

DMX_DIR

Specifies the location that PowerExchange uses to read and store data maps.

DTLMSG_CODEPAGE

Specifies the code page identifier that indicates which version of the PowerExchange messages file to use.

ENCRYPT

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.

ENCRYPTLEVEL

Specifies the encryption level to use if you select AES encryption. The encryption level determines the encryption key length.

ENQMAJORNAME

Specifies the major name for ENQ macros that PowerExchange issues to lock PowerExchange data sets and resources.

ENQSYSTEMS

Controls whether PowerExchange uses a scope of SYSTEM or SYSTEMS for ENQ macros that it issues to lock PowerExchange data sets and resources.

ERRROWNOTFOUND

Specifies whether PowerExchange generates or does not generate errors for UPDATE or DELETE operations on nonexistent rows.

EXT_CP_SUPPT

Controls character conversion in

single-byte

static code pages.

FILEMAPPED_MEMORY_DIR

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.

GDGLOCATE

Controls whether PowerExchange instructs dynamic allocation to use a LOCATE to get the most recent catalog information for generation data set allocation requests.

GSBUFSIZE

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.

HOSTNAME

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.

ICUALIAS

Adds or deletes an alias that points to a custom ICU code page.

ICUCNVPROPERTY

Sets customized properties for an ICU code page.

ICUCONVERTER

Adds a code page converter to or deletes a code page converter from an ICU code page.

ICUDATADIR

Defines the directory location for the binary CNV files that makeconv produces.

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.

IMSID

Defines the IMS subsystem information that PowerExchange uses for IMS bulk data movement operations and for IMS log-based CDC.

JOBCLASS

Specifies the job class that PowerExchange uses for CA IDMS/DB metadata and DB2 LOAD utility batch jobs.

LISTENER

Defines the TCP/IP port on which a named PowerExchange Listener process listens for work requests.

LOADCTLFILE

Specifies the PDS data set that contains the control card template member for DB2 for z/OS LOAD utility batch jobs.

LOADJOBFILE

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.

LOG_CODEPAGE

Specifies the code page that PowerExchange uses to write messages to the log file.

LOG_LINE_LIMIT

Specifies the maximum line length for PowerExchange messages in the message log.

LOGPATH

Defines the directory location where PowerExchange writes message log files on Linux, UNIX, and Windows systems.

LOGSID

Specifies the location of the CA IDMS/DB logs and the PowerExchange log catalog.

LOWVALUES

Specifies whether PowerExchange preserves hexadecimal '0' values in a VSAM or sequential data source when writing to a VSAM or sequential target.

LRECL

Specifies the logical record length that PowerExchange uses when dynamically allocating target data sets on z/OS, if you do not provide LRECL information.

LU00FILE

Specifies the partitioned data set extended (PDSE) that you allocated to hold database descriptor (DBD) output from the IMS Catalog Builder Utility, DFS3LU00.

MAXTASKS

Defines the maximum number of tasks that can run concurrently in a PowerExchange Listener.

MSGPREFIX

Defines the string that PowerExchange uses to prefix PowerExchange messages.

MSGPREFIX-HYPHEN

Specifies whether PowerExchange includes or excludes the hyphen character between the message prefix and the message number.

MSS_ERRORFILE

Specifies the name of the user-customized SQL error file that PowerExchange uses for Microsoft SQL Server bulk data movement operations.

MSSQL_SERVER_CONNECT_

TIMEOUT

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.

MSSQL_SERVER_STATEMENT_TIMEOUT

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.

MVSDB2AF

Specifies which DB2 for z/OS attachment facility PowerExchange uses for DB2 bulk data movement operations.

NEGSIGN

Defines the character that PowerExchange uses as the negative sign character in fields that contain negative numbers.

NETPORT

Defines information about netport jobs and associates the netport job with a specific listener port.

NODE

Defines the TCP/IP host name and port that PowerExchange uses to contact a PowerExchange Listener process.

NOGETHOSTBYNAME

Controls whether PowerExchange gets the IP address of the local system to verify the license and include it in PowerExchange messages.

NRDB_WRITE_CHAR_NULL_

FILL

Defines the character or hexadecimal value that PowerExchange uses to replace null characters in a field.

NRDB_WRITE_NUM_NULL_FILL

Defines the numeric or hexadecimal value that PowerExchange uses to replace null values in an unpacked numeric field.

NUMERICSIGN

Controls whether PowerExchange delivers unsigned fields as a positive X’C’ or as unsigned X’F’.

ODBASUPP

Controls whether PowerExchange can use the Open Database Access (ODBA) interface to access IMS databases and unload data sets for bulk data movement operations.

ODBC_CONN_PARAMS

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.

ORA_ERRORFILE

Specifies the name of the user-customized SQL error file that PowerExchange uses for Oracle bulk data movement operations.

ORACLE_CAPTURE_TYPE

Specifies that PowerExchange Express CDC for Oracle is the CDC solution to use for a PowerExchange installation.

ORACLE_UNHANDLED_

NUMASCHAR

Controls whether PowerExchange handles the following types of numeric columns in Oracle source tables in a manner that prevents data loss:

ORACLECODEPAGE

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.

ORACLEID

Specifies the Oracle source database and connection information for PowerExchange Express CDC for Oracle.

OUSP

Loads the z/OS OpenEdition security environment when using ADABAS. Use at the direction of Informatica Global Customer Support.

PC_AUTH

Controls whether the PowerExchange Listener uses its MVS Program Call (PC) services routine to acquire the authorization to access CA IDMS/DB.

PIPE

Defines the character that PowerExchange uses to separate fields in a TXT output file.

POLLTIME

Defines the amount of time, in thousandths of a second, that the PowerExchange Listener waits before polling for outstanding connections.

PRE861_COMPAT

Controls whether PowerExchange automatically attempts to use offload processing in PowerExchange 8.6.1 and later.

PRGIND

Controls whether PowerExchange writes or does not write read progress messages to the PowerExchange message log file.

PRGINT

Defines the interval after which PowerExchange writes read progress messages to the PowerExchange message log file, if requested.

PWXSOMAXCONN

Specifies the maximum number of TCP/IP socket connections that a PowerExchange Listener uses to listen for work.

RACF_CLASS

Specifies the RACF class name that PowerExchange uses when checking PowerExchange-specific resource profiles.

RDBMSINSRTDFLT

Controls whether PowerExchange uses DB2 default values for DB2 columns that you define with the WITH DEFAULT clause.

RECFM

Specifies the record format that PowerExchange uses when dynamically allocating target data sets on z/OS, if you do not provide RECFM information.

REJECT_FILE_DELIMITER

Defines the character that PowerExchange uses as the default delimiter character in a reject file.

RELEASE

Controls whether PowerExchange requests or does not request to release unused space for data sets that it dynamically allocates.

RMTRDBDIRE

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.

RMTSYSNAME

Defines the name of the i5/OS host system that contains the DB2 source tables for CDC, local journals, and journal receivers.

SECURITY

Controls whether PowerExchange completes user authentication, and controls access to resources and commands.

SECURITY_MSGSUPP

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.

SERVICE_TIMEOUT

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.

SESSID

Specifies the value to use as the DB2 Correlation ID for DB2 requests.

SHOW_THREAD_PERF

Specifies the number of records PowerExchange processes before writing statistics messages about multithreaded processing to the PowerExchange message log file.

SPACE

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.

SSL

Specifies SSL certificate information for a Secure Sockets Layer (SSL) connection.

SSL_ALLOW_SELFSIGNED

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.

SSL_CIPHER_LIST

Restricts the available ciphers that a client offers to a server during an SSL handshake to the specified list.

SSL_CONTEXT_METHOD

Selects the TLS version that the peer supports for PowerExchange SSL communication.

SSL_TOLERATE_UNTRUSTED_ISSUER

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.

SSL_REQ_CLNT_CERT

Controls whether a PowerExchange server authenticates the identity of a PowerExchange client by using an SSL certificate.

SSL_REQ_SRVR_CERT

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.

STATS

Controls whether PowerExchange writes SMF statistics records for the PowerExchange Listener to SMF or to a file.

SUBMITTIMEOUT

Specifies the time, in seconds, that a PowerExchange Listener waits to receive notification from a spawned batch job that it has started.

SUPPRESS_DATA_LOGGING

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.

SVCNODE

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.

SYSOUT_TIMESTAMP

Controls whether PowerExchange includes time stamp information in output files and console output.

TAPEWAIT

Controls whether netport jobs wait or do not wait for tape volumes.

TCPIPBUFSIZE

Deprecated. Exists for backward compatibility.

TCPIPVER

Specifies alternative TCP/IP socket code that PowerExchange uses instead of the standard IBM TCP/IP UNIX socket code.

TEMPHLQ

Overrides the high-level qualifier that PowerExchange uses by default when creating a temporary file for CA IDMS/DB metadata.

TEXT_EOF_FOR_BINARY

Controls whether PowerExchange ignores hexadecimal value 1A when reading binary flat files on Linux, UNIX, or Windows.

TIMEZONE

Specifies a local time zone that PowerExchange uses for reading or writing Adabas date-time values for bulk data movement sessions.

TRACE

Activates traces in PowerExchange code paths for diagnostic purposes.

TRACING

Activates PowerExchange alternative logging and specifies attributes for the alternative log files.

UNIT

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.

Enables type 1 fallback mappings for all code pages.

VOLSER

Specifies the volume serial number that PowerExchange uses when dynamically allocating target data sets on z/OS, if you do not provide VOLSER information.

VSAM

Specifies the number of buffers that PowerExchange uses for data and index control intervals when processing VSAM data sets.

WAITDSN

Controls whether netport jobs wait for in-use data sets.

WRT_ERROR_HANDLING

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.