IBM Mainframe Forum

by **raghav08** » Tue Feb 28, 2012 2:41 pm

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.

by **NicC** » Wed Feb 29, 2012 2:23 am

Have you tried looking? There is a system table called SYSTABLES - that may be what you want.

by **GuyC** » Wed Feb 29, 2012 2:59 pm

select vcatname || '.DSNDBC.' || DBNAME || '.' || TSNAME || '.' || iprefix || '*.*'
from sysibm.systablepart

the * depend on CLONE and PARTITION / DSNUM

by **raghav08** » Thu Mar 01, 2012 2:12 pm

Thank you for providing the query, its working fine to idenfify the VSAM datasets

Tablespace-VSAM datasets