BDNA Discover Publish version 7.7.0 with 201605 Sequence
BDNA_IBM_LPARS - IBM Logical Partitions

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
LPAR_ID number 22
BDNA_ALL_PARTITIONS.PARTITION_ID FKM0_BDNA_IBM_LPARS R
IBM Logical Partition Id
LPAR_LABEL varchar2 1024  √  null LPAR Label
LPAR_NAME varchar2 4000  √  null LPAR Node Name
LPAR_NUMBER number 22  √  null LPAR Number
LPAR_TYPE varchar2 4000  √  null LPAR Type
LPAR_TYPE_CAT varchar2 4000  √  null LPAR Type Category
PARTITION_IDENTIFIER varchar2 4000  √  null Partition Identifier
LPAR_INTERNAL_NAME varchar2 4000  √  null Logical Partition Internal Name
LPAR_PROC_MODE varchar2 4000  √  null LPAR Processor Mode
LPAR_MAX_PHYSCPUS number 22  √  null LPAR system Maximum number of physical CPUs
LPAR_ENTITLED_CAP varchar2 4000  √  null LPAR Entitled Processing Capacity
LPAR_MAXMEM_MB number 22  √  null LPAR Maximum Memory (MB)
LPAR_MINMEM_MB number 22  √  null LPAR Minimum Memory (MB)
LPAR_SHAREDPOOL_ID varchar2 4000  √  null LPAR Shared Pool Identifier
LPAR_ACTIVE_CPUS number 22  √  null Number of Active CPUs in LPAR Shared Pool
LPAR_MAXPOOL_CAP number 22  √  null Maximum Capacity of LPAR Shared Pool
LPAR_ENTPOOL_CAP number 22  √  null Entitled Capacity of LPAR Shared Pool
INVENTORY_ID number 22 -1
BDNA_ALL_PARTITIONS.INVENTORY_ID FKM0_BDNA_IBM_LPARS R
BDNA_INVENTORY_INFO.INVENTORY_ID BDNA_IBM_LPARS0_INVENTORY_ID R
Inventory Id

Analyzed at Sat Mar 05 19:14 PST 2016

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

Close relationships  within of separation:
Confidential and Proprietary to BDNA