Table of Contents

Search

  1. Preface
  2. Introduction to PowerExchange
  3. DBMOVER Configuration File
  4. Netport Jobs
  5. PowerExchange Message Logs and Destination Overrides
  6. SMF Statistics Logging
  7. PowerExchange Security
  8. Secure Sockets Layer Support
  9. PowerExchange Alternative Network Security
  10. PowerExchange Nonrelational SQL
  11. PowerExchange Globalization
  12. Using the PowerExchange ODBC Drivers
  13. PowerExchange Datatypes and Conversion Matrix
  14. DTL__CAPXTIMESTAMP Time Stamps
  15. PowerExchange Glossary

Summary of All DBMOVER Statements

Summary of All DBMOVER Statements

PowerExchange provides DBMOVER statements that you use to configure PowerExchange.
The following table briefly defines all DBMOVER statements and provides cross-references to the complete description of each statement:
Statement
Description
Reference
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 - ORAD
Specifies the CAPI parameters to use for PowerExchange Express CDC for Oracle sources.
CAPI_CONNECTION - ORCL
Specifies the CAPI parameters to use for PowerExchange Oracle CDC with LogMiner 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 Listener, PowerExchange Condense, or PowerExchange for Linux, UNIX, and Windows Logger process that is the target of pwxcmd commands.
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_MSG
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.
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
Controls how the PowerExchange Listener accesses the file that stores data maps.
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.
DTLMSG_LANGUAGE
Specifies the language that, along with the UTF8 code page identifier, 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.
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.
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.
LDAP_BASE
Specifies the location within an LDAP directory from which to conduct a PowerExchange user search.
LDAP_BIND_DN
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.
LDAP_BIND_EPWD
Specifies the encrypted password for the LDAP search user.
LDAP_BIND_PWD
Specifies the password for the LDAP search user.
LDAP_BIND_TIMEOUT
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.
LDAP_FILTER
Specifies a filter to restrict the LDAP search for a PowerExchange user.
LDAP_HOST
Defines TCP/IP host details for any LDAP servers that PowerExchange might use for user validation.
LDAP_LOGIN_ATTRIBUTE
Specifies an LDAP attribute to use as a search key to match against a PowerExchange user ID.
LDAP_OPENSSL
Specifies Transport Layer Security (TLS) certificate information for a TLS connection to an LDAP server when PowerExchange is configured to use the OpenLDAP client.
LDAP_PORT
Defines the TCP/IP port for LDAP servers that PowerExchange might use for user validation.
LDAP_SASL_MECH
Specifies the authentication mechanism to use for the Simple Authentication and Security Layer (SASL) that is used with LDAP certificate-based security.
LDAP_SCOPE
Defines how deep to search in the LDAP tree within the search base in LDAP searches.
LDAP_SEARCH_TIMEOUT
Specifies the number of seconds that a PowerExchange Listener waits to receive a search result during PowerExchange user validation against LDAP.
LDAP_TLS
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.
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.
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.
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 which PowerExchange Oracle CDC solution is in use for a PowerExchange installation: PowerExchange Express CDC for Oracle or PowerExchange Oracle LogMiner CDC.
ORACLE_UNHANDLED_
NUMASCHAR
Controls whether PowerExchange handles the following types of numeric columns in Oracle source tables in a manner that prevents data loss:
  • TLSV1
    . The peer supports TLS version 1.
  • NUMBER columns that have a precision greater than 28 or an undefined length
  • FLOAT columns that have a precision greater than 15 significant digits
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 Oracle CDC with LogMiner and 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_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.
START_UP_USER_EXIT
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.
SUP_FUNC
Defines the function name of the zIIP enclave for the PowerExchange Listener to the IBM Workload Manager.
SUP_REQUEST
Defines the name of the requestor for zIIP facilities.
SUP_SSNAME
Defines the subsystem name that identifies the PowerExchange Listener started task to the IBM Workload Manager when zIIP exploitation is enabled.
SUP_SSTYPE
Defines the name that the IBM Workload Manager uses as the subsystem type for the enclave for zIIP.
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 Listener or PowerExchange Logger for Linux, UNIX, and Windows process listens for commands.
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.
TCPIP_DIAGNOSTICS_TRACE
Controls the issuing of network diagnostic messages PWX-33316, PWX-33317, and PWX-33318.
TCPIP_DIAGNOSTICS_TRACE_SZ
Controls the number of trace records to keep for network send and receive operations.
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.
USE_DB_AUTH
When LDAP authentication is enabled, controls whether or not LDAP validation applies to relational connections.
USE_TYPE1_FALLBACKS
Enables type 1 fallback mappings for all code pages.
USESUP
Controls whether PowerExchange uses zIIP for zIIP-enabled PowerExchange Listener functions.
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.
WORKCLASS
Defines the transaction name for Workload Manager classification when zIPP exploitation is enabled.
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.