BDNA Discover Publish version 7.7.0 with 201605 Sequence
BDNA_DB2_TS - IBM DB2 Tablespaces

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
DB2TABLESPACE_LABEL varchar2 256  √  null Tablespace Name
CREATETIME varchar2 256  √  null Creation Time
DEFINER varchar2 256  √  null Definer
REMARKS varchar2 4000  √  null Remarks
DATATYPE varchar2 256  √  null Tablespace Data Type
TABLESPACEID number 22  √  null Tablespace Id
TBSPCTYPE varchar2 256  √  null Tablespace Management
DBPGNAME varchar2 256  √  null Database Partition Group Name
DROPRECOVERY varchar2 256  √  null Drop Recovery
NUMCONTAINERS number 22  √  null Number of Containers
PREFETCHSIZE number 22  √  null Prefetch Size
PAGESIZE number 22  √  null Page Size
TOTALPAGES number 22  √  null Total Pages
USEABLEPAGES number 22  √  null Useable Pages
USEDPAGES number 22  √  null Used Pages
USEDSIZE number 22  √  null Used Size (bytes)
EXTENTSIZE number 22  √  null Extent Size
OPERATINGSYSTEM_ID number 22  √  null
BDNA_ALL_OS.OPERATINGSYSTEM_ID FKM0_BDNA_DB2_TS R
Operating Systems Id
DB2INSTANCE_ID number 22  √  null
BDNA_DB2_INSTANCES.DB2INSTANCE_ID FKM1_BDNA_DB2_TS R
DB2 Instance Id
DB2_ID number 22  √  null
BDNA_DB2_DBS.DB2_ID FKM2_BDNA_DB2_TS R
DB2 Id
DB2TABLESPACE_ID number 22 DB2 Tablespace Id
INVENTORY_ID number 22 -1
BDNA_INVENTORY_INFO.INVENTORY_ID BDNA_DB2_TS0_INVENTORY_ID R
BDNA_DB2_DBS.INVENTORY_ID FKM2_BDNA_DB2_TS R
BDNA_DB2_INSTANCES.INVENTORY_ID FKM1_BDNA_DB2_TS R
BDNA_ALL_OS.INVENTORY_ID FKM0_BDNA_DB2_TS R
Inventory Id

Analyzed at Sat Mar 05 19:14 PST 2016

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

Close relationships  within of separation:
Confidential and Proprietary to BDNA