Page 1 of 1

Tablespace-VSAM datasets

PostPosted: 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

PostPosted: 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

PostPosted: 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

PostPosted: Thu Mar 01, 2012 2:12 pm
by raghav08
Thank you for providing the query, its working fine to idenfify the VSAM datasets