Underlying VSAM file of a DB2 table

sprikitik · Posted: Tue Nov 03, 2009 1:39 pm

Hi!

Can anybody tell me how to identify filename of the underlying vsam file of a db2 table?

Thanks,
Chris

LearningDb2 · New User Joined: 19 Jun 2009 Posts: 40 Location: India

hi,

names of the VSAM files usually depends on the VCAT name that u have used during the creation of storage groups.It is like---

vcatname.dsndbc.dbname.tsname.**

dsndbc is for the cluster and dsndbd is for the corresponding data..
if u see 2 datasets then 1 is for indexspace and the other is for tablespace created in that database.

sprikitik · Posted: Tue Nov 03, 2009 2:24 pm

Thanks LearningDb2, this is exactly what im looking for..