Jaichandran
New User
Joined: 20 Apr 2005 Posts: 1
|
|
|
|
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. |
|
doucette222
New User
Joined: 10 Dec 2005 Posts: 2
|
|
|
|
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. |
|