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
 

 

VSAM - Regarding Non-unique Alternate index

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

New User


Joined: 20 Apr 2005
Posts: 1

PostPosted: Tue Oct 18, 2005 10:25 am    Post subject: VSAM - Regarding Non-unique Alternate index
Reply with quote

Hi all,

I am Jaichandran.

This is regarding Non-unique alternate index.

Here is an example,

The cluster has been created in this way:

1. Creation of base cluster.
2. Creation of Alternate Index.
3. Build index
4. Path creation.

Now, there are 5 records in a vsam ksds file in which the id number is the primary key and the priority number is the alternate key.

Suppose if there are records with same alternate key, the alternate index will have records of variable length.

That means, the primary keys of the base cluster(id number) will get appended along with the alternate key(prioriry number) which is the primary key of the altenate index.

Now my problem is, whenever i insert some records, the primary keys(id number) are getting appended at the end of last primary key(id number) but not getting inserted. And because of that the primary keys of base cluster(id number) in alt. index are in entry sequence but not in ascending sorted order.

Please i request u all to spend some time on this to clarify my problem.

Thank you all in advance

Regards,

Jaichandran.
Back to top
View user's profile Send private message

doucette222

New User


Joined: 10 Dec 2005
Posts: 2

PostPosted: Sun Dec 11, 2005 7:16 am    Post subject:
Reply with quote

thats just the way vsam works - you need to rebuild the alt index nightly or periodically to get the sequence ascending. an upgradeable alternate index is upgraded that way upon the inserts. its costly, and not ascending, and thats why alt indexes are usually not upgradeable but only get 'upgraded' upon nughtly / periodic rebuilds.
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 how to recover an uncataloged VSAM da... archanamuthukrishnan All Other Mainframe Topics 3 Wed Jan 11, 2017 6:18 pm
No new posts Underlying DB2 VSAM LDS - SMF recording vasanthz All Other Mainframe Topics 6 Thu Jan 05, 2017 4:20 am
No new posts Order BY AND Index Nileshkul DB2 2 Sat Dec 31, 2016 6:33 pm
No new posts BWO option in VSAM blayek CICS 3 Sat Nov 05, 2016 10:47 am
No new posts VSAM define for large file jerryte JCL & VSAM 9 Wed Oct 05, 2016 1:51 am


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