Previous Topic: DASD_VOL_USAGE (DASD Volume Usage)Next Topic: STG_DVOL_USAGE (Storage Group/ DASD Volume Usage)


Task

Select the DASD volumes on which tablespace ABCD resides.

DATA_STORE_TBLSP.NAME = 'ABCD'
AND DATASET_TBLSP.DATA_STORE_ID = DATA_STORE_TBLSP.ID
AND DASD_VOL_USAGE.DATASET_ID = DATASET_TBLSP.ID
AND DASD_VOL_USAGE.DASD_VOLUME_ID = DASD_VOLUME.ID