Communities
A collaborative platform to connect and grow with like-minded Informaticans across the globe
Product Communities
Connect and collaborate with Informatica experts and champions
Discussions
Have a question? Start a Discussion and get immediate answers you are looking for
User Groups
Customer-organized groups that meet online and in-person. Join today to network, share ideas, and get tips on how to get the most out of Informatica
Get Started
Community Guidelines
Knowledge Center
Troubleshooting documents, product guides, how to videos, best practices, and more
Knowledge Base
One-stop self-service portal for solutions, FAQs, Whitepapers, How Tos, Videos, and more
Support TV
Video channel for step-by-step instructions to use our products, best practices, troubleshooting tips, and much more
Documentation
Information library of the latest product documents
Velocity (Best Practices)
Best practices and use cases from the Implementation team
Learn
Rich resources to help you leverage full capabilities of our products
Trainings
Role-based training programs for the best ROI
Certifications
Get certified on Informatica products. Free, Foundation, or Professional
Product Learning Paths
Free and unlimited modules based on your expertise level and journey
Resources
Library of content to help you leverage the best of Informatica products
Tech Tuesdays Webinars
Most popular webinars on product architecture, best practices, and more
Product Availability Matrix
Product Availability Matrix statements of Informatica products
SupportFlash
Monthly support newsletter
Support Documents
Informatica Support Guide and Statements, Quick Start Guides, and Cloud Product Description Schedule
Product Lifecycle
End of Life statements of Informatica products
Ideas
Events
Change Request Tracking
Marketplace
English
  • Informatica Data Quality 10.5.7
  • All Products

Table of Contents

Search

  1. Preface
  2. Understanding Domains
  3. Managing Your Account
  4. Using Informatica Administrator
  5. Using the Domain View
  6. Domain Management
  7. Nodes
  8. High Availability
  9. Connections
  10. Connection Properties
  11. Schedules
  12. Domain Object Export and Import
  13. License Management
  14. Monitoring
  15. Log Management
  16. Domain Reports
  17. Node Diagnostics
  18. Understanding Globalization
  19. Managing Distribution Packages
  20. Appendix A: Code Pages
  21. Appendix B: Custom Roles
  22. Appendix C: Informatica Platform Connectivity
  23. Appendix D: Configure the Web Browser

Administrator Guide

Administrator Guide

Back Next

IBM DB2 for i5/OS Connection Properties

IBM DB2 for i5/OS Connection Properties

Use an IBM
DB2 for i5/OS
 connection to access tables in IBM
DB2 for i5/OS
. An IBM DB2 for i5/OS connection is a relational database connection. You can create and manage an IBM DB2 for i5/OS connection in the Administrator tool or the Developer tool.
The order of the connection properties might vary depending on the tool where you view them.
The following table describes DB2 for i5/OS connection properties:
Property
Description
Name
Name of the connection. The name is not case sensitive and must be unique within the domain. The name cannot exceed 128 characters, contain spaces, or contain the following special characters:
~ ` ! $ % ^ & * ( ) - + = { [ } ] | \ : ; " ' < , > . ? /
ID
String that the Data Integration Service uses to identify the connection. The ID is not case sensitive. It must be 255 characters or less and must be unique in the domain. You cannot change this property after you create the connection. Default value is the connection name.
Description
The description of the connection. The description cannot exceed 255 characters.
Connection Type
The connection type (DB2I).
Username
A database user name.
Password
A password for the specified user name or a valid PowerExchange passphrase.
A PowerExchange passphrase can be from 9 to 31 characters in length and 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.
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
.
Pass-through security enabled
Enables pass-through security for the connection.
Database name
The database instance name.
Location
Node name for the location of the PowerExchange Listener that connects to DB2. The node name is defined in the first parameter of the NODE statement in the PowerExchange dbmover.cfg configuration file.
Environment SQL
SQL commands to set the database environment when you connect to the database. The Data Integration Service executes the connection environment SQL each time it connects to the database.
Database file overrides
Specifies the i5/OS database file override in the following format: 
from_file/to_library/to_file/to_member
Where:
  • from_file
     is the file to be overridden.
  • to_library
    is the new library to use.
  • to_file
     is the file in the new library to use.
  • to_member
     is optional and is the member in the new library and file to use. *FIRST is used if nothing is specified.
You can specify up to eight unique file overrides on a single connection. A single override applies to a single source or target. When you specify more than one file override, enclose the string of file overrides in double quotes (") and include a space between each file override.
If you specify both
Library List
 and
Database File Overrides
 and a table exists in both, the
Database File Overrides
 value takes precedence.
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.
Separate libraries with commas.
If you specify both
Library List
 and
Database File Overrides
 and a table exists in both, the
Database File Overrides
 value takes precedence.
Code Page
The code page used to read from a source database or write to a target database or file.
SQL Identifier character to use
Type of character that the database uses to enclose delimited identifiers in SQL queries. The available characters depend on the database type.
Select (None) if the database uses regular identifiers. When the Data Integration Service generates SQL queries, the service does not place delimited characters around any identifiers.
Select a character if the database uses delimited identifiers. When the Data Integration Service generates SQL queries, the service encloses delimited identifiers within this character.
Support mixed case identifiers
Enable if the database uses case-sensitive identifiers. When enabled, the Data Integration Service encloses all identifiers within the character selected for the
SQL Identifier Character
 property.
When the
SQL Identifier Character
 property is set to none, the
Support Mixed-case Identifiers
 property is disabled.
Isolation level
Commit scope of the transaction. Select one of the following options:
  • None
  • CS
    . Cursor stability.
  • RR
    . Repeatable Read.
  • CHG
    . Change.
  • ALL
Default is CS.
Encryption type
Optional. The type of encryption that the Data Integration Service uses. Select one of the following options:
  • None
  • AES
Default is None.
Informatica recommends that you use Secure Sockets Layer (SSL) authentication instead of configuring the
Encryption type
 and
Encryption level
 connection properties. SSL authentication provides stricter security and is used by several Informatica products.
For more information about implementing SSL authentication in a PowerExchange network, see the
PowerExchange Reference Manual
.
Encryption level
If you select
AES
 for
Encryption Type
, select one of the following options to indicate the encryption level that the Data Integration Service uses:
  • 1
    . Use a128-bit encryption key.
  • 2
    . Use a 192-bit encryption key.
  • 3
    . Use a 256-bit encryption key.
If you do not select
AES
 for
Encryption Type
, this option is ignored.
Default is 1.
Pacing size
Optional. Amount of data that the source system can pass to the PowerExchange Listener. Set the pacing size if an external application, database, or the Data Integration Service node is a bottleneck. User lower values for faster performance.
The minimum value and default value is 0. A value of
0
 provides the best performance.
Interpret as rows
Optional. Select this option to express the pacing size as a number of rows. Clear this option to express the pacing size in kilobytes. By default, this option is not selected and the pacing size is in kilobytes.
Compression
Optional. Select this option to enable source data compression. By compressing data, you can decrease the amount of data that Informatica applications send over the network. By default, this option is not selected and compression is disabled.
Array size
Optional. The number of records in the storage array for the worker threads. This option is applicable when you set the
Worker Threads
 option to a value greater than 0. Valid values are 25 to 5000. Default is 25.
Write mode
Optional. Mode in which the Data Integration Service sends data to the PowerExchange Listener. Select one of the following write modes:
  • CONFIRMWRITEON
    . Sends data to the PowerExchange Listener and waits for a response before sending more data. Select this option when error recovery is a priority. However, this option might degrade performance.
  • CONFIRMWRITEOFF
    . Sends data to the PowerExchange Listener without waiting for a response. Use this option if you can reload the target table when an error occurs.
  • ASYNCHRONOUSWITHFAULTTOLERANCE
    . Sends data to the PowerExchange Listener without waiting for a response. This option also enables error detection. This option combines the speed of CONFIRMWRITEOFF and the data integrity of CONFIRMWRITEON.
Default is
CONFIRMWRITEON
.
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 ASYNCHRONOUSWITHFAULTTOLERANCE. Enter PWXDISABLE to prevent the creation of the reject files.
0 COMMENTS
We’d like to hear from you!