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
 

 

difference between build and path

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

New User


Joined: 11 May 2005
Posts: 22

PostPosted: Mon Sep 05, 2005 4:28 pm    Post subject: difference between build and path
Reply with quote

hi,


what is difference between build and path

what is advantage of alternate index

Thanking in advance
Back to top
View user's profile Send private message

Rupesh.Kothari

Member of the Month


Joined: 27 Apr 2005
Posts: 464

PostPosted: Mon Sep 05, 2005 4:46 pm    Post subject: Re: difference between build and path
Reply with quote

Hi,

Quote:
what is difference between build and path


DEFINE PATH --> it is used to create a path between your main index and AIX. (Relate this to Alternate Index file. This will be the link between Base and AIX)


BUILD INDEX -->Once an AIX has defined, records can be loaded into it using the BLDINDEX command. (This will load the records from the base cluster to the AIX cluster)


Quote:
what is advantage of alternate index


Hope the following note helps you -
An Alternate Index AIX provides a view of data different from the one offered by the primary key. For example for a KSDS dataset Employee, you may have a Record Key index on Employee-no and an Alternate Index on Employee-Name . You can now browse and even update the same KSDS in logical sequence by Employee-Name.

Alternate Indexes may be defined on one or more than one Alternate Key(s) i.e. Field(s) other than primary key. Alternate Key(s) need not be unique. Each alternate index itself is a KSDS with data and index component.

Alternate Index greatly reduces redundancy. There is no need to keep a separate dataset for different views like Employees? Social Security No. The records may be accessed sequentially or randomly based on the alternate record keys.

They can be updated automatically when the base cluster is updated.

Alternate Indexes do not support a reusable base cluster. So NOREUSE which is the default, should be specified.

Too many Alternate Indexes built on a KSDS may lead to performance Degradation as access by alternate key requires twice as many I/O?s . VSAM first locates the primary key from the alternate index and then locates the Control Interval information from the record key index.


Hope this helps you

Regards
Rupesh
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 Difference between TWALENG and TWASIZE Arunkumar Chandrasekaran CICS 3 Tue Jan 03, 2017 12:57 pm
No new posts Sticky: difference between ... DUMMY ... and ... enrico-sorichetti JCL & VSAM 0 Mon Oct 17, 2016 4:31 pm
No new posts Difference space showed for TS and it... autobox DB2 1 Thu Apr 14, 2016 1:07 pm
No new posts Difference Between CICS WebSupport an... sachinji84 CICS 1 Mon Mar 07, 2016 7:25 pm
No new posts Build a dynamic query file hiravibk DFSORT/ICETOOL 2 Wed Feb 10, 2016 12:47 am


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