community.borland.com

Article #25811: I/O error for file "/temp/iba00203" Error while trying to write to file

Problem:
What is the meaning of:
ERROR:  I/O error for file "/temp/iba00203" 
Error while trying to write to file 
The device does not recognize the command.


Solution:
The most common explanation for this error is that the drive containing
/temp ran out of space during a sort task. InterBase performs a sort as part of a
group by, to order the entries so it can group them.

Depending on the nature of the data, InterBase can require a lot of
temporary disk space to perform sorting.  It can even exceed the amount
of space used by the .gdb file itself.

You should make sure you have plenty of space in that directory, or use
the INTERBASE_TMP environment variable (or TMP_DIRECTORY entry in
ibconfig) to direct InterBase to use another location for temporary sort
files.

Source: Bill Karwin

Last Modified: 27-OCT-00