Hi Experts,
I am working on DB2 UDB on AIX and I get following OSERR message in
db2diag.log when I drop database.
Well, the database can be dropped successfully, but the error message
is troublesome as system owner will not accept any error message at
db2diag.log.
2005-11-18-18.18.38.182670 +480 E2336A414 LEVEL: Error (OS)
PID : 151806 TID : 1 PROC : db2agent
(idle) 0
INSTANCE: etddbi01 NODE : 000
APPHDL : 0-7 APPID: *LOCAL.etddbi01 .051118101713
FUNCTION: DB2 UDB, oper system services, sqloexec2, probe:2
CALLED : OS, -, unspecified_sys tem_function
OSERR : EEXIST (17) "Do not specify an existing file."
2005-11-18-18.18.38.186679 +480 E2751A429 LEVEL: Error (OS)
PID : 151806 TID : 1 PROC : db2agent
(idle) 0
INSTANCE: etddbi01 NODE : 000
APPHDL : 0-7 APPID: *LOCAL.etddbi01 .051118101713
FUNCTION: DB2 UDB, oper system services, sqloexec2, probe:2
CALLED : OS, -, unspecified_sys tem_function
OSERR : EBADF (9) "A file descriptor does not refer to an open file."
AIX is 5.3 with ML 3
DB2 is 8.2 with FP10
I just create a simple database (create db simple on </directory>) and
then drop it (drop db simple).
Does anyone has idea on it? Many Thanks!
7  5831 
<ai*****@gmail. com> wrote in message
news:11******** **************@ f14g2000cwb.goo glegroups.com.. . Hi Experts,
I am working on DB2 UDB on AIX and I get following OSERR message in
db2diag.log when I drop database.
Well, the database can be dropped successfully, but the error message
is troublesome as system owner will not accept any error message at
db2diag.log.
2005-11-18-18.18.38.182670 +480 E2336A414 LEVEL: Error (OS)
PID : 151806 TID : 1 PROC : db2agent
(idle) 0
INSTANCE: etddbi01 NODE : 000
APPHDL : 0-7 APPID: *LOCAL.etddbi01 .051118101713
FUNCTION: DB2 UDB, oper system services, sqloexec2, probe:2
CALLED : OS, -, unspecified_sys tem_function
OSERR : EEXIST (17) "Do not specify an existing file."
2005-11-18-18.18.38.186679 +480 E2751A429 LEVEL: Error (OS)
PID : 151806 TID : 1 PROC : db2agent
(idle) 0
INSTANCE: etddbi01 NODE : 000
APPHDL : 0-7 APPID: *LOCAL.etddbi01 .051118101713
FUNCTION: DB2 UDB, oper system services, sqloexec2, probe:2
CALLED : OS, -, unspecified_sys tem_function
OSERR : EBADF (9) "A file descriptor does not refer to an open file."
AIX is 5.3 with ML 3
DB2 is 8.2 with FP10
I just create a simple database (create db simple on </directory>) and
then drop it (drop db simple).
Does anyone has idea on it? Many Thanks!
If system owner will not accept any errors in db2diag.log, then edit the log
and delete the message.
Mark A wrote: If system owner will not accept any errors in db2diag.log, then edit the log
and delete the message.
Cannot do it in this way to solve a technical problem. I wonder how can
a drop database command get error. It may be a real problem of DB2 UDB
8.2 on AIX.
which diaglevel do you use ?
We noticed getting a lot more error messages in level 4 in V8 compared
with V7 and had to switch to 3.
On request IBM just let us know that is the way it is now. They are not
going to change it, works as designed.
I was also not happy (what mark as an error if it is actually not an
error ??).
Still, I did not watch it when dropping a database; so dunno about your
particular message.
<ai*****@gmail. com> wrote in message
news:11******** **************@ g43g2000cwa.goo glegroups.com.. .
Mark A wrote:
If system owner will not accept any errors in db2diag.log, then edit the
log
and delete the message.
Cannot do it in this way to solve a technical problem. I wonder how can
a drop database command get error. It may be a real problem of DB2 UDB
8.2 on AIX.
If you drop a database and it says that the command was successful, and the
database and all directories are gone, then it is not an error. The
db2diag.log contains all kinds of stuff that is not really an error.
I am using diaglevel 3. Only diaglevel 1 can give clean output without
this error. I wonder this error may be a really problem because it is
now 64bit AIX. 32bit instance has same problem too.
probably the only option to clarify what is the reason: open a PMR
This message is created when for some setup, db2 may have been
configured but that related information in the system is not available.
I strongly believe that there is nothing wrong with the instance or
database. These are operating system messages that DB2 has picked up. From errno.h, they indicate:
#define EEXIST 17 /* File exists */
#define EBADF 9 /* Bad file descriptor */
For example, errno 17, in the past I have seen it returned where DB2 is
deciding if it needs to create a file, for instance
/home/<instance>/sqllib/spmlog/SPMLOG.LCF, but this message is acting
as
informational and is returned, since the file already exits and we
don't
need to create. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: C White |
last post by:
I've got another drop list problem
I am using the following code where users select a name, but it should
pass a name and email into the table
<select name="user">
<option value="<% Response.Write (rsUser("Name")) %>">
<% Response.Write (rsUser("Name")) %>
<input type="hidden" name="Email" value="<% Response.Write
(rsUser("Email")) %>">
|
by: Manzoorul Hassan |
last post by:
I just Installed MySQL v4.1.14 and had created a Database (from a
script). But I would like to redo the Database portion of it but am not
able to drop the Database. If I do a "show database;" I still see the
database. But when I look in the data directory, it is not there. Below
is my attempt the create / drop the DB:
mysql> create database testlink;
ERROR 1007 (HY000): Can't create database 'testlink'; database exists
mysql> drop...
|
by: Vigneshwar Pilli via DotNetMonster.com |
last post by:
string connectionString1 = "server=(local); user=sa;password=sa;
database=sonic";
System.Data.SqlClient.SqlConnection dbConnection1 = new
System.Data.SqlClient.SqlConnection(connectionString1);
System.Data.SqlClient.SqlCommand dbCommand1 = new
System.Data.SqlClient.SqlCommand();
|
by: Risen |
last post by:
Hi,all,
I want to execute SQL command " DROP DATABASE mydb" and "Restore DATABASE
....." in vb.net 2003. But it always shows error. If any body can tell me how
to execute sql command as above? Thanks a lot.
Best regard.
Risen
|
by: Ren |
last post by:
Hi all,
I am a bit new to PHP and SQL so this may seem like a dumb question.
I have already created a drop down list as part of a form which is
automatically populated with values taken from a separate database. When a
user goes onto this page and either leaves the default value or selects a
value from the drop down list and presses the submit button, I would like
that selected value to be stored into a database which I have already...
| | |
by: pagelogix |
last post by:
I'm looking for a way to drop multple tables at the same time from my
access database. Any ideas?
Thanks.
|
by: Boujii |
last post by:
Greetings, I have been attempting to make a drop down menu of countries. From this menu I wish to create a variable in order to INPUT into mysql database. I have no trouble making the drop down menu, but I am unable to store a variable for it.
Here is a rough copy of what I am making:
<html>
<head>
<title>Add New MySQL User</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
|
by: dwasler |
last post by:
Try every thing I know to remove this alias
I know there been other posting I read each one none seem to work.
Thank You
DLWasler
dwasler@yahoo.com
OS Window db2 V 8.2.X
|
by: yosri2005 |
last post by:
Hello,
I'm sure many of you have seen the error message in the subject. I
found quiet a few posts on the web regarding this issue, but the ones
I saw mainly tackle this issue when you have a drop-down list
depending on another drop-down list within a form view. This is not
what I'm trying to do, so I didn't know how to apply the solutions I
found to my problem.
I have a formview which inserts items into a database table via an
|
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...
|
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 effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| | |
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, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
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...
|
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...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
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...
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| | |
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...
| |
