Find the alternate index of the VSAM file

Manigandan Aravindhan · New User Joined: 09 Oct 2007 Posts: 81 Location: India

Dear Friends,
Is there any way to find the alternate index of the VSAM file?

For example:
For X vsam file i need to search how many alternate index were there.

Thanks in Advance

expat · Posted: Wed Feb 18, 2009 3:42 pm

IDCAMS LISTCAT

Click HERE to read the IDCAMS manual.

Manigandan Aravindhan · New User Joined: 09 Oct 2007 Posts: 81 Location: India

Thanks expat..

But LISTCAT just displays the count of data and index for the given VSAM..but the alternate index of the VSAM were not shown....

But if we execute LISTCAT for the AIX file it shows some information about the alternate index file.....

Is there any way to find is there any AIX file for the VSAM...?

expat · Posted: Wed Feb 18, 2009 4:25 pm

Post what you coded

Manigandan Aravindhan · New User Joined: 09 Oct 2007 Posts: 81 Location: India

Thanks expat for your reply...

Please find the code below:

/* IDCAMS COMMAND */
LISTCAT ENTRIES(HLQ.M11M.XX.XX.C8888)

expat · Posted: Wed Feb 18, 2009 4:55 pm

Put ALL at the end of the command and in the output you will find an area labelled ASSOCIATIONS. In that area you will see if there is an AIX associated to the CLUSTER.

Manigandan Aravindhan · New User Joined: 09 Oct 2007 Posts: 81 Location: India

Its working...Thanks a lot Expat.....