PowerExchange Interfaces for PowerCenter

10.5
- 10.5.8
- 10.5.6
- 10.5.5
- 10.5.4
- 10.5.3
- 10.5.2
- 10.5.1
- 10.4.1
- 10.4.0 HotFix 1
- 10.4.0

Back Next

NRDB Batch Application Connections

Configure NRDB Batch application connections to extract data from and load data to nonrelational sources and targets in bulk data movement sessions. Also use NRDB Batch application connections to apply change data to nonrelational targets in CDC sessions.

The following table describes the connection attributes for the PWX NRDB Batch application connection type:

Connection Attribute	Required	Description
Name	Yes	The name of the application connection.
Code Page	Yes	The code page for the PowerCenter Integration Service to use to extract data from the source database. In Unicode mode, PWXPC sets the code page with this value overriding any code page specification in the PowerExchange configuration file.
Location	Yes	The location of the source or target database as specified in a NODE statement in the PowerExchange dbmover.cfg configuration file.
User Name	Yes	The database user name. For databases on supported Linux, UNIX, or Windows systems, if you have enabled PowerExchange LDAP user authentication, the user name is the enterprise user name. For more information, see the PowerExchange Reference Manual .
Password	Yes	A password for the specified user or a valid PowerExchange passphrase. Passwords that are less than nine characters in length are not validated. To avoid errors that might arise due to code page differences, Informatica recommends that the password includes only those characters that are allowed for passphrases. For nonrelational sources or targets on z/OS, and for sequential source or target files on i5/OS, you can enter a passphrase instead of a password. An i5/OS passphrase can be from 9 to 31 characters in length. A z/OS passphrase can be from 9 to 128 characters in length with a PWXPC connection. A passphrase can contain the following characters: Uppercase and lowercase letters The numbers 0 to 9 Spaces The following special characters: ’ - ; # \ , . / ! % & * ( ) _ + { } : @ \| < > ? The first character is an apostrophe. Passphrases cannot include single quotation marks (‘), double quotation marks (“), or currency symbols. On z/OS, the allowable characters in the IBM IRRPHREX exit do not affect the allowable characters in PowerExchange passphrases. On z/OS, a valid RACF passphrase can be up to 100 characters in length. PowerExchange truncates passphrases longer than 100 characters when passing them to RACF for validation. To use passphrases, ensure that the PowerExchange Listener runs with a security setting of SECURITY=(1,N) or higher in the DBMOVER member. For more information, see "SECURITY Statement" in the PowerExchange Reference Manual . To use passphrases for IMS connections, ensure that the following additional requirements are met: You must configure ODBA access to IMS as described in the PowerExchange Navigator User Guide . You must use IMS data maps that specify IMS ODBA as the access method. Do not use data maps that specify the DL/1 BATCH access method because this access method requires the use of netport jobs, which do not support passphrases. The IMS database must be online in the IMS control region to use ODBA access to IMS.
Compression	No	Controls whether to compress source data during the session.
Encryption Type	No	The encryption type. For information about encryption types, see Configuring Encryption and Compression. Default is None.
Encryption Level	No	The encryption level. For information about encryption levels, see Configuring Encryption and Compression. Default is 1.
Pacing Size	No	The pacing size. For information about setting the pacing size, see Configuring Pacing. Default is 0.
Interpret as Rows	No	Controls whether the pacing size is expressed in kilobytes or number of rows.
Offload Processing	No	Controls whether to use offload processing. Offload processes transfers PowerExchange bulk data processing from the source system to the PowerCenter Integration Service machine. Valid values: No . Disables offload processing. Auto . PowerExchange determines whether to use offload processing. Filter Before . Offloads processing to the PowerCenter Integration Service machine but continues to filter data on the source system. If you select Filter Before for an IMS unload file data source or a DB2 for z/OS image copy data source, PowerExchange changes the selection to Filter After . Filter After . Offloads the bulk data processing to the PowerCenter Integration Service machine, including the filtering of data. Default is No.
Worker Threads	No	The number of threads that PowerExchange uses on the PowerCenter Integration Service machine to process bulk data. For optimal performance, this value should not exceed the number of installed or available processors on the Integration Service machine. Valid values are from 1 through 64. Default is 0, which disables multithreading. If you use reader or writer pipeline partitioning, accept the default value of 0. You cannot use both multiple worker threads and partitioning. Not all PWX NRDB Batch connection types support worker threads. If the Worker Threads connection attribute for one of these connections is set to a nonzero value, processing continues without threads. Message PWX-31505 reports connection performance settings, including the number or worker threads. If worker threads are not used, message PWX-31505 reports a zero value for worker threads.
Array Size	No	For VSAM data sets and sequential files, the size of the storage array, in number of records, that is used for partitioned or multithreaded sessions. For partitioned sessions, this array size is shared across the partitions. For multithreaded sessions, each thread has this array size. For DB2 for z/OS image copies, determines the maximum memory buffer that might need to be allocated. If zIIP processing is enabled, Array Size also specifies how many compressed rows to dispatch to the zIIP processor. Valid values are from 1 through 5000. Default is 25. To tune partitioned sessions, particularly when the Write Mode attribute specifies Confirm Write On , increase the array size.
Write Mode	No	Controls whether data is sent to the PowerExchange Listener synchronously or asynchronously. For information about Write Mode options, see Configuring Write Mode. Default is Confirm Write On .
Convert character data to string	No	Controls whether character fields are converted to string fields so that embedded nulls in data are processed as spaces. By default, this attribute is not selected. For more information, see Converting Character Data to Strings.
Retrieve PWX Log Entries	No	Controls whether PWXPC writes PowerExchange informational messages related to the session in the PowerCenter session log. Default is to write PowerExchange error and warning messages but not informational messages to the session log.
PWX Override	No	PowerExchange connection overrides, separated by a semicolon. You can enter one or more of the following optional overrides: APPBUFSIZE=`app_buf_size.` Specifies the initial size of the application buffer for the connection. Overrides the APPBUFSIZE statement in the DBMOVER configuration file. CNV_ERROR_OK= { N \|Y}. If you use a NRDB batch connection to write data to a nonrelational target, set this parameter to Y to allow the workflow continue after a PWX-00143 message reports a DBAPI illegal null conversion error. This error occurs when the workflow tries to write null data to a target NOT NULL column. Set this parameter to N to have the workflow end abnormally when this type of error occurs. Default is N. CONNECTSTRINGCODEPAGE=`code_page`. Code page of the characters in the connection string. Enter this override if PowerExchange issues message PWX-07610. CSQ_MEMSIZE=`memory_size`. The memory size, in megabytes, for the cache that is used for multiple-record writes before it spills to disk. Default is 16. LOWVALUES={Y\| N }. Indicates whether PowerExchange preserves hexadecimal '0' values, called low values , in source character fields when passing these values to a PowerCenter session. Enter Y to preserve low values. When the session runs, PWXPC can write these values to a VSAM target on z/OS or to a sequential file target on Linux, UNIX, Windows, or z/OS. Overrides the LOWVALUES statement in the DBMOVER configuration file. PWXNOQUOTES={Y\| N }. By default, in the SQL SELECT statements that PWXPC uses to select data for session processing, PWXPC adds double-quotation marks (") around every table name and field name that includes spaces or special characters. These special characters are /+-=~`!%^&()[]{}';?,< >\\\| . If a table is identified by both a schema name and table name in the format schema* . table_name , PWXPC places the quotation marks only around the "table_name " value. If for any reason, you cannot use quoted table names or field names in your environment, set PWXNOQUOTES to Y to override the default behavior. RETLOGINFOMSG={ N \|Y}. By default, PWXPC writes PowerExchange error and warning messages but not informational messages to the session log. If you specify RETLOGINFOMSG=Y, PWXPC writes informational messages as well as error and warning messages to the session log. The RETLOGINFOMSG connection override is equivalent to the Retrieve PWX Log Entries connection attribute. TCPIP_OP_TIMEOUT=`network_operation_timeout`. A network operation timeout interval in seconds. For more information about this timeout override, see Asynchronous Network Communication. TCPIP_CON_TIMEOUT=`connection_timeout`. A connection timeout interval in seconds. For more information about this timeout override, see Asynchronous Network Communication. WRT_ERROR_HANDLING=Y. If you use writer partitioning and set the Write Mode attribute to Confirm Write On , specify WRT_ERROR_HANDLING=Y to use an alternative method of error handling that is more efficient than the default method when the input data contains many errors. You can also specify this statement in the DBMOVER configuration file.
Connection Retry Period	No	The number of seconds the PowerCenter Integration Service attempts to reconnect to the PowerExchange Listener after the initial connection attempt fails. If the Integration Service cannot connect to the PowerExchange Listener within the retry period, the session fails. Default value is 0, which disables connection retries based on this PWXPC connection attribute PowerExchange Listener connections to source databases do not have connection resilience.