473,404 Members | 2,137 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,404 software developers and data experts.

Reason Code: negative number

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

Nov 12 '05 #1
3 5643

"Eveline" <ev***********@hotmail.com> wrote in message
news:11********************@c13g2000cwb.googlegrou ps.com...
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

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.
Nov 12 '05 #2
Mark A wrote:
"Eveline" <ev***********@hotmail.com> wrote in message
news:11********************@c13g2000cwb.googlegrou ps.com...
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


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.

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
--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab
Nov 12 '05 #3
Yes, that was the problem.

Thanks a lot!

Eveline

Nov 12 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

13
by: Ron | last post by:
Hi all I'm deciding whether to use the PK also as an account number, invoice number, transaction number, etc that the user will see for the respective files. I understand that sometimes a...
6
by: | last post by:
i have a field that holds currency formatted numbers. how would I make it so that all values entered in this field would be negative? thanks in advance
5
by: Subrahmanyam Arya | last post by:
Hi Folks , I am trying to solve the problem of reading the numbers correctly from a serial line into an intel pentium processor machine . I am reading 1 byte and 2byte data both positive...
11
by: Tim Marshall | last post by:
I use Terry Kreft's & Stephen Lebans colour dialog procedures for users to pick colours for various control properties in certain apps. Is there a way to take the colour code that is displayed in...
15
by: jaks.maths | last post by:
How to convert negative integer to hexadecimal or octal number? Ex: -568 What is the equivalent hexadecimal and octal number??
39
by: Frederick Gotham | last post by:
I have a general idea about how negative number systems work, but I'd appreciate some clarification if anyone would be willing to help me. Let's assume we're working with an 8-Bit signed integer,...
1
by: KiMcHeE | last post by:
Hi! I'm having a real difficult time trying to figure out what is wrong with my program code. I'm trying to make a "calculator" in the C language and I only know basic stuff. Here's my code: ...
20
by: Casey | last post by:
Is there an easy way to use getopt and still allow negative numbers as args? I can easily write a workaround (pre-process the tail end of the arguments, stripping off any non-options including...
3
by: Peng Yu | last post by:
Hi, I don't understand why rbegin() -rend() gives a negative number. Since rbegin() + 1 gives the one before the last element, I think rbegin() - rend() should give a positive number. ...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.