Reason Code: negative number

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Eveline - 24 Jan 2005 15:56 GMT

Dear all,

I have a database on which I do stuff like:

- creating tables
- filling those tables with data
- joining tables
- EXPORT of queries to file
- LOAD data from file into a tables

After doing the above stuff for a while, I get the following error
after trying to EXPORT a query to file:

"DB21017E The Command Line Processor encountered a system error with
the
front-end process output queue. Reason code = -2097151976."

Does anyone know what the meaning of the negative Reason code is? A bug
maybe?

I am using DB2 v8.2.

regards,

Eveline

Reply to this Message

Mark A - 24 Jan 2005 16:08 GMT

> Dear all,
>
[quoted text clipped - 21 lines]
>
> Eveline

If you check the Messages and Codes manual for that error, you would see
that they give one example of a reason code and it is negative.
Unfortunately it is not the same reason code you have. I was looking at the
V8.1 manual.

Reply to this Message

Serge Rielau - 24 Jan 2005 18:31 GMT

>>Dear all,
>>
[quoted text clipped - 26 lines]
> Unfortunately it is not the same reason code you have. I was looking at the
> V8.1 manual.

This may be coming from the OS. Here is what a tool of mine propsoes:
Operating system reason code (errno):
0x00000018 (24) = Too many open files

Could that be? Maybe you're leaking file handles in your app?

Cheers
Serge

Signature

Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab

Reply to this Message

Eveline - 25 Jan 2005 10:25 GMT

Yes, that was the problem.

Thanks a lot!

Eveline

Reply to this Message