Very Computer

by **Matt McGeachi** » Fri, 13 Aug 1999 04:00:00

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
2147475456

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?

by **Niels Diepevee** » Fri, 13 Aug 1999 04:00:00

Matt McGeachie schreef:

Quote:
> 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
> 2147475456

> I'm assuming this is because the sort file could not grow past the 2 gig limit.

Seeing that 2147475456 + 8191 = 2^31 - 1, I think you're right.

Quote:> 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?

Split the indexes into groups that stay under the 2GB limit. If any
single index is can't be sorted within 2GB, rebuild it without sorting.

--
Niels Diepeveen
Endea automatisering

by **Paul T. O'Lea** » Fri, 13 Aug 1999 04:00:00

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
>2147475456

>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
http://www.usiatl.com .
--
Paul T. O'Leary
Evco Plastics, a leader in plastics injection molding
DeForest, WI USA
paul_o at evcoplastics dot com

Very Computer

Index rebuild

Index rebuild

Index rebuild

Index rebuild