The Outbound DB2 Connect Type 4 Adapter > JDBC Connector Settings section of the DB2 Connect Environment properties, contains the top-level parameters displayed in the following table.
Table 22 Outbound DB2 Connect Type 4 Adapter - JDBC Connector Settings
Name |
Description |
Required Value |
---|---|---|
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. |