MVSFORUMS.com

kappurajesh · Posted: Sat Jul 31, 2004 11:43 pm Post subject: Alternative Index

1. Can we update directly to Alternative Index ?

2. If yes, it can be updated in base cluster?

warp5 · Posted: Mon Aug 02, 2004 7:46 am Post subject:

Depends upon what you mean by updating the alternate index. The alternate index is just a collection of keys to address the base cluster. If you want to update the base cluster using alternate keys, ok. If you want to change the alternate index itself then the base will know nothing about it.

kappurajesh · Posted: Mon Aug 02, 2004 9:32 am Post subject:

If we insert into alternative index, it can be reflected in base cluster or not

warp5 · Posted: Tue Aug 03, 2004 12:38 am Post subject:

Like I said, the alternate index is not a normal dataset. If you insert a RECORD into the base cluster using the alternate index then that is ok. If you insert a index into the alternate index then the base cluster knows nothing about it. You obviously do not understand the concepts here. Read up on them.
A dataset (for example a KSDS dataset) is usually defined first. Then an alternate index is defined and a build index is run against the original dataset building a list of all the alternate index keys. The data is not held in the alternate index, just the reference to the original dataset.