They very well may have been. A resize is performed periodically by the admins there "as needed". Thinking back, the sizes on the were all large, I remember a couple of them being 100003 modulo, I think somebody did up the size quite a bit. I wonder if a UniData resize or memresize would do it if combined with a "live" system (not a guarantee of exclusivity.) I know even on UniData 7.1 the folks helping with system admin tasks like resizes and such would do it while folks were online and using these files (I kind of freaked out about that...)
-----Original Message----- From: Allen Egerton <aeger...@pobox.com> To: U2 Users List <u2-users@listserver.u2ug.org> Sent: Thu, Oct 13, 2011 10:21 am Subject: Re: [U2] Unidata 7.1.22 Index Issue Were these files by any chance copied/moved from their original location? The headers to the file, (at least in Universe), create pointers to the hysical disk location of the indexes, and if you move the file without djusting those pointers, you can have all sorts of fun issues. n 10/13/2011 10:07 AM, regalit...@aol.com wrote: This information has been extremely helpful! I had 11 files have the indexes go bad on them, and they needed to be ompletely rebuilt. The only anomaly is that the "DELETE.INDEX fn ALL" didn't work right away. There was an index on the file, a V-field, called "XERP.SQLTRIG". When the ndex went bad, it was there, but not really there. On a file called STUMAST for xample, I would say: :LIST.INDEX STUMAST No indices created on file "STUMAST" : Then I would say try to create the index: :CREATE.INDEX STUMAST XERP.SQLTRIG "XERP.SQLTRIG": can not create multiple indices on same location No new indices are created : So UniData sort of knows the index was there, but it doesn't really know. And unfortunately, that is my problem. SNIP> ______________________________________________ 2-Users mailing list 2-us...@listserver.u2ug.org ttp://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
