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

DB2 for Linux, UNIX and Windows Connections

DB2 for Linux, UNIX and Windows Connections

You can create a DB2 for Linux, UNIX and Windows connection in Test Data Manager to perform data discovery, data subset, and data masking operations. Use this connection to create a connection to a DB2 for zOS database to import source metadata directly into Test Data Manager.
The following table describes the database connection properties for a DB2 for Linux, UNIX and Windows 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 DB2 for Linux, UNIX and Windows.
Description
The description of the connection. The description cannot exceed 255 characters.
Use Kerberos Authentication
Enables Kerberos Authentication. You cannot enter a user name and password if you select this check box.
User Name
Required. The database user name.
Use Parameter in Password
Indicates the password for the database user name is a session parameter. $Param
Name
. Define the password in the workflow or session parameter file, and encrypt it using the
pmpasswd
CRYPT_DATA option.
Used for data subset and data masking operations. Default is disabled.
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.
Metadata Connection String
Required. The JDBC connection URL used to access metadata from the database. Enter jdbc:informatica:db2://<hostname>:50000;databaseName=<dbname>.
Used for all operations.
JDBC Login Password
Required if Use Parameter in Password is selected. The password for the JDBC user.
Used for import from source and data discovery operations.
Driver Name
Indicates the JDBC driver name to interact with the database.
Default values for the database:
  • DB2 for Linux, UNIX, and Windows:
    com.informatica.jdbc.db2.DB2Driver
  • DB2 for zOS:
    com.ibm.db2.jcc.DB2Driver
Data Access Connection String
The connection string used to access data from the database. Enter <database name>.
Used for all operations.
Code Page
Code page the Integration Service uses to read from a source database or write to a target database or file.
Used for all operations.
Connection Environment Type
Default is
Native
.
For DB2 for zOs databases, choose
zOS
.
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.
Used for all operations.
Transaction SQL
SQL commands to set the database environment when you connect to the database. The
PowerCenter Integration Service
runs the transaction environment SQL at the beginning of each transaction.
Used for all operations.
Connection Retry Period
Number of seconds the Integration Service attempts to reconnect to the database if the connection fails. If the Integration Service cannot connect to the database in the retry period, the operation fails.
Used for all operations. Default is 0.
Tablespace
The tablespace name of the database.
Used for all operations.
Pass Through Security Enabled
Enables pass-through security for the connection. When you enable pass-through security for a connection, the domain uses the client user name and password to log into the corresponding database, instead of the credentials defined in the connection object.
Used for data discovery operations. Default is disabled.

0 COMMENTS

We’d like to hear from you!