Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Why Alternate Indexes are used

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL
View previous topic :: :: View next topic  
Author Message
mohanmaruthi

New User


Joined: 29 Sep 2005
Posts: 4
Location: hyderabad

PostPosted: Wed Oct 05, 2005 9:58 pm    Post subject: Why Alternate Indexes are used
Reply with quote

heloo... I am bit confused of using the Alternate Index???

How it is use full..( i know it is used to get the record ather then primary key.

but.. when I created the AIX cluster, it just gives me the data. and the index... but how it is use full??can any one let me know about, AIX, PATH,
BLDINDEX

I know the meaning of them, but cannot corelate all of them..
Thank you
Back to top
View user's profile Send private message

nikyojin

New User


Joined: 05 Oct 2005
Posts: 94

PostPosted: Fri Oct 07, 2005 2:49 pm    Post subject:
Reply with quote

ALternate Index provides an additional path to access the Vsam file.
Quote:
AIX

While declaring an alternate index the characteristics of the alternate key to be considered is stated.
Quote:
PATH

The path provides a physical path to relate the Alternate Index with the Main cluster.
Quote:
BLDINDEX

Physically records are populated into the alternate Index file when this step is carried out.Each alternate key is associated with one or multiple main keys.

The main purpose of AIX is to access the same file in multiple ways without creating separate copies.
In the program the file can be accessed using the alternate index in the same manner as primary index.AIX key should be declared initially.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Several errors during building altern... Andi1982 JCL & VSAM 11 Wed Jul 06, 2016 7:39 pm
No new posts Drop building Alternate Index for a p... bhavin.mehta JCL & VSAM 6 Mon Jul 04, 2016 3:47 pm
No new posts VSAM Alternate Index in CICS jacobdng CICS 2 Fri May 06, 2016 1:41 pm
No new posts Retrieve records in the order of alte... jacobdng Compuware & Other Tools 8 Fri Jul 31, 2015 8:16 am
No new posts EIBRESP 13 on Alternate Index amitc23 CICS 7 Wed Feb 18, 2015 6:33 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us