On Thu, 12 Aug 1999 04:16:38 GMT, Matt McGeachie
>Received the following error trying to do an index rebuild using Progress 6.3F13
>running on HPUX 10.20:
>SYSTEM ERROR: I/O error 0 in writeto, ret 8191, file 4(lbi)(srt), addr
>I'm assuming this is because the sort file could not grow past the 2 gig limit.
>Documentation in higher versions talks about creating a db.srt file which would
>get around this problem. I tried this with version 6 but it did not work. Does
>anyone know of a way around this?
I s'pose you could divide and conquer. Do the rebuild in steps, doing
a portion of the indexes at a time. You do this by aswering "Some" to
the "All/None/Some" question at the beginning of the idxbuild.
You can semi-automate this by writing a procedure using the _file and
_index metaschema tables to build flat-files with file names and index
names. You can then add an "envelope" of responses to idxbuild, and
make that the input to it. I think Dan Foreman's DBA guide even has
the text of a procedure to do this, along with instructions on how to
make it work.
AFAIK, Dan's at USI Atlanta; and I believe their web site is at
Paul T. O'Leary
Evco Plastics, a leader in plastics injection molding
DeForest, WI USA
paul_o at evcoplastics dot com