do "select  volume_name, stgpool_name from VOLUMES where stgpool_name='xxx'
ORDER BY VOLUME_name"
all info can be found
in "select * from SYSCAT.tables", or "seelect * from SYSCAT.columns".".
Sincerely,
Dmitri Chilovich
ADSM Solutions
__________________________________
LN: Dmitri Chilovich/Raleigh/Contr/IBM
E-mail: dmitrich AT us.ibm DOT com
Office phone: 847-240 4654, internal 4654
Pager: 800-946 4646 id 1473134
ADSM USF: Dept.  XVCE, Mngr. Mrs Jane Harris/Raleigh/IBM
IBM Schaumburg, 231 Martingale Rd, IL 60173
____________________________________________________
Private Notes: Please, reply to dima_chilovitch AT hotmail DOT com