Previous Topic: Internal Schema ObjectsNext Topic: TECHNICAL_DESIGN


Design Tasks Related to Internal Schema Definition Objects

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