BDNA Discover Publish version 7.7.0 with 201605 Sequence
BDNA_DB2_FEATURES - IBM DB2 Features

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
OPERATINGSYSTEM_LABEL varchar2 256  √  null Hostname
OPERATINGSYSTEM_TYPE number 22  √  null
BDNA_TYPES.TYPE_ID BDNADB2FEATURES_OST R
OS Type
FEATURES varchar2 256  √  null Features
ISLICENSED varchar2 256  √  null isLicensed
DB2INSTALLATION_LABEL varchar2 1024  √  null DB2 Installation Label
DB2INSTALLATIONHOME varchar2 4000  √  null DB2 Installation Home
DB2INSTALLATIONVERSION varchar2 4000  √  null DB2 Installation Version
OSCOMPUTERNAME varchar2 256  √  null OS Computer Name
FEATURES_ID number 22 Features id
OPERATINGSYSTEM_ID number 22  √  null
BDNA_ALL_OS.OPERATINGSYSTEM_ID FKM0_BDNADB2FEATURES R
Operating Systems Id
DB2INSTALLATION_ID number 22  √  null
BDNA_DB2_INSTALLS.DB2INSTALLATION_ID FKM2_BDNADB2FEATURES R
BDNA_INV_CATALOG_MAP.INV_ASSET_ID FKM1_BDNADB2FEATURES R
DB2 Installation Id
INVENTORY_ID number 22 -1
BDNA_INVENTORY_INFO.INVENTORY_ID BDNADB2FEATURES1_INVENTORY_ID R
BDNA_DB2_INSTALLS.INVENTORY_ID FKM2_BDNADB2FEATURES R
BDNA_INV_CATALOG_MAP.INVENTORY_ID FKM1_BDNADB2FEATURES R
BDNA_ALL_OS.INVENTORY_ID FKM0_BDNADB2FEATURES R
Inventory Id

Analyzed at Sat Mar 05 19:14 PST 2016

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

Close relationships  within of separation:
Confidential and Proprietary to BDNA