BDNA Discover Publish version 7.7.0 with 201605 Sequence
BDNA_DB2_INSTANCES - IBM DB2 Instances

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
DB2INSTANCE_LABEL varchar2 256  √  null Instance Name
VERSION varchar2 256  √  null DB2 Version
INSTANCEHOME varchar2 256  √  null Instance Home
ISRUNNING varchar2 256  √  null Instance Running
PORTINFO varchar2 4000  √  null Instance Port Info
INSTALLATIONHOME varchar2 256  √  null Installation Home
OPERATINGSYSTEM_ID number 22  √  null
BDNA_ALL_OS.OPERATINGSYSTEM_ID FKM0_BDNADB2INSTANCE R
Operating Systems Id
DB2INSTANCE_ID number 22
BDNA_DB2_DBS.DB2INSTANCE_ID FKM1_BDNA_DB2_DBS R
BDNA_DB2_SCHEMAS.DB2INSTANCE_ID FKM1_BDNADB2SCHEMAS R
BDNA_DB2_TS.DB2INSTANCE_ID FKM1_BDNA_DB2_TS R
BDNA_INV_CATALOG_MAP.INV_ASSET_ID FKM1_BDNADB2INSTANCE R
DB2 Instance Id
INVENTORY_ID number 22 -1
BDNA_DB2_DBS.INVENTORY_ID FKM1_BDNA_DB2_DBS R
BDNA_DB2_SCHEMAS.INVENTORY_ID FKM1_BDNADB2SCHEMAS R
BDNA_DB2_TS.INVENTORY_ID FKM1_BDNA_DB2_TS R
BDNA_INVENTORY_INFO.INVENTORY_ID BDNADB2INSTANCES0_INVENTORY_ID R
BDNA_INV_CATALOG_MAP.INVENTORY_ID FKM1_BDNADB2INSTANCE R
BDNA_ALL_OS.INVENTORY_ID FKM0_BDNADB2INSTANCE R
Inventory Id

Analyzed at Sat Mar 05 19:14 PST 2016

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

Close relationships  within of separation:
Confidential and Proprietary to BDNA