Connection pool custom properties
Use the custom properties page to define the following connection pool custom properties:
- defaultConnectionTypeOverride
- failureNotificationActionCode
- failureThreshold
- globalConnectionTypeOverride
- maxNumberOfMCsAllowableInThread
defaultConnectionTypeOverride
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. Enable 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 we do not want shared connections, set this property to unshared.
Information Value Data Type String Value unshared, shared
(ZOS) 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:
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:
Information Value Data Type Integer Value 1, 2, 3
- 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.
(ZOS) 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.
Resource exception counters are not shared between resources.
Resource exceptions must be consecutive to reach failure threshold.
Information Value Data Type Integer Value > 0
globalConnectionTypeOverride
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 we 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 we specify values for both the defaultConnectionTypeOverride and the globalConnectionTypeOverride properties, only the value specified for the globalConnectionTypeOverride property is used to determine connection sharing type.
Information Value Data Type String Value unshared, shared
maxNumberOfMCsAllowableInThread
The maxNumberOfMCsAllowableInThread property assists in detecting higher than expected usage of a number of managed connections on a thread.
Information Value Data Type Integer Value 1-30 For more information on how these properties are used, see the topic, Tuning connection pools.
Tune connection pools