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 Updating a VSAM file with DISP=OLD sheersh JCL & VSAM 8 Tue Mar 14, 2017 6:14 pm
No new posts SORT VSAM file with each field one by... maxsubrat DFSORT/ICETOOL 6 Tue Mar 14, 2017 1:07 pm
No new posts VSAM RLS=NRI while doing IDCAMS sheersh JCL & VSAM 1 Tue Mar 07, 2017 1:55 pm
No new posts setting new limit Key values for inde... srilata83 DB2 1 Fri Feb 10, 2017 9:24 pm
No new posts Fail to change physical VSAM filename... jacobdng CICS 7 Fri Jan 20, 2017 12:36 pm


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