PH61221: DATASOURCE UTILIZATION IS INCORRECTLY LOGGED IN THE LOGS

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 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