Table of Contents

Search

  1. Preface
  2. Introduction to TDM Administration
  3. User and Role Administration
  4. Security Administration
  5. System Preferences
  6. TDM Server Administration
  7. Connections
  8. Pass Phrases
  9. Global Parameters
  10. Dictionaries
  11. User-Defined Datatypes

Administrator Guide

Administrator Guide

PowerExchange NRDB Batch Connections

PowerExchange NRDB Batch Connections

You can create a PowerExchange NRDB Batch connection in Test Data Manager to perform data subset and data masking operations.
The following table describes the database connection properties for a PowerExchange NRDB Batch database:
Property
Description
Name
Required. Name of the connection. The name is not case sensitive and must be unique within the domain. It cannot exceed 128 characters, start with a number, contain spaces, or contain the following special characters:
~ ` ! $ % ^ & * ( ) - + = { [ } ] | \ : ; " ' < , > . ? /
Connection Type
Required. The connection type. Select PWX NRDB Batch.
Description
The description of the connection. The description cannot exceed 255 characters.
User Name
Required. The database user name.
Password
Required. The password for the database user name.
Owner
The owner of the connection. Default is the user who creates the connection. You can change the owner of the connection.
Code Page
The code page that the 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.
Array Size
Storage array size, in number of records, that is used for partitioned or multithreaded sessions. For partitioned sessions, this array size is shared across the partitions. Valid values are from 1 through 100000.
Default is 25.
To tune partitioned sessions, particularly when the Write Mode attribute specifies Confirm Write On, increase the array size.
Write Mode
Mode in which the Integration Service sends data to the PowerExchange Listener. Configure one of the following write modes:
  • Confirm Write On. Sends data to the PowerExchange Listener and waits for a response before sending more data. Select if error recovery is a priority. This option might decrease performance.
  • Confirm Write Off. Sends data to the PowerExchange Listener without waiting for a response. Use this option when you can reload the target table if an error occurs.
  • Asynchronous With Fault Tolerance. Sends data to the PowerExchange Listener without waiting for a response. This option also provides the ability to detect errors. This provides the speed of Confirm Write Off with the data integrity of Confirm Write On.
Default is Confirm Write On.
Off Load Processing
Controls whether to use offload processing. Offload processing transfers PowerExchange bulk data processing from the source system to the Integration Service machine. Select one of the following values:
  • No. Do not use offload processing.
  • Auto. PowerExchange determines whether to use offload processing.
  • Filter After. Offloads the bulk data processing to the PowerCenter Integration Service machine, including the filtering of data.
  • 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, PowerExchange changes the selection to Filter After.
Default is No.
Worker Threads
The number of threads that PowerExchange uses on the 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.
Connection Retry Period
Number of seconds the Integration Service attempts to reconnect to the data source or target if the connection fails. If the Integration Service cannot connect to the database in the retry period, the operation fails.
Default is 0.
Compression
Select to compress source data during the PowerCenter session.
Default is disabled.
Encryption Type
The type of encryption that the Integration Service uses. Select one of the following values:
  • None.
  • RC2.
  • DES.
Default is None.
Encryption Level
The level of encryption that the Integration Service uses. If you select RC2 or DES for Encryption Type, select one of the following values to indicate the encryption level.
  • 1. Uses a 56-bit encryption key for DES and RC2.
  • 2. Uses a 168-bit triple encryption key for DES. Uses a 64-bit encryption key for RC2.
  • 3. Uses a 168-bit triple encryption key for DES. Uses a 128-bit encryption key for RC2.
Ignored if you do not select an encryption type.
Default is 1.
Interpret As Rows
Interprets the pacing size as rows or kilobytes. Select to represent the pacing size in number of rows. If you clear this option, the pacing size represents kilobytes.
Default is disabled.
Convert Character Data As String
Convert character fields to string fields so that embedded nulls in data are processed as spaces.
Default is disabled.
PWX Override
PowerExchange connection override values, separated by semicolons. You can enter any of the following overrides:
TCPIP_OP_TIMEOUT=network_operation_timeout; TCPIP_CON_TIMEOUT=connection_timeout; WRT_ERROR_HANDLING=Y
If you use write partitioning and set the Write Mode attribute to Confirm Write On, you can specify
WRT_ERROR_HANDLIN=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.cfg configuration file.
Pacing Size
Amount of data that the source system can pass to the PowerExchange Listener. Configure the pacing size if an external application, database, or the Integration Service node is a bottleneck. The lower the value, the faster the performance. Enter 0 for maximum performance.
Default is 0.
Location
Required. Location of the PowerExchange Listener node. The location is defined in the first parameter of the NODE statement in the PowerExchange dbmover.cfg configuration file.
Get PowerExchange Log Entries
Specifies whether PWXPC writes PowerExchange messages related to a CDC session in the PowerCenter session log.
Default is disabled.

0 COMMENTS

We’d like to hear from you!