BDNA Discover Publish version 7.7.0 with 201605 Sequence
BDNA_WEBSPHERE_CONN_POOLS - WebSphere App Server Connection Pools

Legend:
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
CONN_POOL_ID number 22 WebSphere App Server Connection Pools Module Id
WEBSPHERE_INSTANCE_ID number 22  √  null
BDNA_WEBSPHERE_INSTANCES.WEBSPHERE_INSTANCE_ID FKM0_BDNAWEBSPHERECO R
WebSphere Application Server Instance Id
OPERATINGSYSTEM_ID number 22  √  null
BDNA_ALL_OS.OPERATINGSYSTEM_ID FKM1_BDNAWEBSPHERECO R
Operating Systems Id
CONN_POOL_NAME varchar2 4000  √  null Connection Pool Name
POOL_SIZE number 22  √  null Connection Pool Size
FREE_POOL_SIZE number 22  √  null No. of free connections in the pool
PCT_USED number 22  √  null Avg. percent of the pool that is in use
CREATE_COUNT number 22  √  null Total no. of connections created
CLOSE_COUNT number 22  √  null Total no. of connections closed
WAIT_TIME number 22  √  null Avg. waiting time until a connection is granted (ms)
USE_TIME number 22  √  null Avg. time that a connection is used (ms)
WTG_THREAD_COUNT number 22  √  null Avg. no. of threads concurrently waiting for a connection
FAULT_COUNT number 22  √  null No. of connection timeouts in the pool
RETURN_COUNT number 22  √  null Total no. of connections returned to the pool
ALLOCATE_COUNT number 22  √  null Total no. of connections allocated
PCT_MAXED number 22  √  null Avg. percent of the time all connections are in use
INVENTORY_ID number 22 -1
BDNA_INVENTORY_INFO.INVENTORY_ID BDNAWEBSPHERECONN_INVENTORY_ID R
BDNA_ALL_OS.INVENTORY_ID FKM1_BDNAWEBSPHERECO R
BDNA_WEBSPHERE_INSTANCES.INVENTORY_ID FKM0_BDNAWEBSPHERECO R
Inventory Id

Analyzed at Sat Mar 05 19:14 PST 2016

Indexes:
Column(s) Type Sort Constraint Name
CONN_POOL_ID + INVENTORY_ID Primary key Asc/Asc PK_BDNAWEBSPHERECONNPOOLS

Close relationships  within of separation:
Confidential and Proprietary to BDNA