Configuring DB2 Connect Adapter Environment Properties

Description 

Enter a description for the database. 

A valid string. The default is DB2 Connect DriverManager.

DatabaseName 

Specifies the name of the database instance used on the Server. 

Any valid string. 

User 

Specifies the user name that the Adapter uses to connect to the database. 

Any valid string. 

Password 

Specifies the password used to access the database. 

Any valid string. 

Description 

Enter a description for the database. 

A valid string. The default value is DB2 Connect Connection Pool Datasource.

DatabaseName 

Specifies the name of the database instance used on the Server. 

Any valid string. 

User 

Specifies the user name that the Adapter uses to connect to the database. 

Any valid string. 

Password 

Specifies the password used to access the database. 

Any valid string. 

DriverProperties 

Use the JDBC driver that is shipped with this Adapter. Often times the DataSource implementation needs to execute additional methods to assure a connection. You must identify the additional methods in the Driver Properties. 

Any valid delimiter. 

Valid delimiters are: “<method-name-1>#<param-1>#<param-2>##.........<param-n>##<method-name-2>#<param-1>#<param-2>#........<param-n>##......##”. 

For example: To obtain a DB2 Connect trace, give the method a string for the email “settraceLevel#-1##settraceFile#c:/temp/db2trace.txt##” 

Delimiter 

This is the delimiter character to be used in the DriverProperties prompt. 

The default is #. 

MinPoolSize 

The minimum number of physical connections the pool keeps available at all times. 0 (zero) indicates that there are no physical connections in the pool and new connections are created as needed. 

A valid numeric value. The default is 0. 

MaxPoolSize 

The maximum number of physical connections the pool keeps available at all times. 0 (zero) indicates that there is no maximum. 

A valid numeric value. The default is 10. 

MaxIdleTime 

The maximum number of seconds that a physical connection may remain unused before it is closed. 0 (zero) indicates that there is no limit. 

A valid numeric value. The default is 0. 

ConnectionRetries 

Specifies the number of retries to establish a connection with the DB2 Connect database upon a failure to acquire one. 

an integer indicating the number of attempts allowed to establish a connection. The configured default is 0.

ConnectionRetry Interval 

Specifies the milliseconds of pause before each attempt to access the database. This setting is used in conjunction with the Connection Retries setting. 

For example: In the event that the Adapter cannot connect to the Database, the Adapter will try to reconnect to the database 10 times in 5 seconds intervals when the Connection Retries is 10 and the Connection Retry Interval is 5000. 

An integer indicating the configured length of the time (in milliseconds) before each reattempt to access the destination file. The configured default is 1000 (1 second).

Description 

Enter a description for the database. 

A valid string. The default value is DB2 Connect non-Transactional Connection Pool Datasource.

DatabaseName 

Specifies the name of the database instance used on the Server. 

Any valid string. 

User 

Specifies the user name that the Adapter uses to connect to the database. 

Any valid string. 

Password 

Specifies the password used to access the database. 

Any valid string. 

DriverProperties 

Use the JDBC driver that is shipped with this Adapter. Often times the DataSource implementation needs to execute additional methods to assure a connection. You must identify the additional methods in the Driver Properties. 

Any valid delimiter. 

Valid delimiters are: “<method-name-1>#<param-1>#<param-2>##.........<param-n>##<method-name-2>#<param-1>#<param-2>#........<param-n>##......##”. 

For example: To obtain a DB2 Connect trace, give the method a string for the email “settraceLevel#-1##settraceFile#c:/temp/db2trace.txt##” 

Delimiter 

This is the delimiter character to be used in the DriverProperties prompt. 

The default is #. 

MinPoolSize 

The minimum number of physical connections the pool keeps available at all times. 0 (zero) indicates that there are no physical connections in the pool and new connections are created as needed. 

A valid numeric value. The default is 0. 

MaxPoolSize 

The maximum number of physical connections the pool keeps available at all times. 0 (zero) indicates that there is no maximum. 

A valid numeric value. The default is 10. 

MaxIdleTime 

The maximum number of seconds that a physical connection may remain unused before it is closed. 0 (zero) indicates that there is no limit. 

A valid numeric value. The default is 0. 

ConnectionRetries 

Specifies the number of retries to establish a connection with the DB2 Connect database upon a failure to acquire one. 

an integer indicating the number of attempts allowed to establish a connection. The configured default is 0.

ConnectionRetry Interval 

Specifies the milliseconds of pause before each attempt to access the database. This setting is used in conjunction with the Connection Retries setting. 

For example: In the event that the Adapter cannot connect to the Database, the Adapter will try to reconnect to the database 10 times in 5 seconds intervals when the Connection Retries is 10 and the Connection Retry Interval is 5000. 

An integer indicating the configured length of the time (in milliseconds) before each reattempt to access the destination file. The configured default is 1000 (1 second).

Description 

Enter a description for the database. 

A valid string. The default value is DB2 Connect XA Datasource.

DatabaseName 

Specifies the name of the database instance used on the Server. 

Any valid string. 

User 

Specifies the user name that the Adapter uses to connect to the database. 

Any valid string. 

Password 

Specifies the password used to access the database. 

Any valid string. 

DriverProperties 

Use the JDBC driver that is shipped with this Adapter. Often times the DataSource implementation needs to execute additional methods to assure a connection. You must identify the additional methods in the Driver Properties. 

Any valid delimiter. 

Valid delimiters are: “<method-name-1>#<param-1>#<param-2>##.........<param-n>##<method-name-2>#<param-1>#<param-2>#........<param-n>##......##”. 

For example: To obtain a DB2 Connect trace, give the method a string for the email “settraceLevel#-1##settraceFile#c:/temp/db2trace.txt##” 

Delimiter 

This is the delimiter character to be used in the DriverProperties prompt. 

The default is #. 

MinPoolSize 

The minimum number of physical connections the pool keeps available at all times. 0 (zero) indicates that there are no physical connections in the pool and new connections are created as needed. 

A valid numeric value. The default is 0. 

MaxPoolSize 

The maximum number of physical connections the pool keeps available at all times. 0 (zero) indicates that there is no maximum. 

A valid numeric value. The default is 10. 

MaxIdleTime 

The maximum number of seconds that a physical connection may remain unused before it is closed. 0 (zero) indicates that there is no limit. 

A valid numeric value. The default is 0. 

ConnectionRetries 

Specifies the number of retries to establish a connection with the DB2 Connect database upon a failure to acquire one. 

an integer indicating the number of attempts allowed to establish a connection. The configured default is 0.

ConnectionRetry Interval 

Specifies the milliseconds of pause before each attempt to access the database. This setting is used in conjunction with the Connection Retries setting. 

For example: In the event that the Adapter cannot connect to the Database, the Adapter will try to reconnect to the database 10 times in 5 seconds intervals when the Connection Retries is 10 and the Connection Retry Interval is 5000. 

An integer indicating the configured length of the time (in milliseconds) before each reattempt to access the destination file. The configured default is 1000 (1 second).

Description 

Enter a description for the database. 

A valid string. The default is DB2 Connect DriverManager.

ServerName 

Specifies the host name of the external database server. 

Any valid string. 

PortNumber 

Specifies the I/O port number on which the server is listening for connection requests. 

A valid port number. The default is 446. 

DatabaseName 

Specifies the name of the database instance used on the Server. 

Any valid string. 

User 

Specifies the user name that the Adapter uses to connect to the database. 

Any valid string. 

Password 

Specifies the password used to access the database. 

Any valid string. 

Description 

Enter a description for the database. 

A valid string. The default value is DB2 Connect Type 4 Connection Pool Datasource.

ServerName 

Specifies the host name of the external database server. 

Any valid string. 

PortNumber 

Specifies the I/O port number on which the server is listening for connection requests. 

A valid port number. The default is 446.

DatabaseName 

Specifies the name of the database instance used on the Server. 

Any valid string. 

User 

Specifies the user name that the Adapter uses to connect to the database. 

Any valid string. 

Password 

Specifies the password used to access the database. 

Any valid string. 

DriverProperties 

Use the JDBC driver that is shipped with this Adapter. Often times the DataSource implementation needs to execute additional methods to assure a connection. You must identify the additional methods in the Driver Properties. 

Any valid delimiter. 

Valid delimiters are: “<method-name-1>#<param-1>#<param-2>##.........<param-n>##<method-name-2>#<param-1>#<param-2>#........<param-n>##......##”. 

For example: To obtain a DB2 Connect trace, give the method a string for the email “settraceLevel#-1##settraceFile#c:/temp/db2trace.txt##” 

Delimiter 

This is the delimiter character to be used in the DriverProperties prompt. 

The default is #. 

MinPoolSize 

The minimum number of physical connections the pool keeps available at all times. 0 (zero) indicates that there are no physical connections in the pool and new connections are created as needed. 

A valid numeric value. The default is 0. 

MaxPoolSize 

The maximum number of physical connections the pool keeps available at all times. 0 (zero) indicates that there is no maximum. 

A valid numeric value. The default is 10. 

MaxIdleTime 

The maximum number of seconds that a physical connection may remain unused before it is closed. 0 (zero) indicates that there is no limit. 

A valid numeric value. The default is 0. 

ConnectionRetries 

Specifies the number of retries to establish a connection with the DB2 Connect database upon a failure to acquire one. 

an integer indicating the number of attempts allowed to establish a connection. The configured default is 0.

ConnectionRetry Interval 

Specifies the milliseconds of pause before each attempt to access the database. This setting is used in conjunction with the Connection Retries setting. 

For example: In the event that the Adapter cannot connect to the Database, the Adapter will try to reconnect to the database 10 times in 5 seconds intervals when the Connection Retries is 10 and the Connection Retry Interval is 5000. 

An integer indicating the configured length of the time (in milliseconds) before each reattempt to access the destination file. The configured default is 1000 (1 second).

Description 

Enter a description for the database. 

A valid string. The default value is DB2 Connect Type 4 Connection Pool Datasource.

ServerName 

Specifies the host name of the external database server. 

Any valid string. 

PortNumber 

Specifies the I/O port number on which the server is listening for connection requests. 

A valid port number. The default is 446.

DatabaseName 

Specifies the name of the database instance used on the Server. 

Any valid string. 

User 

Specifies the user name that the Adapter uses to connect to the database. 

Any valid string. 

Password 

Specifies the password used to access the database. 

Any valid string. 

DriverProperties 

Use the JDBC driver that is shipped with this Adapter. Often times the DataSource implementation needs to execute additional methods to assure a connection. You must identify the additional methods in the Driver Properties. 

Any valid delimiter. 

Valid delimiters are: “<method-name-1>#<param-1>#<param-2>##.........<param-n>##<method-name-2>#<param-1>#<param-2>#........<param-n>##......##”. 

For example: To obtain a DB2 Connect trace, give the method a string for the email “settraceLevel#-1##settraceFile#c:/temp/db2trace.txt##” 

Delimiter 

This is the delimiter character to be used in the DriverProperties prompt. 

The default is #. 

MinPoolSize 

The minimum number of physical connections the pool keeps available at all times. 0 (zero) indicates that there are no physical connections in the pool and new connections are created as needed. 

A valid numeric value. The default is 0. 

MaxPoolSize 

The maximum number of physical connections the pool keeps available at all times. 0 (zero) indicates that there is no maximum. 

A valid numeric value. The default is 10. 

MaxIdleTime 

The maximum number of seconds that a physical connection may remain unused before it is closed. 0 (zero) indicates that there is no limit. 

A valid numeric value. The default is 0. 

ConnectionRetries 

Specifies the number of retries to establish a connection with the DB2 Connect database upon a failure to acquire one. 

an integer indicating the number of attempts allowed to establish a connection. The configured default is 0.

ConnectionRetry Interval 

Specifies the milliseconds of pause before each attempt to access the database. This setting is used in conjunction with the Connection Retries setting. 

For example: In the event that the Adapter cannot connect to the Database, the Adapter will try to reconnect to the database 10 times in 5 seconds intervals when the Connection Retries is 10 and the Connection Retry Interval is 5000. 

An integer indicating the configured length of the time (in milliseconds) before each reattempt to access the destination file. The configured default is 1000 (1 second).

Description 

Enter a description for the database. 

A valid string. The default value is DB2 Connect Type 4 XA Datasource.

ServerName 

Specifies the host name of the external database server. 

Any valid string. 

PortNumber 

Specifies the I/O port number on which the server is listening for connection requests. 

A valid port number. The default is 446.

DatabaseName 

Specifies the name of the database instance used on the Server. 

Any valid string. 

User 

Specifies the user name that the Adapter uses to connect to the database. 

Any valid string. 

Password 

Specifies the password used to access the database. 

Any valid string. 

DriverProperties 

Use the JDBC driver that is shipped with this Adapter. Often times the DataSource implementation needs to execute additional methods to assure a connection. You must identify the additional methods in the Driver Properties. 

Any valid delimiter. 

Valid delimiters are: “<method-name-1>#<param-1>#<param-2>##.........<param-n>##<method-name-2>#<param-1>#<param-2>#........<param-n>##......##”. 

For example: To obtain a DB2 Connect trace, give the method a string for the email “settraceLevel#-1##settraceFile#c:/temp/db2trace.txt##” 

Delimiter 

This is the delimiter character to be used in the DriverProperties prompt. 

The default is #. 

MinPoolSize 

The minimum number of physical connections the pool keeps available at all times. 0 (zero) indicates that there are no physical connections in the pool and new connections are created as needed. 

A valid numeric value. The default is 0. 

MaxPoolSize 

The maximum number of physical connections the pool keeps available at all times. 0 (zero) indicates that there is no maximum. 

A valid numeric value. The default is 10. 

MaxIdleTime 

The maximum number of seconds that a physical connection may remain unused before it is closed. 0 (zero) indicates that there is no limit. 

A valid numeric value. The default is 0. 

ConnectionRetries 

Specifies the number of retries to establish a connection with the DB2 Connect database upon a failure to acquire one. 

an integer indicating the number of attempts allowed to establish a connection. The configured default is 0.

ConnectionRetry Interval 

Specifies the milliseconds of pause before each attempt to access the database. This setting is used in conjunction with the Connection Retries setting. 

For example: In the event that the Adapter cannot connect to the Database, the Adapter will try to reconnect to the database 10 times in 5 seconds intervals when the Connection Retries is 10 and the Connection Retry Interval is 5000. 

An integer indicating the configured length of the time (in milliseconds) before each reattempt to access the destination file. The configured default is 1000 (1 second).