MVSFORUMS.com

[sumithar]

Excuse me for asking such a basic question...

When I create an AIX and path for a VSAM dataset does the path have a copy of the base data but sorted in the order of the AIX? I did fair bit of googling but most sites just say that for each AIX you need to define a Path w/o specifying what exactly is in the Path.

When I browse the Path I can indeed see that the same records exist but in the order of the AIX.

[kolusu]

sumithar,

In simple terms Path is nothing but an alias to AIX. when you refer to the path , it is actually referring to the AIX as well the base cluster associated with it. If you did a LISTCAT ALL ENTRY('Your Path Name') and in the output look for "Associations" and you will notice that the PATH has related all component parts of the alternate index cluster and the base record cluster.

Here is the actual definition of the Path from "VSAM Demystified"

Before you access a KSDS or ESDS through an alternate index, a path must be defined in the catalog. A path is the means by which a base cluster is accessed through its alternate indexes. A path is defined and named by using the IDCAMS DEFINE PATH command. At least one path must be defined for each of the alternate indexes through which they access the base cluster. The path name refers to the base cluster and alternate index pair. When a program opens a path for processing, both the base cluster and the alternate index are opened. A base cluster plus all its AIX is called a sphere.
_________________
Kolusu
www.linkedin.com/in/kolusu

[sumithar]

Thank you, that clears it up well. I did download VSAM DeMystified but evidently didn't read it properly.
So just to confirm, if I choose to view the Path via the File Manager product, say, I am seeing a "view" of the base data that has been reordered on the fly in the sequence of the AIX.