Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist 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 Not able to export the VSAM cluster sandeep kumar302 JCL & VSAM 6 Fri May 04, 2018 12:42 pm
No new posts Incorrect output after build alternat... sandeep kumar302 JCL & VSAM 10 Wed May 02, 2018 2:35 pm
No new posts IDCAMS RENAMING VSAM FILE ALONG WITH ... upendrasri JCL & VSAM 12 Tue Apr 17, 2018 10:42 pm
No new posts VSAM file NOT Found error while proce... SumaReva CICS 5 Wed Apr 11, 2018 9:54 pm
No new posts VSAM - Accessing beyond record size Benchwarmer JCL & VSAM 6 Wed Apr 11, 2018 9:20 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us