Connection pool custom properties

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 shared connections, set this property to unshared.

Information Value
Data Type String
Value unshared, shared
[z/OS]

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.
[z/OS]

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.

Important:
  • To set this property correctly, follow these navigation details using the administrative console.

    Click Resources > JDBC > Data sources > Select the data source > Under Additional Properties, click Connection pool properties > Under Additional Properties, click Connection pool custom properties > click New to add globalConnectionTypeOverride > OR click > globalConnectionTypeOverride to update its current value as appropriate.

  • This property must be set in the Connection pool custom properties and NOT the general Custom properties on the data source.
  • 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 the 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.