Page 1 of 1

Record Count in Alternate Index

PostPosted: Tue Feb 08, 2011 2:28 pm
by sudip
What can be the reason for record count change in Alternate index file? One of my alternate index file record count differs from the base vsam file.

Re: Record Count in Alternate Index

PostPosted: Tue Feb 08, 2011 2:47 pm
by enrico-sorichetti
You can choose between two reasons

the alternate index is not unique, You have duplicates
solution, check the application description and <data> layout/requirements and just meditate
be happy that You were enlightened

the alternate index is unique, You clobbered Your data
solution, check the application description and <data> layout/requirements and rebuild the index
worry about your process

Re: Record Count in Alternate Index

PostPosted: Tue Feb 08, 2011 3:50 pm
by NicC
Really this is a VSAM question and should hve been posted there.

Re: Record Count in Alternate Index

PostPosted: Tue Feb 08, 2011 4:28 pm
by sudip
Thanks all for ur replies....nxt time I'll be cautious before post.