Test Data Management
- Test Data Management 10.5.3
- All Products
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 DB2 for i5/OS.
|
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.
|
Library List
| List of libraries that PowerExchange searches to qualify the table name for Select, Insert, Delete, or Update statements. PowerExchange searches the list if the table name is unqualified. If you specify multiple libraries, separate the library names with spaces and enclose the list in quotation marks (for example, "TGTLIB1 TGTLIB2 TGTLIB3").
If you specify Library List and Database File Overrides and a table exists in both, Database Files Overrides takes precedence.
|
Isolation Level
| Commit scope of the transaction. Select one of the following values:
|
Array Size
| Db2 fetch array size, in number of rows, for DB2 bulk data movement operations that use the DB2 access method. The array size pertains to the DB2 multiple-row FETCH statements that PowerExchange uses to read data from the DB2 source tables. Valid values are from 1 through 100000.
Default is 25. Informatica recommends that you enter an array size no greater than 100.
|
Environment SQL
| SQL commands to set the database environment when you connect to the database. The PowerCenter Integration Service runs the connection environment SQL each time it connects to the database.
|
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.
|
Database Name
| DB2 subsystem or database instance name.
|
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:
|
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.
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.
|
Write Mode
| Mode in which the Integration Service sends data to the PowerExchange Listener. Configure one of the following write modes:
|
Reject File
| Overrides the default prefix of PWXR for the reject file. PowerExchange creates the reject file on the target machine when the write mode is asynchronous with fault tolerance. To prevent the creation of the reject files, specify PWXDISABLE.
|
PWX Override
| Specifies PowerExchange connection override values, separated by semicolons, including the following overrides:
|
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
| 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.
|
Database file overrides
| Specifies the i5/OS database file override. The format is:
Where:
If both Library List and Database file overrides are specified and a table exists in both, the Database file overrides takes precedence.
|