The issue is we have alternate index even though base cluster is populated(insert,delete or update), the AIX do not show any value for the populated in base.
The AIX is defined with upgrade parameter and but not sure why data is not populating from base cluster.
when i rebuild AIX the data is populating from base cluster, but i want the AIX to populate the data automatically whenever base cluster data( updated or inserted or deleted)
Please provide your inputs help in identifying the reason for this issue
Joined: 06 Jun 2008 Posts: 8165 Location: East Dubuque, Illinois, USA
Are you updating in batch or online?
If batch, show the JCL yhou are using (again with CODE tags).
As Bill said, show the LISTCAT (with CODE tags).
How are you determining that the alternate index is not being updated?