473,780 Members | 2,258 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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 5682

"Eveline" <ev***********@ hotmail.com> wrote in message
news:11******** ************@c1 3g2000cwb.googl egroups.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******** ************@c1 3g2000cwb.googl egroups.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
6538
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 number will be missing, which is not a problem for my purposes I don't think, but how would it be negative? Can randomly created PK autonumber fields be negative? Any way for a PK, autonumbered, *incremented* to be negative? TIA
6
3939
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
6122
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 and negative quantities . Can any one tell me what are the things i should bear in mind .
11
8094
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 a backcolor/forecolor/etc property and calculate the "reverse colour"? In other words, If a user picks 255 (red) for a control backcolor, I'd like to be able to calculate the opposite or negative of that colour and assign the control's...
15
35515
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
4022
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, and that it contains no padding. Firstly, I realise that the MSB is known as the sign-bit, and that it indicates whether the number is positive or negative (irrespective of which negative number system is used).
1
1715
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: #include <stdio.h> /* global variables */ int e, f;
20
5829
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 negative numbers into a separate sequence and ignore the (now empty) args list returned by getopt, but it would seem this is such a common requirement that there would be an option to treat a negative value as an argument. Note that this is only a...
3
2257
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. Thanks, Peng
0
9636
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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
10139
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 tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
9931
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 protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
8961
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, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
5373
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
5504
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4037
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
3632
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2869
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.