How can i identify it is KSDS or ESDS

raman.k · New User Joined: 26 Feb 2007 Posts: 24 Location: chennai

Hi
I have one vsam file like A.B.C.D
Now how can i identify it is KSDS or ESDS?

Please tell me

murmohk1 · Posted: Wed Mar 28, 2007 3:36 pm

KSDS has two components (.DATA and .INDEX) and ESDS has only one componenet (.DATA). If index component present, it is a KSDS cluster.

expat · Posted: Wed Mar 28, 2007 3:52 pm

LISTCAT might be a good place to start

murmohk1 · Posted: Wed Mar 28, 2007 3:57 pm

Expat,

expat · Posted: Wed Mar 28, 2007 4:26 pm

Does an ESDS have an INDEX in its associations ?

The benefit of using LISTCAT is that the seperate portions of a cluster can be called anything you want them to be called

I can define a cluster as below,
CLST name = HLQ.PROJECT.FILE001
DATA name = HLQ.PROJECT.FILE002
INDX name = HLQ.PROJECT.FILE003

There is no visible corellation between the filenames. Using LISTCAT the associations are ALWAYS shown.

And - looking at the file attributes in LISTCAT the output will show if it is an INDEXED file or not.

Try a few tests and see what you can see.

However, once a VSAM file is migrated via HSM the whole picture changes. The catalog entries for each component are then shown as NONVSAM files, which in effect they are. They are PS file copies of the portions of the KSDS, or ESDS, held on tape via HSM.

Confusing, isn't it ?

murmohk1 · Posted: Wed Mar 28, 2007 4:34 pm

Expat,

You highlighted a very good point. Thanks.

But, I just found out one more thing with listcat for one of my ESDS cluster

expat · Posted: Wed Mar 28, 2007 4:45 pm

Is it an ESDS or an RRDS ?

expat · Posted: Wed Mar 28, 2007 4:49 pm

Just ran a test by defining an ESDS with KEYS parameter and got the same result as you showed.

I'd guess that someone took another IDCAMS DEFINE for a KSDS changed it from INDEXED to NONINDEXED and forgot to remove the KEYS parameter.