Tablespace-VSAM datasets



IBM's flagship relational database management system

Tablespace-VSAM datasets

Postby 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.
raghav08
 
Posts: 18
Joined: Wed Oct 27, 2010 5:10 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Tablespace-VSAM datasets

Postby 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.
The problem I have is that people can explain things quickly but I can only comprehend slowly.
Regards
Nic
NicC
Global moderator
 
Posts: 3025
Joined: Sun Jul 04, 2010 12:13 am
Location: Pushing up the daisies (almost)
Has thanked: 4 times
Been thanked: 136 times

Re: Tablespace-VSAM datasets

Postby GuyC » Wed Feb 29, 2012 2:59 pm

select vcatname || '.DSNDBC.' || DBNAME || '.' || TSNAME || '.' || iprefix || '*.*'
from sysibm.systablepart
the * depend on CLONE and PARTITION / DSNUM
I can explain it to you, but i can not understand it for you.
GuyC
 
Posts: 315
Joined: Tue Aug 11, 2009 3:23 pm
Has thanked: 1 time
Been thanked: 4 times

Re: Tablespace-VSAM datasets

Postby raghav08 » Thu Mar 01, 2012 2:12 pm

Thank you for providing the query, its working fine to idenfify the VSAM datasets
raghav08
 
Posts: 18
Joined: Wed Oct 27, 2010 5:10 pm
Has thanked: 0 time
Been thanked: 0 time


Return to DB2