Page 1 of 1
Tablespace-VSAM datasets
Posted:
Tue Feb 28, 2012 2:41 pm
by raghav08
Hello,
Please assist me to find the list of VSAM datasets associated with DB2 Tablespace, can I find this in any catalog SYSIBM tables?
Thanks.
Re: Tablespace-VSAM datasets
Posted:
Wed Feb 29, 2012 2:23 am
by NicC
Have you tried looking? There is a system table called SYSTABLES - that may be what you want.
Re: Tablespace-VSAM datasets
Posted:
Wed Feb 29, 2012 2:59 pm
by GuyC
select vcatname || '.DSNDBC.' || DBNAME || '.' || TSNAME || '.' || iprefix || '*.*'
from sysibm.systablepart
the * depend on CLONE and PARTITION / DSNUM
Re: Tablespace-VSAM datasets
Posted:
Thu Mar 01, 2012 2:12 pm
by raghav08
Thank you for providing the query, its working fine to idenfify the VSAM datasets