BDNA Discover Publish version 7.7.1 with 201612 Sequence
BDNA_WEBSPHERE_TRANS - WebSphere App Server Transactions

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
TRANS_ID number 22 IBM WebSphere App Server Transcation Module Id
WEBSPHERE_INSTANCE_ID number 22  √  null
BDNA_WEBSPHERE_INSTANCES.WEBSPHERE_INSTANCE_ID FKM0_BDNAWEBSPHERETR R
WebSphere Application Server Instance Id
OPERATINGSYSTEM_ID number 22  √  null
BDNA_ALL_OS.OPERATINGSYSTEM_ID FKM1_BDNAWEBSPHERETR R
Operating Systems Id
ACTIVE_COUNT number 22  √  null No. of concurrently active global transactions
COMMITTED_COUNT number 22  √  null No. of global transactions committed
ROLLEDBACK_COUNT number 22  √  null No. of global transactions rolled back
GLOBALTIMEOUT_COUNT number 22  √  null No. of timed out global transactions
GLOBALTRAN_TIME number 22  √  null Avg. duration of global transactions (ms)
GLOBALCOMMIT_TIME number 22  √  null Avg. duration of commit for global transactions (ms)
LOCALACTIVE_COUNT number 22  √  null No. of concurrently active local transactions
LOCALCOMMITTED_COUNT number 22  √  null No. of local transactions committed
LOCALROLLEDBACK_COUNT number 22  √  null No. of local transactions rolled back
LOCALTIMEOUT_COUNT number 22  √  null No. of timed out local transactions
LOCALTRAN_TIME number 22  √  null Avg. duration of local transactions (ms)
LOCALCOMMIT_TIME number 22  √  null Avg. duration of commit for local transactions (ms)
INVENTORY_ID number 22 -1
BDNA_INVENTORY_INFO.INVENTORY_ID BDNAWEBSPHERETRAN_INVENTORY_ID R
BDNA_ALL_OS.INVENTORY_ID FKM1_BDNAWEBSPHERETR R
BDNA_WEBSPHERE_INSTANCES.INVENTORY_ID FKM0_BDNAWEBSPHERETR R
Inventory Id

Analyzed at Fri Oct 21 21:10 PDT 2016

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

Close relationships  within of separation:
Confidential and Proprietary to BDNA