You can monitor the global transport objects pool in either of the following ways:
v Using traces that you start using IBM Data Server Driver for JDBC and SQLJ
configuration properties
v Using an application programming interface
Related reference
“Properties for the IBM Data Server Driver for JDBC and SQLJ” on page 201
Example of enabling the IBM Data Server Driver for JDBC and SQLJ
connection concentrator for DB2 for z/OS servers
Before you can use the IBM Data Server Driver for JDBC and SQLJ connection
concentrator and workload balancing functions with WebSphere Application Server
and DB2 for z/OS servers, you need to configure these functions.
Server requirements:
v WLM for z/OS
v DB2 UDB for OS/390 and z/OS Version 7 or later, set up for data sharing
The default values for special registers in all members of the data sharing group
must be the same. The reason for this is that when the IBM Data Server Driver
for JDBC and SQLJ balances the loads on each member of the data sharing
group, it moves the user’s connection from one member to another. If the user
has set any special register values on the original data sharing member, the
driver resets all special registers to their default values and then applies any
special register changes to the new member. However, the IBM Data Server
Driver for JDBC and SQLJ has no way to determine the default values for all
members. If two members have different default values, the result of an SQL
statement can differ, depending on which member the statement runs on.
Client requirements:
v IBM Data Server Driver for JDBC and SQLJ at the FixPak 10 level
v WebSphere Application Server, Version 5.1 or later
The following procedure is an example of enabling the IBM Data Server Driver for
JDBC and SQLJ connection concentrator and workload balancing functions with
WebSphere Application Server. The values that are specified are not intended to be
recommended values. You need to determine values based on factors like these:
v Availability of system resources
v The number of physical connections available
v The desired ratio of connection objects to transport objects
1. Verify that the IBM Data Server Driver for JDBC and SQLJ is at the correct level
to support the connection concentrator and workload balancing by following
these steps:
a. Issue the following command in UNIX System Services
java com.ibm.db2.jcc.DB2Jcc -version
b. Find a line in the output like this, and check that nnn is 2.7 or later.
[jcc] Driver: IBM Data Server Driver for JDBC and SQLJ Architecture nnn xxx
2. Set IBM Data Server Driver for JDBC and SQLJ configuration properties to
enable the connection concentrator or workload balancing for all DataSource or
Connection instances that are created under the driver. Set the configuration
properties in a DB2JccConfiguration.properties file by following these steps:
a. Create a DB2JccConfiguration.properties file or edit the existing
DB2JccConfiguration.properties file.
b. Set the following configuration properties:
476 Application Programming Guide and Reference for Java
™
To Next Page
Loading...
Need help?
General