You can use the custom properties page to define the following
connection pool custom properties:
defaultConnectionTypeOverride
You
can use the defaultConnectionTypeOverride connection pool custom property
for a particular connection factory or data source to control connection
sharing.
The defaultConnectionTypeOverride property changes
the default sharing value for a connection pool. This property enables
you to control connection sharing for direct look-ups. If resource
references are configured for a data source or connection factory
they take precedence over this property and the resource reference
settings are used. For example, if an application is doing direct
look-ups, and you do not want unshared connections, set this property
to unshared.
Information |
Value |
Data Type |
String |
Value |
unshared, shared |
failureNotificationActionCode
The
failureNotificationActionCode property is used to enable the notification
feature. This property must be set to one of the valid integer values
specified. The notification feature is disabled if the property is
not set to one of the following values:
Information |
Value |
Data Type |
Integer |
Value |
1, 2, 3 |
Notification is sent to the z/OS runtime when a particular
connection factory or data source has reached a specified or default
failure threshold value. The failure notification includes a configured
action code that determines how the runtime responds to the failure
notification. Action code descriptions are as follows:
- 1 = A BBOJ0130I message that is output to hardcopy indicates
that this resource became unavailable. When the resource becomes
available, a BBOJ0131I message is output to hardcopy indicating that
the resource is once again available. No further automated action
is taken. Action code 1 is designed to provide a notification to WebSphere® Application Server
administrators so that manual or automated mitigation actions can
be configured outside of the application server.
- 2 = A pause listeners command is issued to the server,
preventing the server from receiving new incoming work. When the
resource becomes available, a resume listeners command is issued to
allow the server to once again receive incoming work. When combined
with a front end router that supports high availability, such as a
proxy server or an on-demand router, work for this server is routed
to other servers in the cluster.
- 3 = All applications with locally installed modules that
use this resource are stopped on this server. When the resource becomes
available, these applications are restarted. The application is stopped
only on the server that experienced the resource failure, therefore,
if the application is installed in a cluster it remains started on
other servers in the cluster.
failureThreshold
The
failureThreshold property is only read if the failureNotificationActionCode
property is set to valid value. If notification is enabled and the
failureThreshold property is not set or is set to an invalid number,
the default value of 5 is used. The integer value specified for
the failureThreshold is the number of consecutive resource exceptions
that must occur for a particular resource before notification is sent.
For example, if the failureThreshold property is set to 5 for data
source B, data source B must get 5 consecutive resource exceptions
when attempting to establish a connection before the failure notification
is sent. The notification is sent after the sixth attempt to establish
the connection.
Attention: Resource exception counters
are not shared between resources.
Attention: Resource
exceptions must be consecutive to reach failure threshold.
Information |
Value |
Data Type |
Integer |
Value |
> 0 |
globalConnectionTypeOverride
You
can use the globalConnectionTypeOverride connection pool custom property
to globally control connection sharing for a particular connection
factory or data source.
The value specified for the globalConnectionTypeOverride
custom property takes precedence over all of the other connection
sharing settings. For example, if you set this property to unshared,
all connection requests are unshared for both direct look-ups and
resource reference lookups.
This property provides you with
a quick way to test the consequences of moving all connections for
a particular data source or connection factory to unshared or shared
without changing the resource reference settings.
If you specify
values for both the defaultConnectionTypeOverride and the globalConnectionTypeOverride
properties, only the value that is specified for the globalConnectionTypeOverride
property is used to determine connection sharing type.
Information |
Value |
Data Type |
String |
Value |
unshared, shared |
For more information on how these properties are
used, see the topic, Tuning connection pools.