The following table directs you to the PI table explanation that contains SQL for Design tasks related to database design objects:
|
If You Want To |
See |
|---|---|
|
Join Technical Design to the model that contains it |
TECHNICAL_DESIGN |
|
Select the DASD volumes defined for a storage group |
STG_DVOL_USAGE |
|
Select the DASD volume on which a data set resides |
DASD_VOLUME |
|
Select the DASD volumes on which a specific tablespace resides |
DASD_VOL_USAGE |
|
Select the data set that an indexspace resides on |
DATASET_INDEX |
|
Select the data sets that a tablespace resides on |
DATASET_TBLSP |
|
Select the default storage group for a database |
DATA_BASE |
|
Select the default storage group for databases within a Technical Design |
STORAGE_GROUP |
|
Select the default storage group for indexspaces |
STORAGE_GROUP |
|
Select the default storage group for tablespaces |
STORAGE_GROUP |
|
Select the indexspace datasets that are held by a storage group |
DATASET_INDEX |
|
Select the indices contained in a storage group |
DATA_STORE_INDEX |
|
Select the indices grouped within a database |
DATA_STORE_INDEX |
|
Select the tablespaces contained in a storage group |
DATA_STORE_TBLSP |
|
Select the tablespace datasets that are held by a storage group |
DATASET_TBLSP |
|
Select the tablespaces grouped within a database |
DATA_STORE_TBLSP |
|
Select all uses of databases within a Technical Design |
DATA_BASE_USAGE |
|
Copyright © 2013 CA.
All rights reserved.
|
|