PowerExchange Interfaces for PowerCenter

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

Back Next

NRDB CDC Application Connections

Configure NRDB CDC application connections to extract change data from nonrelational sources in real-time extraction mode or from PowerExchange Condense condense files in batch extraction mode.

The following table describes the connection attributes for the PWX NRDB CDC Change and CDC Real Time application connection types:

Connection Attribute	Required?	Change or Real Time	Description
Name	Yes	Both	A name for the application connection.
Code Page	Yes	Both	The code page that the PowerCenter Integration Service uses 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	Both	The location of the source or target database, as specified in a NODE statement in the DBMOVER configuration file.
User Name	Yes	Both	A user name for connecting to the database. For connections to supported Linux, UNIX, or Windows platforms, 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	Both	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. A PowerExchange passphrase for z/OS access can be from 9 to 128 characters in length when you use 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. The allowable characters in the IBM IRRPHREX exit do not affect the allowable characters in PowerExchange passphrases. 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	Both	Controls whether to compress source data during the PowerCenter session.
Encryption Type	Yes	Both	The encryption type. For information about supported encryption types, see Configuring Encryption and Compression. Default is None.
Encryption Level	No	Both	The encryption level. For information about supported encryption levels, see Configuring Encryption and Compression. Default is 1.
Pacing Size	Yes	Both	The pacing size.
Interpret as Rows	No	Both	Indicates whether the pacing size is in number of rows.
Image Type	No	Both	Indicates how PWXPC passes captured Updates to CDC sessions: as Updates, or as Deletes followed by Inserts. Default is BA, which processes Updates as Deletes followed by Inserts. For more information, see Configuring Image Type.
Application Name	No	Both	The application name.
RestartToken File Folder	Yes	Both	The name of folder that contains the restart token folder. Default is $PMRootDir/Restart.
RestartToken File Name	No	Both	The name of the restart token file.
Number of Runs to Keep RestartToken File	No	Both	The maximum number of backup copies to keep of the restart token file. Default is 0.
Recovery Cache Folder	No	Both	The name of the file cache folder that is used for recovery of the session. Default is $PMRootDir/Cache.
UOW Count	No	Both	The number of units of work (UOWs) that PWXPC processes before it sends a commit request to PowerCenter to commit data to all targets in the CDC session. Valid values: -1 . Disables this attribute. 0 . Disables this attribute. n . Specifies the number of UOWs that PWXPC processes before sending a commit request. Default is 1. For more information, see Configuring UOW Count.
Reader Time Limit	No	Real Time	The number of seconds that PowerCenter Integration Service reads data from the source before stopping. Default is 0, which indicates that the reader time is not limited. This value is intended for testing purposes only. Use Idle Time instead.
Idle Time	No	Real Time	The number of seconds the PowerExchange Listener remains idle after reaching the end of the change log, as indicated by message PWX-09967, before returning an end-of-file (EOF). Valid values: -1 . The EOF is never returned. The session runs continuously. 0 . The EOF is returned at the end of log. Then the session terminates successfully. n . The number of seconds that the PowerExchange Listener remains idle before returning an EOF. Default is -1. For more information, see Configuring Idle Time.
Real-Time Flush Latency in milli-seconds	No	Real Time	The number of milliseconds that must elapse before PWXPC sends a commit request to PowerCenter. When this period elapses, PWXPC continues to read the changes in the current UOW until it reaches the end of the UOW. Then PWXPC sends a commit request to PowerCenter so that the data can be committed to the targets. Valid values: -1 . Disables this attribute. 0 to 86400 . Specifies the number of milliseconds that must elapse before PWXPC sends a commit request to PowerCenter. If you specify a value from 0 through 2000, PWXPC uses 2000 milliseconds (2 seconds). Default is 0. For more information, see Configuring PWX Latency and Real-Time Flush Latency.
PWX Latency in seconds	No	Real Time	The maximum time, in seconds, that PowerExchange on the source platform waits for more change data before it flushes to PWXPC on the PowerCenter Integration Service platform. Default is 2.
Maximum Rows Per commit	No	Both	The maximum number of change records that PWXPC processes before it sends a commit request to PowerCenter to commit data to all targets in the CDC session. PWXPC does not wait for a UOW boundary to commit the change data. Default is 0, which disables this attribute. For more information, see Configuring Maximum Rows per Commit.
Minimum Rows Per commit	No	Real Time	The minimum number of change records that the PowerExchange Listener must read from the change stream before it passes a commit record to PWXPC. Before reaching this minimum, the PowerExchange Listener passes only change records to PWXPC and discards any commit records. Default is 0, which disables this attribute. For more information, see Configuring Minimum Rows per Commit.
Convert character data to string	No	Both	Controls whether to convert character fields to string fields so that embedded nulls in data are processed as spaces. By default, this attribute is not selected.
Event Table	No	Real Time	The PowerExchange extraction map name that is used for event processing. For more information, see Configuring Event Table Processing.
Offload Processing	No	Real Time	Controls whether to use CDC offload processing to move PowerExchange processing for the change data from the source system to the PowerCenter Integration Service machine. Valid values: No Yes Auto . PowerExchange determines whether to use offload processing. Default is No.
Worker Threads	No	Real Time	If you enable CDC offload processing, the number of threads that PowerExchange uses on the PowerCenter Integration Service machine to process change data. For optimal performance, the value should not exceed the number of installed or available processors on the PowerCenter Integration Service machine. Valid values are from 1 through 64. Default is 0.
Array Size	No	Real Time	If the Worker Threads value is greater than 0, the size of the storage array, in number of records, for the threads. Valid values are from 1 through 5000. Default is 25.
Map Location	No	Real Time	If you enable offload processing, the location of the source extraction maps. This value must be the name of a location in a NODE statement in the DBMOVER configuration file on the PowerCenter Integration Service machine.
Map Location User	No	Real Time	If you specified Map Location , a valid user ID for the user of that location.
Map Location Password	No	Real Time	If you specify Map Location User , a valid password for that user ID.
CAPI Connection Name Override	No	Real Time	A name that overrides the default CAPI connection name.
Retrieve PWX Log Entries	No	Both	Controls whether PWXPC writes PowerExchange informational messages related to a CDC 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	Both	PowerExchange connection override values, separated by a semicolon. You can enter one or more of the following 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. CONNECTSTRINGCODEPAGE=`code_page`. Code page of the characters in the connection string. Enter this override if PowerExchange issues message PWX-07610. 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.
Connection Retry Period	No	Both	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.