BDNA Discover Publish version 7.7.1 with 201612 Sequence
BDNA_DB2_LICMLIST - IBM db2licm Command Output Product List

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 BDNADB2LICMLIST_OST R
OS Type
PRODUCT_NAME varchar2 256  √  null Product_name
LICENSE_TYPE varchar2 256  √  null License_type
EXPIRY_DATE varchar2 256  √  null Expiry_date
PRODUCT_IDENTIFIER varchar2 256  √  null Product_identifier
VERSION_INFORMATION varchar2 256  √  null Version_information
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
DB2LICMLIST_ID number 22 DB2LicmList id
OPERATINGSYSTEM_ID number 22  √  null
BDNA_INV_CATALOG_MAP.INV_ASSET_ID FKM0_BDNADB2LICMLIST R
Operating Systems Id
DB2INSTALLATION_ID number 22  √  null
BDNA_DB2_INSTALLS.DB2INSTALLATION_ID FKM2_BDNADB2LICMLIST R
BDNA_INV_CATALOG_MAP.INV_ASSET_ID FKM1_BDNADB2LICMLIST R
DB2 Installation Id
INVENTORY_ID number 22 -1
BDNA_INVENTORY_INFO.INVENTORY_ID BDNADB2LICMLIST1_INVENTORY_ID R
BDNA_DB2_INSTALLS.INVENTORY_ID FKM2_BDNADB2LICMLIST R
BDNA_INV_CATALOG_MAP.INVENTORY_ID FKM0_BDNADB2LICMLIST R
Inventory Id

Analyzed at Fri Oct 21 21:10 PDT 2016

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

Close relationships  within of separation:
Confidential and Proprietary to BDNA