At 02:25 PM 05-02-02 +0000, you wrote:

>Hi
>
>This error has occured a few times at random parts of our app.
>
>I/O error for file "c:\winnt\temp\ib_sort_b00628"
>Error while trying to write to file
>unknown win32 error 22
>
>The client computer generating the error must be rebooted, but can
>then continue and all will be fine ( for a while )
>
>The server is win2000, the clients win95.
>Using IBOjects, IB 6.0, Delphi 5.
>
>Thanks - Rod

Rod,
You don't have enough temp disk space available for some temporary sort files that the engine needs to write to the server's disk. A reboot "fixes" it because the OS is supposed to clear out the system-defined temp space. Next time you need a biggish sort file - boom!

Solution: Define lots of sort space and define it explicitly, so that it doesn't just use the TMP directory. You can put sort directories anywhere on the server's (own) system that has big blocks of space available.

In ibconfig, add as many separate lines as you have directories defined, in the order that you want them used:
tmp_directory 6000000 "d:\fbtemp"
tmp_directory 12000000 "f:\fbtemp"
tmp_directory 4000000 "w:\aladdin"

Those sizes are in bytes; the paths must exist, must be dbl-quoted and, if you have long paths, keep the whitespace down to 1 because there is a limit on the length of a line.

You can also configure temp space for other stuff (like the isql history cache) by specifying a INTERBASE_TMP variable for a particular directory, on the Environment tab of the Control Panel | System applet. In this case, no quotes are needed but the directory must exist.

No need to say (but I am anyway) - make sure you always have plenty of space available in these locations.

cheers,
H.


All for Open and Open for All
Firebird Open SQL Database · http://firebirdsql.org
_______________________________________________________