Creating Connection Pool Aliases Manually

For this parameter...

Specify...

Alias Name

Name to use for the connection pool. The name can include any characters that are valid for a file name in your operating system.

Alias Description

Brief description of the pool.

Associated Driver Alias

Database driver for Integration Server to use to connect to the pool.

Database URL

URL for the database server. Sample URL formats for the DataDirect Connect JDBC 5.1 driver are displayed Sample Database URL.

Important

Use the DataDirect Connect connection option MaxPooledStatements=35 on all database URLs except those for Trading Networks. This connection option improves performance by caching prepared statements. (Trading Networks caches its prepared statements using its own pooling mechanism).

For DB2, if Integration Server will connect to a schema other than the default schema for the specified database user, you must specify these connection options in the URL:

;AlternateId=schema;"InitializationString= (SET CURRENT
PATH=current_path,schema)"; MaxPooledStatements=35

AlternateID is the name of the default schema that is used to qualify unqualified database objects in dynamically prepared SQL statements.

For MySQL Community Edition 5.7, you must specify connection options for the relaxAutoCommit, useLegacyDatetimeCode, and serverTimezone parameters. For example, you can provide the connection options as follows:

jdbc:mysql://<server>:<3306|port>/databaseName?
relaxAutoCommit=true&useLegacyDatetimeCode=false&
serverTimezone=PST

Diagnostics

The DataDirect diagnostic feature for DataDirect Connect JDBC drivers used by Integration Server to interact with an external RDBMS.

Note:

These options are for use with an external RDBMS only. They are not for use with the embedded IS internal database.

Option

Description

Spy

When selected, enables the DataDirect Spy diagnostic feature for DataDirect Connect JDBC drivers. DataDirect Spy logs JDBC calls and SQL statement interactions between Integration Server and an external RDBMS.

This check box is cleared by default.

Snoop

When selected, Integration Server enables the DataDirect Snoop tool for DataDirect Connect JDBC drivers. The DataDirect Snoop tool logs network packets between Integration Server and an external RDBMS. You can use the resulting log file for tracing and diagnostic purposes.

This check box is cleared by default.

Spy Attributes

The name and location of the log file where Integration Server will log diagnostic data collected by the DataDirect Spy diagnostic feature. This value also defines DataDirect Spy attributes. The default value is:

SpyAttributes=(log=(file)/logs/spy/<alias_name>.log; logTName=yes;timestamp=yes)

Where <alias_name> is the name of the JDBC connection pool alias.

Note:

Typically, you do not need to change the default value. However, you can modify the value if the attributes do not meet the needs of your system. Be aware that the diagnostic tool collects data from the Integration Server_directory /instances/instance_name/logs/spy directory. If you change the log file location, the diagnostic utility might not import the data logged by DataDirect Spy. For more information about using the diagnostic utility, see Using the Diagnostic Utility. For more information about setting DataDirect Spy attributes, consult the documentation on the DataDirect website.

Snoop Logging Parameters

Defines the name and location of the log file where Integration Server will log diagnostic data collected by the DataDirect Snoop tool. This value also defines DataDirect Snoop tool attributes. The default value is:

ddtdbg.ProtocolTraceEnable=true;ddtdbg.Protocol TraceMaxline=16;ddtdbg.ProtocolTraceLocation=/logs/snoop/ alias_name.log;ddtdbg.ProtocolTraceShowTime=true

Where alias_name is the name of the JDBC connection pool alias.

Note:

For DB2, include the following command at the end of the value:

ddtdbg.ProtocolTraceEBCDIC=true

Typically, you do not need to change the default value. However, you can modify the value if the attributes do not meet the needs of your system. Be aware that the diagnostic tool collects data from the Integration Server_directory /instances/instance_name/logs/snoop directory. If you change the log file location, the diagnostic utility might not import the data logged by the DataDirect Snoop tool. For more information about using the diagnostic utility, see Using the Diagnostic Utility. For more information about setting the DataDirect Snoop tool attributes, consult the documentation on the DataDirect website.

User ID

Database user for Integration Server to use to connect to the database.

Password

Password for Integration Server to use to connect to the database. If a password is not required, leave this field blank.

Minimum Connections

Minimum number of connections the pool must keep open at all times.

If you use this pool alias for more than one function, each pool instance keeps the specified number of connections open. For example, if you specify keeping at least 3 connections open, and the IS Core Audit Log and the Document History database components both use this pool, the pool keeps a total of 6 connections open: 3 for the IS Core Audit Log pool instance and 3 for the Document History pool instance.

If your logging volume has sudden spikes, you can improve performance by making sure the connections needed to handle the increased volume open quickly. You can minimize connection startup time during spikes by setting this value higher, so that more connections remain open at all times.

Maximum Connections

Maximum number of connections the pools can have open at one time. When the number of connection requests reaches this value, Integration Server blocks the requests.

Calculate this value as part of the total possible number of connections that could be opened simultaneously by all functions and applications that write to the database. Make sure the total number does not exceed the database's connection limit. If one of the applications opens more connections than the database allows, the database will reject subsequent requests for connections from any application.

To continue the previous example, if Trading Networks also writes to the database and has a pool that could open up to 5 connections, you could specify only 17 as the maximum number of connections for the current pool. The IS Core Audit Log pool instance could use up to 17 connections, and the Document History pool instance could use the remaining 5 connections.

Available Connections Warning Threshold

Number of connections, expressed as a percentage of Maximum Connections, that should be available in the pool at all times.

When the number of connections falls to or below this number, Integration Server logs a message to the server log. If the number of connections later rises above this number, Integration Server logs another message to the server log stating that the connection pool threshold has been cleared. To disable this threshold, set the value to 0.

Waiting Thread Threshold Count

Maximum number of requests for connection that can be waiting at one time.

When this number is exceeded, Integration Server logs a message to the server log and starts a 5-minute interval timer. If the number of requests still exceeds this number at the end of the interval, Integration Server logs another message to the server log. To disable this threshold, set the value to 0.

Idle Timeout

Length of time, in milliseconds, the pool can keep an unused connection open. After the specified period of time elapses, the pool closes unused connections that are not needed to satisfy the Minimum Connections value. The default expiration time is 60000 milliseconds.