MVSFORUMS.com

niks_jude · Beginner Joined: 23 Nov 2006 Posts: 8 Topics: 2

Hi,

When is the PATH related to Alternate Index populated with records. I believe the BLDINDEX does not do it as path is sometimes built after BLDINDEX has been run. Please let me know.

kolusu · Posted: Tue Feb 26, 2008 11:57 am Post subject:

niks_jude,

Path just establishes the relationship between an alternate index and its base cluster.

The sequence for building an alternate index is as follows:

1. Define the base cluster, using either the ALLOCATE command, the DEFINE CLUSTER command, or JCL.

2. Load the base cluster either by using the REPRO command or by writing your own program to load the data set.

3. Define the alternate index, using the DEFINE ALTERNATEINDEX command.

4. Relate the alternate index to the base cluster, using the DEFINE PATH command. The base cluster and alternate index are described by entries in the same catalog.

5. Build the alternate index, using the BLDINDEX command.
_________________
Kolusu
www.linkedin.com/in/kolusu

niks_jude · Beginner Joined: 23 Nov 2006 Posts: 8 Topics: 2

Thanks for your response. But in one of the path datasets I saw records in order of AIX. I needed to know when are these records populated - as part of automatic upgrade?

expat · Posted: Sun Mar 02, 2008 3:36 am Post subject:

niks_jude · Beginner Joined: 23 Nov 2006 Posts: 8 Topics: 2

So if UPGRADE is not on then how it would get populated?

warp5 · Posted: Mon Mar 03, 2008 2:04 am Post subject:

5. Build the alternate index, using the BLDINDEX command.

niks_jude · Beginner Joined: 23 Nov 2006 Posts: 8 Topics: 2

BLDINDEX would populate alternate index but I could not get any manual saying that it would also populate the path?

warp5 · Posted: Tue Mar 04, 2008 6:27 am Post subject:

And Kolusu has already answered that too, a path is not populated, it is a path just as the word means:
Path just establishes the relationship between an alternate index and its base cluster.