At 09:04 AM 12/11/2003 +0200, you wrote:

>Customer wrote:"Tried to get statement history in large data quantities
>(db aprox 85 mb, period of 38 days and expected records - aprox 100000,
>filter credit operations).
>Maybe not enough swap space? (win2k, 188mb ram, 512 mb swap on two
>logical disks, system disk space free 320 mb)"
>
>He got error: 335544344: I/O error for file
>"C:\winnt\temp\ib_sort_2341". Error while trying to write to file.
>Device does not recognize the command.
>and I/O error for file "C:\winnt\temp\ib_sort_2341". Database file not
>found
>
>
>What command can it be that device doesn't recognize? And how many free
>space is needed?

The proper answer depends on server version, which you don't mention.

The overall answer is that you have NO sort space configured on that
system. It's using c:\winnt\temp in default of absent configured sort
space and there isn't enough disk space there.

With 85Mb of expected *output* from a sorted query you need to configure
about 2.5 times that, or about 215 Mb.

Note, sorts won't use swap space when they have run out sort space. They
will just complain, as your customer noticed.

Fb 1.5 will use available RAM for sorts, but 188Mb is nothing much at all.

How you configure sort space depends on server version. It is all
documented in the OpGuide (for IB and for Fb 1.0) and in the release notes
(for Fb 1.5).

As for the messages, looks as if you have a mismatched message file.

h.