Description 

Enter a description for the database. 

A valid string. The default is DB2 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 50000.

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 is DB2 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.

LocationName 

Specifies the Location Name for the DB2 database that is being used on AS400/zOS. You can issue a “Select current service from sysibm.sysdummy1” to the database to find out its value. 

Any valid String. 

PackageCollection 

Specifies the PackageCollection for the DB2 database that is being used on AS400/zOS. Use the same one you used in the Wizard Connection Panel. 

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 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 50000.

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 

Any additional settings that are not otherwise part of the external system properties can be set here. 

Typically, anything that you would pass to the driver through the connect string, in the form of “AProperty = AValue” can be set in Java by calling setAProperty (“AValue”) which becomes setAProperty #AValue##. Use the JDBC driver that is shipped with this Adapter. 

Example 1:

To execute the method “setSpyAttributes” for the DataDirect driver, set the following string for the URL: “setSpyAttribute#<url>##”. 

Example 2:

To set DataDirect’s Spy Log, the Driver properties entry requires the following string: 

“setURL#jdbc:Seebeyond:DB2://<server>:4100;DatabaseName=<database>##setSpyAttributes#log=(file)c:/temp/spy.log;logTName=yes##”

Spy Log should be set for debugging purposes only.

Example 3:

For DB2 UDB, the Connect String parameter “SecurityMechanism=Encrypted Password” can be passed to the driver as “setSecurityMechanism# Encrypted Password##” This will call setSecurityMechanism (“Encrypted Password”) before the connection is established. 

A delimited list of parametrized method calls. 

The valid format is: 

“<method-name-1>#<param-1>#<param-2>#.....

....<param-n>##<method-name-2># <param-1>#<param-2>#.... ....<param-n> ##......##”.

Delimiter 

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

The default is #. See the DriverProperties property above for more information on how the default value is used.

MinPoolSize

Specifies the minimum number of physical connections the pool should keep available at all times. 0 (zero) indicates that there should be no physical connections in the pool and the new connections should be created as needed. 

If the pool size is too small, you may experience longer connection times due to the existing number of physical connections. 

A connection that stays in the pool allows transactions to use it via a logical connection which is faster. 

A valid numeric value. The default is 0.

MaxPoolSize

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

The pool size depends on the transaction volume and response time. If the pool size is too big, you may end up with too many connections with the database. 

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 Adapter 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 in 5 second intervals, a total of 10 times, when the Connection Retries property is set at 10 and the Connection Retry Interval property 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 non-Transactional 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 50000.

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 

Any additional settings that are not otherwise part of the external system properties can be set here. 

Typically, anything that you would pass to the driver through the connect string, in the form of “AProperty = AValue” can be set in Java by calling setAProperty (“AValue”) which becomes setAProperty #AValue##. Use the JDBC driver that is shipped with this Adapter. 

Example 1:

To execute the method “setSpyAttributes” for the DataDirect driver, set the following string for the URL: “setSpyAttribute#<url>##”. 

Example 2:

To set DataDirect’s Spy Log, the Driver properties entry requires the following string: 

“setURL#jdbc:Seebeyond:DB2://<server>:4100;DatabaseName=<database>##setSpyAttributes#log=(file)c:/temp/spy.log;logTName=yes##”

Spy Log should be set for debugging purposes only.

Example 3:

For DB2 UDB, the Connect String parameter “SecurityMechanism=Encrypted Password” can be passed to the driver as “setSecurityMechanism# Encrypted Password##” This will call setSecurityMechanism (“Encrypted Password”) before the connection is established. 

A delimited list of parametrized method calls. 

The valid format is: 

“<method-name-1>#<param-1>#<param-2>#.....

....<param-n>##<method-name-2># <param-1>#<param-2>#.... ....<param-n> ##......##”.

Delimiter 

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

The default is #. See the DriverProperties property above for more information on how the default value is used.

MinPoolSize

Specifies the minimum number of physical connections the pool should keep available at all times. 0 (zero) indicates that there should be no physical connections in the pool and the new connections should be created as needed. 

If the pool size is too small, you may experience longer connection times due to the existing number of physical connections. 

A connection that stays in the pool allows transactions to use it via a logical connection which is faster. 

A valid numeric value. The default is 0.

MaxPoolSize

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

The pool size depends on the transaction volume and response time. If the pool size is too big, you may end up with too many connections with the database. 

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 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 in 5 second intervals, a total of 10 times, when the Connection Retries property is set at 10 and the Connection Retry Interval property 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 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 50000.

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 

Any additional settings that are not otherwise part of the external system properties can be set here. 

Typically, anything that you would pass to the driver through the connect string, in the form of “AProperty = AValue” can be set in Java by calling setAProperty (“AValue”) which becomes setAProperty #AValue##. Use the JDBC driver that is shipped with this Adapter. 

Example 1:

To execute the method “setSpyAttributes” for the DataDirect driver, set the following string for the URL: “setSpyAttribute#<url>##”. 

Example 2:

To set DataDirect’s Spy Log, the Driver properties entry requires the following string: 

“setURL#jdbc:Seebeyond:DB2://<server>:4100;DatabaseName=<database>##setSpyAttributes#log=(file)c:/temp/spy.log;logTName=yes##”

Spy Log should be set for debugging purposes only.

Example 3:

For DB2 UDB, the Connect String parameter “SecurityMechanism=Encrypted Password” can be passed to the driver as “setSecurityMechanism# Encrypted Password##” This will call setSecurityMechanism (“Encrypted Password”) before the connection is established. 

A delimited list of parametrized method calls. 

The valid format is: 

“<method-name-1>#<param-1>#<param-2>#.....

....<param-n>##<method-name-2># <param-1>#<param-2>#.... ....<param-n> ##......##”.

Delimiter 

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

The default is #. See the DriverProperties property above for more information on how the default value is used.

MinPoolSize

Specifies the minimum number of physical connections the pool should keep available at all times. 0 (zero) indicates that there should be no physical connections in the pool and the new connections should be created as needed. 

If the pool size is too small, you may experience longer connection times due to the existing number of physical connections. 

A connection that stays in the pool allows transactions to use it via a logical connection which is faster. 

A valid numeric value. The default is 0.

MaxPoolSize

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

The pool size depends on the transaction volume and response time. If the pool size is too big, you may end up with too many connections with the database. 

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 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 in 5 second intervals, a total of 10 times, when the Connection Retries property is set at 10 and the Connection Retry Interval property 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 Datasource For AS400/zOS.

ServerName 

Specifies the host name of the external database server. 

Any valid string. 

LocationName 

Specifies the Location Name for the DB2 database that is being used on AS400/zOS. You can issue a “Select current service from sysibm.sysdummy1” to the database to find out its value. 

A valid port number. The default is 446.

PackageCollection 

Specifies the PackageCollection for the DB2 database that is being used on AS400/zOS. Use the same one you used in the Wizard Connection Panel.  

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 

Any additional settings that are not otherwise part of the external system properties can be set here. 

Typically, anything that you would pass to the driver through the connect string, in the form of “AProperty = AValue” can be set in Java by calling setAProperty (“AValue”) which becomes setAProperty #AValue##. Use the JDBC driver that is shipped with this Adapter. 

Example 1:

To execute the method “setSpyAttributes” for the DataDirect driver, set the following string for the URL: “setSpyAttribute#<url>##”. 

Example 2:

To set DataDirect’s Spy Log, the Driver properties entry requires the following string: 

“setURL#jdbc:Seebeyond:DB2://<server>:4100;DatabaseName=<database>##setSpyAttributes#log=(file)c:/temp/spy.log;logTName=yes##”

Spy Log should be set for debugging purposes only.

Example 3:

For DB2 UDB, the Connect String parameter “SecurityMechanism=Encrypted Password” can be passed to the driver as “setSecurityMechanism# Encrypted Password##” This will call setSecurityMechanism (“Encrypted Password”) before the connection is established. 

A delimited list of parametrized method calls. 

The valid format is: 

“<method-name-1>#<param-1>#<param-2>#.....

....<param-n>##<method-name-2># <param-1>#<param-2>#.... ....<param-n> ##......##”.

Delimiter 

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

A valid delimiter. The default is #. 

MinPoolSize 

Specifies the minimum number of physical connections the pool should keep available at all times. 0 (zero) indicates that there should be no physical connections in the pool and the new connections should be created as needed. 

If the pool size is too small, you may experience longer connection times due to the existing number of physical connections. 

A connection that stays in the pool allows transactions to use it via a logical connection which is faster. 

A valid numeric value. The default is 0.

MaxPoolSize 

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

The pool size depends on the transaction volume and response time. If the pool size is too big, you may end up with too many connections with the database. 

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 Adapter 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 reattempt 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 in 5 second intervals, a total of 10 times, when the Connection Retries property is set at 10 and the Connection Retry Interval property 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 Datasource For AS400/zOS.

ServerName 

Specifies the host name of the external database server. 

Any valid string. 

LocationName 

Specifies the Location Name for the DB2 database that is being used on AS400/zOS. You can issue a “Select current service from sysibm.sysdummy1” to the database to find out its value. 

A valid port number. The default is 446.

PackageCollection 

Specifies the PackageCollection for the DB2 database that is being used on AS400/zOS. Use the same one you used in the Wizard Connection Panel.  

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 

Any additional settings that are not otherwise part of the external system properties can be set here. 

Typically, anything that you would pass to the driver through the connect string, in the form of “AProperty = AValue” can be set in Java by calling setAProperty (“AValue”) which becomes setAProperty #AValue##. Use the JDBC driver that is shipped with this Adapter. 

Example 1:

To execute the method “setSpyAttributes” for the DataDirect driver, set the following string for the URL: “setSpyAttribute#<url>##”. 

Example 2:

To set DataDirect’s Spy Log, the Driver properties entry requires the following string: 

“setURL#jdbc:Seebeyond:DB2://<server>:4100;DatabaseName=<database>##setSpyAttributes#log=(file)c:/temp/spy.log;logTName=yes##”

Spy Log should be set for debugging purposes only.

Example 3:

For DB2 UDB, the Connect String parameter “SecurityMechanism=Encrypted Password” can be passed to the driver as “setSecurityMechanism# Encrypted Password##” This will call setSecurityMechanism (“Encrypted Password”) before the connection is established. 

A delimited list of parametrized method calls. 

The valid format is: 

“<method-name-1>#<param-1>#<param-2>#.....

....<param-n>##<method-name-2># <param-1>#<param-2>#.... ....<param-n> ##......##”.

Delimiter 

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

A valid delimiter. The default is #. 

MinPoolSize 

Specifies the minimum number of physical connections the pool should keep available at all times. 0 (zero) indicates that there should be no physical connections in the pool and the new connections should be created as needed. 

If the pool size is too small, you may experience longer connection times due to the existing number of physical connections. 

A connection that stays in the pool allows transactions to use it via a logical connection which is faster. 

A valid numeric value. The default is 0.

MaxPoolSize 

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

The pool size depends on the transaction volume and response time. If the pool size is too big, you may end up with too many connections with the database. 

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 Adapter 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 reattempt 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 in 5 second intervals, a total of 10 times, when the Connection Retries property is set at 10 and the Connection Retry Interval property 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).

OverwriteCatalog Name 

Indicates whether or not to overwrite the database catalog name in the sql statements generated by eTL collaboration. 

A True or False value. If you select “True”, the content of the “CatalogNameMap” property will be used. If “False” is selected, the catalog name will be ovewritten. The default is True.

CatalogNameMap 

Specifies the key-value pair(s) for catalog name overwrites. The correct format is: <oldCatalogName1>=<newCatlogName1>;<oldCatalogName2>=<newCatalogName2>;... 

A semi-colon separated list that contains valid name overwrites. 

OverwriteSchema Name 

Indicates whether or not to overwrite the database schema name in the sql statements generated by eTL collaboration. 

A True or False value. If you select “True”, the content of next configuration property “SchemaNameMap” will be used. If “False” is selected, the schema name will be ovewritten. The default is True.

SchemaNameMap 

Specifies the key-value pair(s) for schema name overwrites. The correct format is: <oldSchemaName1>=<newSchemaName1>;<oldSchemaName2>=<newSchemaName2>;... 

A semi-colon separated list that contains valid name overwrites. 

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).

Description 

The description of the database. 

Any valid string. 

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 1526.

InformixServer 

Specifies the name of the Informix server being used. 

Any valid string. 

DatabaseName 

Specifies the name of the database being used by the server. 

Any valid string. 

User 

Specifies the user name 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. The default is INFORMIX Connection Pool Datasource. 

Any valid string. 

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 1526.

InformixServer 

Specifies the name of the Informix server being used. 

Any valid string. 

DatabaseName 

Specifies the name of the database being used by the server. 

Any valid string. 

User 

Specifies the user name the adapter uses to connect to the database. 

Any valid string. 

Password 

Specifies the password used to access the database. 

Any valid string. 

DriverProperties 

Specifies the driver properties used for this adapter. If you choose not to use the JDBC driver that is shipped with this adapter, you will need to add the drivers properties to the adapter. Often times the DataSource implementation will need to execute additional properties to assure a connection. The additional methods will need to be identified 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 execute the method setURL, give the method a String for the URL “setURL#<url>##”.

The setSpyAttributes, contained in the following examples (between the last set of double octothorps [##] within each example), are used for debugging purposes and need not be used on every occasion.

“setURL#jdbc:SeeBeyond:informix://<host>1526;DatabaseName=<database>##setInformixServer#<informixserver>##setSpyAttributes#log=(file)c:/temp/spy.log;logTName=yes##”.

Delimiter 

Specifies the delimiter character used in the DriverProperties prompt. 

The default is #.

MinPoolSize 

Specifies the minimum number of physical connections the pool should keep available at all times. 0 (zero) indicates that there should be no physical connections in the pool and the new connections should be created as needed. 

A valid numeric value. The default is 0.

MaxPoolSize 

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

A valid numeric value. The default is 10.

MaxIdleTime 

Specifies 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 upon initial failure. 

A valid numeric value. The default is 0.

ConnectionRetryInterval 

Specifies the number of milliseconds of pause before each reattempt to acces the destination file. This property is used in conjunction with the Connection Retries setting. 

A valid numeric value. The default is 1000.

Description 

Enter a description for the database. The default is INFORMIX non-Transactional Connection Pool Datasource. 

Any valid string. 

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 1526.

InformixServer 

Specifies the name of the Informix server being used. 

Any valid string. 

DatabaseName 

Specifies the name of the database being used by the server. 

Any valid string. 

User 

Specifies the user name the adapter uses to connect to the database. 

Any valid string. 

Password 

Specifies the password used to access the database. 

Any valid string. 

DriverProperties 

Specifies the driver properties used for this adapter. If you choose not to use the JDBC driver that is shipped with this adapter, you will need to add the drivers properties to the adapter. Often times the DataSource implementation will need to execute additional properties to assure a connection. The additional methods will need to be identified 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 execute the method setURL, give the method a String for the URL “setURL#<url>##”.

The setSpyAttributes, contained in the following examples (between the last set of double octothorps [##] within each example), are used for debugging purposes and need not be used on every occasion.

“setURL#jdbc:SeeBeyond:informix://<host>1526;DatabaseName=<database>##setInformixServer#<informixserver>##setSpyAttributes#log=(file)c:/temp/spy.log;logTName=yes##”.

Delimiter 

Specifies the delimiter character used in the DriverProperties prompt. 

The default is #.

MinPoolSize 

Specifies the minimum number of physical connections the pool should keep available at all times. 0 (zero) indicates that there should be no physical connections in the pool and the new connections should be created as needed. 

A valid numeric value. The default is 0.

MaxPoolSize 

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

A valid numeric value. The default is 10.

MaxIdleTime 

Specifies 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 upon initial failure. 

A valid numeric value. The default is 0.

ConnectionRetryInterval 

Specifies the number of milliseconds of pause before each reattempt to access the destination file. This property is used in conjunction with the Connection Retries setting. 

A valid numeric value. The default is 1000.

Description 

Enter a description for the database. The default is INFORMIX XA Connection Pool Datasource. 

Any valid string. 

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 1526.

InformixServer 

Specifies the name of the Informix server being used. 

Any valid string. 

DatabaseName 

Specifies the name of the database being used by the server. 

Any valid string. 

User 

Specifies the user name the adapter uses to connect to the database. 

Any valid string. 

Password 

Specifies the password used to access the database. 

Any valid string. 

DriverProperties 

Specifies the driver properties used for this adapter. If you choose not to use the JDBC driver that is shipped with this adapter, you will need to add the drivers properties to the adapter. Often times the DataSource implementation will need to execute additional properties to assure a connection. The additional methods will need to be identified 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 execute the method setURL, give the method a String for the URL “setURL#<url>##”.

The setSpyAttributes, contained in the following examples (between the last set of double octothorps [##] within each example), are used for debugging purposes and need not be used on every occasion.

“setURL#jdbc:SeeBeyond:informix://<host>1526;DatabaseName=<database>##setInformixServer#<informixserver>##setSpyAttributes#log=(file)c:/temp/spy.log;logTName=yes##”.

Delimiter 

Specifies the delimiter character used in the DriverProperties prompt. 

The default is #.

MinPoolSize 

Specifies the minimum number of physical connections the pool should keep available at all times. 0 (zero) indicates that there should be no physical connections in the pool and the new connections should be created as needed. 

A valid numeric value. The default is 0.

MaxPoolSize 

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

A valid numeric value. The default is 10.

MaxIdleTime 

Specifies 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 upon initial failure. 

A valid numeric value. The default is 0.

ConnectionRetryInterval 

Specifies the number of milliseconds of pause before each reattempt to access the destination file. This property is used in conjunction with the Connection Retries setting. 

A valid numeric value. The default is 1000.

Description 

Enter a description for the database. 

A valid string. The default is Oracle 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 1521.

DatabaseName 

Specifies the name of the Oracle SID. 

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 is Oracle 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 1521.

DatabaseName 

Specifies the name of the Oracle SID. 

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 (Optional Setting)

Use the JDBC driver that is shipped with this Adapter. The DataSource implementation may need to execute additional methods to assure a successful run. The additional methods will need to be identified in the Driver Properties. 

This field is seldomly used for Oracle.

The delimiter set by the user. For more information, see the Delimiter property below. 

Valid delimiters are: 

“<method-name-1>#<param-1>

Delimiter 

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

The default is #. See the DriverProperties property above for more information on how the default value is used.

TNSEntry 

Specifies the TNS name for the Oracle instance specified in TNSNAMES.ORA. If a TNS name is specified, then the OCI driver is used, which further requires installation of the Oracle client. If a TNS name is not specified, then the thin driver is used.

A valid TNS name if using the OCI driver; otherwise do not enter any value. 

MinPoolSize 

Specifies the minimum number of physical connections the pool should keep available at all times. 0 (zero) indicates that there should be no physical connections in the pool and the new connections should be created as needed. 

If the pool size is too small, you may experience longer connection times due to the existing number of physical connections. 

A connection that stays in the pool allows transactions to use it via a logical connection which is faster. 

A valid numeric value. The default is 0.

MaxPoolSize 

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

The pool size depends on the transaction volume and response time. If the pool size is too big, you may end up with too many connections with the database. 

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 Oracle database upon a failure to acquire one. 

an integer indicationg 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 in 5 second intervals, a total of 10 times, when the Connection Retries property is set at 10 and the Connection Retry Interval property 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 Oracle 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 1521.

DatabaseName 

Specifies the name of the Oracle SID. 

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 (Optional Setting)

Use the JDBC driver that is shipped with this Adapter. The DataSource implementation may need to execute additional methods to assure a successful run. The additional methods will need to be identified in the Driver Properties. 

The delimiter set by the user. For more information, see the Delimiter property below. 

Valid delimiters are: 

“<method-name-1>#<param-1>#<param-2>

Delimiter 

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

The default is #. See the DriverProperties property above for more information on how the default value is used.

TNSEntry 

Specifies the TNS name for the Oracle instance specified in TNSNAMES.ORA. If a TNS name is specified, then the OCI driver is used, which further requires installation of the Oracle client. If a TNS name is not specified, then the thin driver is used.

A valid TNS name if using the OCI driver; otherwise do not enter any value. 

MinPoolSize 

Specifies the minimum number of physical connections the pool should keep available at all times. 0 (zero) indicates that there should be no physical connections in the pool and the new connections should be created as needed. 

If the pool size is too small, you may experience longer connection times due to the existing number of physical connections. 

A connection that stays in the pool allows transactions to use it via a logical connection which is faster. 

A valid numeric value. The default is 0.

MaxPoolSize 

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

The pool size depends on the transaction volume and response time. If the pool size is too big, you may end up with too many connections with the database. 

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 Oracle 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 in 5 second intervals, a total of 10 times, when the Connection Retries property is set at 10 and the Connection Retry Interval property 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 SQLServer 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 1433. 

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 is SQLServer 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 1433. 

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

The DataSource implementation may need to execute additional methods to assure a successful run. The additional methods will need to be identified in the Driver Properties. 

The delimiter set by the user. For more information, see the Delimiter property below. 

Valid delimiters are: 

“<method-name-1>#<param-1>#<param-2>

#.........<param-n>##<method-name-2>#<param-1>

#<param-2>#........<param-n>##......##”.

For example: to execute the method setSpyAttributes, give the method a String for the URL “setSpyAttribute#<url>##”. 

The setSpyAttributes (for Data Direct drivers) that are contained in the following examples (between the last set of double octothorps [##] within each example), are used for debugging purposes and need not be used on every occasion.

Optional—if you are using Spy Log: 

“setURL#jdbc:Seebeyond:SQLServer://<server>:4100;

DatabaseName=<database>##setSpyAttributes#log=

(file)c:/temp/spy.log;logTName=yes##”

Delimiter 

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

The default is #. See the DriverProperties property above for more information on how the default value is used.

MinPoolSize

Specifies the minimum number of physical connections the pool should keep available at all times. 0 (zero) indicates that there should be no physical connections in the pool and the new connections should be created as needed. 

If the pool size is too small, you may experience longer connection times due to the existing number of physical connections. 

A connection that stays in the pool allows transactions to use it via a logical connection which is faster. 

A valid numeric value. The default is 0.

MaxPoolSize

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

The pool size depends on the transaction volume and response time. If the pool size is too big, you may end up with too many connections with the database. 

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. 

ConnectionRetries 

Specifies the number of retries to establish a connection with the SQL Server 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 in 5 second intervals, a total of 10 times, when the Connection Retries property is set at 10 and the Connection Retry Interval property is 5000. 

A valid numeric value. The default is 1000.

Description 

Enter a description for the database. 

A valid string. The default is SQLServer 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 1433. 

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

The DataSource implementation may need to execute additional methods to assure a successful run. The additional methods will need to be identified in the Driver Properties. 

The delimiter set by the user. For more information, see the Delimiter property below. 

Valid delimiters are: 

“<method-name-1>#<param-1>#<param-2>

#.........<param-n>##<method-name-2>#<param-1>

#<param-2>#........<param-n>##......##”.

For example: to execute the method setSpyAttributes, give the method a String for the URL “setSpyAttribute#<url>##”. 

The setSpyAttributes (for Data Direct drivers) that are contained in the following examples (between the last set of double octothorps [##] within each example), are used for debugging purposes and need not be used on every occasion.

Optional—if you are using Spy Log: 

“setURL#jdbc:Seebeyond:SQLServer://<server>:4100;”

DatabaseName=<database>##setSpyAttributes#log=

(file)c:/temp/spy.log;logTName=yes##

Delimiter 

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

The default is #. See the DriverProperties property above for more information on how the default value is used.

MinPoolSize

Specifies the minimum number of physical connections the pool should keep available at all times. 0 (zero) indicates that there should be no physical connections in the pool and the new connections should be created as needed. 

If the pool size is too small, you may experience longer connection times due to the existing number of physical connections. 

A connection that stays in the pool allows transactions to use it via a logical connection which is faster. 

A valid numeric value. The default is 0.

MaxPoolSize

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

The pool size depends on the transaction volume and response time. If the pool size is too big, you may end up with too many connections with the database. 

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. 

ConnectionRetries 

Specifies the number of retries to establish a connection with the SQL Server 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 in 5 second intervals, a total of 10 times, when the Connection Retries property is set at 10 and the Connection Retry Interval property is 5000. 

A valid numeric value. The default is 1000.

Description 

Enter a description for the database. 

A valid string. The default value is SQLServer 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 1433. 

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

The DataSource implementation may need to execute additional methods to assure a successful run. The additional methods will need to be identified in the Driver Properties. 

The delimiter set by the user. For more information, see the Delimiter property below. 

Valid delimiters are: 

“<method-name-1>#<param-1>#<param-2>#

.........<param-n>##<method-name-2>#

<param-1>#<param-2>#........<param-n>##......##”.

For example: to execute the method setSpyAttributes, give the method a String for the URL “setSpyAttribute#<url>##”. 

The setSpyAttributes (for Data Direct drivers) that are contained in the following examples (between the last set of double octothorps [##] within each example), are used for debugging purposes and need not be used on every occasion.

Optional—if you are using Spy Log: 

“setURL#jdbc:Seebeyond:SQLServer://<server>:4100;

DatabaseName=<database>##setSpyAttributes#log=

(file)c:/temp/spy.log;logTName=yes##”

Delimiter 

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

The default is #. See the DriverProperties property above for more information on how the default value is used.

MinPoolSize

Specifies the minimum number of physical connections the pool should keep available at all times. 0 (zero) indicates that there should be no physical connections in the pool and the new connections should be created as needed. 

If the pool size is too small, you may experience longer connection times due to the existing number of physical connections. 

A connection that stays in the pool allows transactions to use it via a logical connection which is faster. 

A valid numeric value. The default is 0.

MaxPoolSize

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

The pool size depends on the transaction volume and response time. If the pool size is too big, you may end up with too many connections with the database. 

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. 

ConnectionRetries 

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

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

ConnectionRetryInterval

Specifies the milliseconds of pause before each reattempt 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 in 5 second intervals, a total of 10 times, when the Connection Retries property is set at 10 and the Connection Retry Interval property is 5000. 

A valid numeric value. The default is 1000.

Description

The description of the database. 

A valid string. 

ServerName

Specifies the host name of the external database server. 

Any valid string. 

The Sybase Adapter does not support using “localhost” as the server name.

PortNumber

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

A valid port number. The default is 4100.

DatabaseName

Specifies the name of the database instance. 

Any valid string. 

User

Specifies the user name the adapter uses to connect to the database. 

Any valid string. 

Password

Specifies the password used to access the database. 

Any valid string. 

Description

The description of the database. 

A valid string. 

ServerName

This setting specifies the host name of the external database server. 

Any valid string. 

The Sybase Adapter does not support using “localhost” as the server name.

PortNumber

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

A valid port number. The default is 4100.

DatabaseName

Specifies the name of the database instance. 

Any valid string. 

User

Specifies the user name the adapter uses to connect to the database. 

Any valid string. 

Password

Specifies the password used to access the database. 

Any valid string. 

DriverProperties

The DataSource implementation may need to execute additional methods to assure a successful run. The additional methods will need to be identified in the Driver Properties. 

The delimiter set by the user. For more information, see the Delimiter property below. 

Valid delimiters are: 

“<method-name-1>#<param-1>#<param-2>#.........<param-n>##<method-name-2>#<param-1>#<param-2>#........<param-n>##......##”.

For example: to execute the method setSpyAttributes, give the method a String for the URL “setSpyAttribute#<url>##”. 

The setSpyAttributes (for Data Direct drivers) that are contained in the following examples (between the last set of double octothorps [##] within each example), are used for debugging purposes and need not be used on every occasion.

Optional—if you are using Spy Log: 

“setURL#jdbc:Seebeyond:Sybase://<server>:4100;DatabaseName=<database>##setSpyAttributes#log=(file)c:/temp/spy.log;logTName=yes##”

Delimiter

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

The default is #. See the DriverProperties property above for more information on how the default value is used.

MinPoolSize

Specifies the minimum number of physical connections the pool should keep available at all times. 0 (zero) indicates that there should be no physical connections in the pool and the new connections should be created as needed. 

If the pool size is too small, you may experience a longer connection time due to the existing number of physical connections. 

A connection that stays in the pool allows transactions to use it via a logical connection which is faster. 

A valid numeric value. The default is 0.

MaxPoolSize

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

The pool size you set depends on the transaction volume and response time of the application. If the pool size is too big, you may end up with too many connections with the database. 

A valid numeric value. The default is 10.

MaxIdleTime

Specifies 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 upon failure to acquire one. 

A valid numeric value. The default is 0.

ConnectionRetryInterval

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. 

A valid numeric value. The default is 1000.

Description

The description of the database. 

Any valid string. 

ServerName

Specifies the host name of the external database server. 

Any valid string. 

The Sybase Adapter does not support using “localhost” as the server name.

PortNumber

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

A valid port number. The default is 4100.

DatabaseName

Specifies the name of the database instance. 

Any valid string. 

User

Specifies the user name the adapter uses to connect to the database. 

Any valid string. 

Password

Specifies the password used to access the database. 

Any valid string. 

DriverProperties

If you choose to not to use the JDBC driver that is shipped with this adapter, you will need to add the drivers properties to the adapter. Often times the DataSource implementation will need to execute additional methods to assure a connection. The additional methods will need to be identified in the Driver Properties. 

The delimiter set by the user. For more information, see the Delimiter property below. 

Valid delimiters are: 

“<method-name-1>#<param-1>#<param-2>#.........<param-n>##<method-name-2>#<param-1>#<param-2>#........<param-n>##......##”.

For example: to execute the method setSpyAttributes, give the method a String for the URL “setSpyAttribute#<url>##”. 

The setSpyAttributes (for Data Direct drivers) that are contained in the following examples (between the last set of double octothorps [##] within each example), are used for debugging purposes and need not be used on every occasion.

Optional—if you are using Spy Log: 

“setURL#jdbc:Seebeyond:Sybase://<server>:4100;DatabaseName=<database>##setSpyAttributes#log=(file)c:/temp/spy.log;logTName=yes##”

Delimiter

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

The default is #.

MinPoolSize

Specifies the minimum number of physical connections the pool should keep available at all times. 0 (zero) indicates that there should be no physical connections in the pool and the new connections should be created as needed. 

A valid numeric value. The default is 0.

MaxPoolSize

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

A valid numeric value. The default is 10.

MaxIdleTime

Specifies the 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 upon failure to acquire one. 

A valid numeric value. The default is 0.

ConnectionRetryInterval

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. 

A valid numeric value. The default is 1000.

Description

The description of the database. 

Any valid string. 

ServerName

Specifies the host name of the external database server. 

Any valid string. 

The Sybase Adapter does not support using “localhost” as the server name.

PortNumber

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

A valid port number. The default is 1521.

The default port number displayed in this field is incorrect. The value should be 4100.

DatabaseName

Specifies the name of the database instance. 

Any valid string. 

User

Specifies the user name the adapter uses to connect to the database. 

Any valid string. 

Password

Specifies the password used to access the database. 

Any valid string. 

DriverProperties

If you choose to not to use the JDBC driver that is shipped with this adapter, you will need to add the drivers properties to the adapter. Often times the DataSource implementation will need to execute additional methods to assure a connection. The additional methods will need to be identified in the Driver Properties. 

The delimiter set by the user. For more information, see the Delimiter property below. 

Valid delimiters are: 

“<method-name-1>#<param-1>#<param-2>#.........<param-n>##<method-name-2>#<param-1>#<param-2>#........<param-n>##......##”.

For example: to execute the method setSpyAttributes, give the method a String for the URL “setSpyAttribute#<url>##”. 

The setSpyAttributes (for Data Direct drivers) that are contained in the following examples (between the last set of double octothorps [##] within each example), are used for debugging purposes and need not be used on every occasion.

Optional—if you are using Spy Log: 

“setURL#jdbc:Seebeyond:Sybase://<server>:4100;DatabaseName=<database>##setSpyAttributes#log=(file)c:/temp/spy.log;logTName=yes##”

Delimiter

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

The default is #.

MinPoolSize

Specifies the minimum number of physical connections the pool should keep available at all times. 0 (zero) indicates that there should be no physical connections in the pool and the new connections should be created as needed. 

A valid numeric value. The default is 0.

MaxPoolSize

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

A valid numeric value. The default is 10.

MaxIdleTime

Specifies the 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 upon failure to acquire one. 

A valid numeric value. The default is 0.

ConnectionRetryInterval

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. 

A valid numeric value. The default is 1000.

Description

The description of the database. 

A valid string. 

ClassName 

Displays the Java class in the JDBC driver that is used to implement the Driver Manager interface. Change this as needed for your driver. 

A valid class name. 

See the JDBC/ODBC Drivers section for some of the popular drivers you can use with this adapter. 

URL 

This is the JDBC URL required to gain access to the database. The URL usually starts with jdbc; followed by <subprotocol> and ends with information that identifies the data source, as follows:

jdbc:<driver>:<data-source-name>[;<attribute-name>=<attribute-value>] 

If you do not select URL in the connection method this parameter is ignored. For more information on the JDBC URL, please consult the documentation of your specific driver.

The applicable JDBC URL. 

See the JDBC/ODBC Drivers section for some of the popular drivers you can use with this adapter. 

User

Specifies the user name the adapter uses to connect to the database. 

Any valid string. 

Password

Specifies the password used to access the database. 

Any valid string. 

Description

The description of the database. 

A valid string. The configured default is JDBC Connection Pool Datasource.

ClassName

Specifies the Java class in the JDBC driver that is used to implement the ConnectionPoolDataSource, XADataSource interface. Change as needed for your driver.

A valid class name. 

For example: 

com.ibm.as400.access.AS400JDBC 

ConnectionPoolDataSource 

See the JDBC/ODBC Drivers section for some of the popular drivers you can use with this adapter. 

ClassNamefor 

OtherInterfaces 

For components such as eTL that do not use ConnectionPoolDataSource, use this entry to enter the name of the driver class. This entry is not used by the JDBC Adapter.

A valid class name. 

ServerName 

This setting 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. 

DatabaseName

Specifies the name of the database instance. 

Any valid string. 

User

Specifies the user name the adapter uses to connect to the database. 

Any valid string. 

Password

Specifies the password used to access the database. 

Any valid string. 

DriverProperties

The Connection Pool DataSource implementation may need to execute additional methods to assure a successful run. The additional methods will need to be identified in the Driver Properties. You must ensure that the driver is installed on both the app server machine and Java CAPS IDE. 

Set the driver properties according to driver vendor’s instruction. For example: 

setDefTdpName#DBSQL##setWorkspace#Navigator## 

Delimiter

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

The default is #.

DataSource 

name 

Specifies the name of the XADataSource or ConnectionPoolDataSource implementation, to which the DataSource object delegates behind the scenes when there is connection pooling or distributed transaction management being done.

The name of the XADataSource or ConnectionPoolDataSource implementation.

This property is Optional, in most cases, leave this box empty. 

MinPoolSize

Specifies the minimum number of physical connections the pool should keep available at all times. 0 (zero) indicates that there is no maximum. 

The pool size you set depends on the transaction volume and response time of the application. If the pool size is too big, you may end up with too many connections with the database. 

A valid numeric value. The default is 0.

MaxPoolSize

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

If the pool size is too big, you may end up with too many connections with the database. The pool size depends on the transaction volume and response time. 

A valid numeric value. The default is 10.

MaxIdleTime

Specifies 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 upon failure to acquire one. 

A valid numeric value. The default is 0.

ConnectionRetryInterval

Specifies the milliseconds of pause before each attempt to reaccess 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 apart when the Connection Retries is 10 and the Connection Retry Interval is 5000 

A valid numeric value. The default is 1000.

Description

The description of the database. 

A valid string. The configured default is JDBC non-Transactional Connection Pool Datasource.

ClassName

Specifies the Java class in the JDBC driver that is used to implement the ConnectionPoolDataSource/XADataSource interface. Change as needed for your driver.

A valid class name. 

For example: 

com.ddtek.jdbcx.sequelink.SequeLinkDataSource.

ClassNamefor 

OtherInterfaces 

For components that do not use ConnectionPoolDataSource, use this entry to enter the name of the driver class. This class will not be used by the adapter.

A valid class name. 

ServerName 

This setting 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. 

DatabaseName

Specifies the name of the database instance. 

Any valid string. 

User

Specifies the user name the adapter uses to connect to the database. 

Any valid string. 

Password

Specifies the password used to access the database. 

Any valid string. 

DriverProperties

The Connection Pool DataSource implementation may need to execute additional methods to assure a successful run. The additional methods will need to be identified in the Driver Properties. You must ensure that the driver is installed on both the app server machine and Java CAPS IDE. 

Set the driver properties according to driver vendor’s instruction. For example: 

setDefTdpName#DBSQL##set 

Workspace#Navigator## 

Delimiter

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

The default is #.

DataSource 

name 

Specifies the name of the XADataSource or ConnectionPoolDataSource implementation, to which the DataSource object delegates behind the scenes when there is connection pooling or distributed transaction management being done.

The name of the XADataSource or ConnectionPoolDataSource implementation. This property is Optional. In most cases, leave this box empty.

MinPoolSize

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

The pool size you set depends on the transaction volume and response time of the application. If the pool size is too big, you may end up with too many connections with the database. 

A valid numeric value. The default is 0.

MaxPoolSize

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

If the pool size is too big, you may end up with too many connections with the database. The pool size depends on the transaction volume and response time. 

A valid numeric value. The default is 10.

MaxIdleTime

Specifies 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 upon failure to acquire one. 

A valid numeric value. The default is 0.

ConnectionRetryInterval

Specifies the milliseconds of pause before each attempt to reaccess 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 apart when the Connection Retries is 10 and the Connection Retry Interval is 5000 

A valid numeric value. The default is 1000.

Description

The description of the database. 

A valid string. The configured default is JDBC XA Datasource.

ClassName

Specifies the Java class in the JDBC driver that is used to implement the ConnectionPoolDataSource or XADataSource interface. Change as needed for your driver.

A valid class name. 

For example: 

com.attunity.jdbc.NvXADataSource 

ClassNamefor 

OtherInterfaces 

For components that do not use ConnectionPoolDataSource, use this entry to enter the name of the driver class. This class will not be used by the adapter.

A valid class name. 

ServerName 

This setting 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. 

DatabaseName

Specifies the name of the database instance. 

Any valid string. 

User

Specifies the user name the adapter uses to connect to the database. 

Any valid string. 

Password

Specifies the password used to access the database. 

Any valid string. 

DriverProperties

The DataSource implementation may need to execute additional methods to assure a successful run. The additional methods will need to be identified in the Driver Properties. You must ensure that the driver is installed on both the app server machine and Java CAPS IDE. 

Set the driver properties according to driver vendor’s instruction. For example: 

setDefTdpName#DBSQL## 

setWorkspace#Navigator## 

Delimiter

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

The default is #.

DataSource 

name 

Specifies the name of the XADataSource implementation, to which the DataSource object delegates behind the scenes when there is connection pooling or distributed transaction management being done.

The name of the XADataSource implementation. This property is Optional. In most cases, leave this box empty.

MinPoolSize

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

The pool size you set depends on the transaction volume and response time of the application. If the pool size is too big, you may end up with too many connections with the database. 

A valid numeric value. The default is 0.

MaxPoolSize

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

If the pool size is too big, you may end up with too many connections with the database. The pool size depends on the transaction volume and response time. 

A valid numeric value. The default is 10.

MaxIdleTime

Specifies 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 upon failure to acquire one. 

A valid numeric value. The default is 0.

ConnectionRetryInterval

Specifies the milliseconds of pause before each attempt to reaccess 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 apart when the Connection Retries is 10 and the Connection Retry Interval is 5000 

A valid numeric value. The default is 1000.

Description

The description of the database. 

A valid string. 

ServerName 

This setting 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. 

DatabaseName 

Specifies the name of the database instance. This parameter is configured in conjuction with the Data Catalogue name you created in WebSphere Classic Federation’s Data Mapper. 

Any valid string. 

User

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

Any valid string. 

Password

Specifies the password used to access the database. 

Any valid string. 

Description

The description of the database. 

A valid string. The configured default is VSAM Connection Pool Datasource.

ServerName 

This setting 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. 

DatabaseName

Specifies the name of the database instance. 

Any valid string. 

User

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

Any valid string. 

Password

Specifies the password used to access the database. 

Any valid string. 

DriverProperties

The Connection Pool DataSource implementation may need to execute additional methods to assure a successful run. The additional methods will need to be identified in the Driver Properties. You must ensure that the driver is installed on both the app server machine and Java CAPS IDE. 

The delimiter set by the user. For more information, see the Delimiter property below. 

Valid delimiters are: 

“<method-name-1>#<param-1>#<param-2>

#....<param-n>##<method-name-2>#<param-1>

#<param-2>#........<param-n>##......##”.

For example: to execute the method setSpyAttributes, give the method a String for the URL “setSpyAttribute#<url>##”. 

The setSpyAttributes (for Data Direct drivers) that are contained in the following examples (between the last set of double octothorps [##] within each example), are used for debugging purposes and need not be used on every occasion.

Optional—if you are using Spy Log: 

“setURL#jdbc:Seebeyond:VSAM://<server>:4100;

DatabaseName=<database>##setSpyAttributes

#log=(file)c:/temp/spy.log;logTName=yes##”

Delimiter

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

The default is #. See the DriverProperties property above for more information on how the default value is used.

MinPoolSize

Specifies the minimum number of physical connections the pool should keep available at all times. 0 (zero) indicates that there should be no physical connections in the pool and the new connections should be created as needed.

If the pool size is too small, you may experience a longer connection time due to the existing number of physical connections. 

A connection that stays in the pool allows transactions to use it via a logical connection (which is faster). 

A valid numeric value. The default is 0.

MaxPoolSize

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

If the pool size is too big, you may end up with too many connections with the database. The pool size depends on the transaction volume and response time. 

A valid numeric value. The default is 10.

MaxIdleTime

Specifies 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 upon failure to acquire one. 

A valid numeric value. The default is 0.

ConnectionRetryInterval

Specifies the milliseconds of pause before each attempt to reaccess 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 apart when the Connection Retries is 10 and the Connection Retry Interval is 5000. 

A valid numeric value. The default is 1000.

Description

The description of the database. 

A valid string. The configured default is VSAM non-Transactional Connection Pool Datasource.

ServerName 

This setting 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. 

DatabaseName

Specifies the name of the database instance. 

Any valid string. 

User

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

Any valid string. 

Password

Specifies the password used to access the database. 

Any valid string. 

DriverProperties

The Connection Pool DataSource implementation may need to execute additional methods to assure a successful run. The additional methods will need to be identified in the Driver Properties. You must ensure that the driver is installed on both the app server machine and Java CAPS IDE. 

The delimiter set by the user. For more information, see the Delimiter property below.

Valid delimiters are: 

“<method-name-1>#<param-1>#<param-2>#

.........<param-n>##<method-name-2>#

<param-1>#<param-2>#........<param-n>##......##”.

For example: to execute the method setSpyAttributes, give the method a String for the URL “setSpyAttribute#<url>##”. 

The setSpyAttributes (for Data Direct drivers) that are contained in the following examples (between the last set of double octothorps [##] within each example), are used for debugging purposes and need not be used on every occasion.

Optional—if you are using Spy Log: 

“setURL#jdbc:Seebeyond:VSAM://<server>:4100;

DatabaseName=<database>##setSpyAttributes#

log=(file)c:/temp/spy.log;logTName=yes##”

Delimiter

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

The default is #. See the DriverProperties property above for more information on how the default value is used.

MinPoolSize

Specifies the minimum number of physical connections the pool should keep available at all times. 0 (zero) indicates that there should be no physical connections in the pool and the new connections should be created as needed.

If the pool size is too small, you may experience a longer connection time due to the existing number of physical connections. 

A connection that stays in the pool allows transactions to use it via a logical connection (which is faster). 

A valid numeric value. The default is 0.

MaxPoolSize

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

If the pool size is too big, you may end up with too many connections with the database. The pool size depends on the transaction volume and response time. 

A valid numeric value. The default is 10.

MaxIdleTime

Specifies 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 upon failure to acquire one. 

A valid numeric value. The default is 0.

ConnectionRetryInterval

Specifies the milliseconds of pause before each attempt to reaccess 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 apart when the Connection Retries is 10 and the Connection Retry Interval is 5000. 

A valid numeric value. The default is 1000.