Retrieving catalog information about Db2 storage groups
The SYSIBM.SYSSTOGROUP and SYSIBM.SYSVOLUMES tables contain information about Db2 storage groups and the volumes in those storage groups.
Procedure
Query the SYSIBM.SYSSTOGROUP and SYSIBM.SYSVOLUMES tables.
The following query shows what volumes are in a Db2 storage group, how much space
is used, and when that space was last calculated.
SELECT SGNAME,VOLID,SPACE,SPCDATE
FROM SYSIBM.SYSVOLUMES,SYSIBM.SYSSTOGROUP
WHERE SGNAME=NAME
ORDER BY SGNAME;