MVSFORUMS.com

kavya · Beginner Joined: 22 Sep 2005 Posts: 12 Topics: 8

hi everyone i want to create alternate index i have done build index and if i am not creating path will it cause any problem,.....

Phantom · Posted: Tue Sep 27, 2005 7:28 am Post subject:

Kavya,

Path is the logical entity which connects your primary and alternate indexes. When you build the index, the alternate index dataset gets populated with the key values but during program execution the path is the only way by which the program relates an alternate index with primary index. So, if you don't create a path, you cannot refer a VSAM using alternate key. You must use only Primary key to access any record.

Thanks,
Phantom

kolusu · Posted: Tue Sep 27, 2005 7:29 am Post subject:

Kavya,

If you don't plan to use the alternate index then there is absolutely no problem if you don't create the path. Then the question arises as why you even created an alternate index.

Before accessing a cluster through an alternate index, a path must be defined. A path is the mean by which a base cluster is accessed through its alternate indices. At least one path must be defined for each of the alternate indices through which the base cluster is to be accessed. 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 AIXs is called a sphere.

Hope this helps...

Cheers

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

kavya · Beginner Joined: 22 Sep 2005 Posts: 12 Topics: 8

hi if i use relate while defining alternate index i think its no need to define path again as it is linked with base cluster...plse correct me if i am wrong

Phantom · Posted: Wed Sep 28, 2005 12:48 am Post subject:

kavya,

I absolutely don't understand what you are trying to do. Either you open multiple threads for the same question or post multiple replies every 2-3 mins. Stay cool and press the submit button only once. !!!

I am deleting your duplicate post. (Sep 28, 2005 10:11 am).

Thanks,
Phantom

kavya · Beginner Joined: 22 Sep 2005 Posts: 12 Topics: 8

WAITING 4 REPLY

kavya · Beginner Joined: 22 Sep 2005 Posts: 12 Topics: 8

plsee tell me the difference between relate and path.what actually relate does and path do.... Question

vkphani · Intermediate Joined: 05 Sep 2003 Posts: 483 Topics: 48

The syntax is

RELATE (base cluster name)

This is a required parameter and it establishes relationship between the base cluster & AIX.

vkphani · Intermediate Joined: 05 Sep 2003 Posts: 483 Topics: 48

Path is used to link JCL DSN to VSAM AIX.

The Pathname becomes the DSN in the run JCL.

kolusu · Posted: Wed Sep 28, 2005 4:21 am Post subject:

kavya,

You just lost privileges to post on this board.

Thanks

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

ANIL SARATHY · Posted: Wed Sep 28, 2005 6:32 am Post subject:

By looking at these post's , it implies that Kavya has not gone thru VSAM
alternate index. Shocked

unless you have don't know concepts , posting on them
is realy a home work for others.
_________________
Anil Sarathy