APAR status
Closed as program error.
Error description
Datasource utilization is incorrectly logged in the logs: 2024-04-26 10:53:23 ERROR :DataSource connection limit: 160 percent of the pool is in use for the data source MyThinJDBCDataSource_XA for profile fmserver 2024-04-26 10:53:39 INFO :The content of the pools are 2024-04-26 10:53:39 INFO :/opt/WebSphere/AppServer/profiles/profilename/bin/wsadmin.sh -lang jython -c "AdminControl.invoke(AdminControl.queryNames(*:type=D ataSource,name=MERC_FM_ThinJDBCDataSource_XA,node=mynode,Serv er=fmserver,*),showPoolContents)" 2024-04-26 10:54:02 INFO :WASX7209I: Connected to process "dmgr" on node dmgr using SOAP connector; The type of process is: DeploymentManager u PoolManager name:jdbc/MyThinJDBCDataSource_XA PoolManager object:1212454161 Total number of connections: 7 (max/min 160/3, reap/unused/aged 180/600/0, connectiontimeout/purge 180/EntirePool) (testConnection/inteval false/0, stuck timer/time/threshold 0/0/0, surge time/connections 0/-1) (pool paused false, prePopulate alternate false, resourceFailBackEnabled true, isAlternateResourceEnabled false, disableDatasourceFailoverAlarm false, startFailBack false) (isPartialResourceAdapterFailoverSupportEnabled false, isAlteranteResourcePoolManager false, resourceAvailabilityTestRetryInterval 10, currentInusePool null, currentMode 100, alternate jndiName null) Shared Connection information (shared partitions 320) No shared connections Free Connection information (free distribution table/partitions 80/1) (0)(0)MCWrapper id 1c7c33f4 Managed connection WSRdbManagedConnectionImpl@3c4fce0f State:STATE_ACTIVE_FREE (0)(0)MCWrapper id 7edfc8fb Managed connection WSRdbManagedConnectionImpl@22a6d5a State:STATE_ACTIVE_FREE (0)(0)MCWrapper id c9f698c7 Managed connection WSRdbManagedConnectionImpl@f30cbdb0 State:STATE_ACTIVE_FREE (0)(0)MCWrapper id e52cbe80 Managed connection WSRdbManagedConnectionImpl@b7ba0b9 State:STATE_ACTIVE_FREE (0)(0)MCWrapper id 5877244f Managed connection WSRdbManagedConnectionImpl@4f4a9d9e State:STATE_ACTIVE_FREE (0)(0)MCWrapper id 543b844a Managed connection WSRdbManagedConnectionImpl@fdf9702 State:STATE_ACTIVE_FREE (0)(0)MCWrapper id 2704a846 Managed connection WSRdbManagedConnectionImpl@3e262adb State:STATE_ACTIVE_FREE Total number of connection in free pool: 7 UnShared Connection information No unshared connections
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: All users of IBM WebSphere Application * * Server * * using Data Sources * **************************************************************** * PROBLEM DESCRIPTION: Datasource utilization is incorrectly * * logged in the logs * **************************************************************** * RECOMMENDATION: * **************************************************************** When the connection was aborted, PMI data was not cleared correctly, leading to incorrect PMI data for connection pool utilization.
Problem conclusion
The fix for this APAR is targeted for inclusion in fix pack 9.0.5.21. For more information, see 'Recommended Updates for WebSphere Application Server': https://www.ibm.com/support/pages/node/715553
Temporary fix
Comments
APAR Information
APAR number
PH61221
Reported component name
WEBS APP SERV N
Reported component ID
5724H8800
Reported release
900
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2024-05-03
Closed date
2024-07-16
Last modified date
2024-07-16
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Fixed component name
WEBS APP SERV N
Fixed component ID
5724H8800
Applicable component levels
[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSEQTP","label":"WebSphere Application Server"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.0","Line of Business":{"code":"LOB67","label":"IT Automation \u0026 App Modernization"}}]
Document Information
Modified date:
16 July 2024