Hi,
here is a message I have been recieving in my db2diag.log file
240 E457831A419 LEVEL: Warning (OS)
PID : 369436 TID : 5707 PROC : java
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, oper system services, sqloqualifydir, probe:30
CALLED : OS, -, unspecified_sys tem_function
OSERR : ENOENT (2) "A file or directory in the path name does not
exist."
DATA #1 : File name, 27 bytes
/u01/home/db2inst1/db2inst1
This is repeating through out the day. I cannot find anything in the
dbm or db parameters that point to this location. This being a new
machine no other users are connected to it. I am just prepping up the
machine. 4 6000
Asphalt Blazer wrote:
Hi,
here is a message I have been recieving in my db2diag.log file
240 E457831A419 LEVEL: Warning (OS)
PID : 369436 TID : 5707 PROC : java
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, oper system services, sqloqualifydir, probe:30
CALLED : OS, -, unspecified_sys tem_function
OSERR : ENOENT (2) "A file or directory in the path name does not
exist."
DATA #1 : File name, 27 bytes
/u01/home/db2inst1/db2inst1
This is repeating through out the day. I cannot find anything in the
dbm or db parameters that point to this location. This being a new
machine no other users are connected to it. I am just prepping up the
machine.
It _appears_ that DB2 is trying to write to a specfic path,
/u01/home/db2inst1/db2inst1, and not finding it.
I think you need to figure out _why_ it is trying to write to that
path. Then, if that is the correct path, you'll need to create the
necessary directories or, if it isn't the correct path, you'll want to
change the parameters to make it point to the desired path.
Based on the "FUNCTION:" line, I'm _guessing_ that DB2 is trying to
write a log file to that path. I would have expected to see the
troublesome path in your dbm or db configurations but you say that you
have already checked them and that path is not used. All I can suggest
is that you double-check them just to see if you missed one. Perhaps it
is the data warehouse database, not one of the ones you created for
yourself??
--
Rhino
It is a dw database, i had redirected restored the database from
another machine. But even in that machine there is no path like this. I
double and triple checked the paths in db and dbm cfg's there is no
path like this
the salient paths:
db cfg
Path to log files =
/u02/db2alogs/cdxxxx/NODE0000/
dbm cfg
Default database path (DFTDBPATH) =
/u01/db2catalogs
I dont know why it is still looking for this path rh*********@yah oo.ca wrote:
Asphalt Blazer wrote:
Hi,
here is a message I have been recieving in my db2diag.log file
240 E457831A419 LEVEL: Warning (OS)
PID : 369436 TID : 5707 PROC : java
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, oper system services, sqloqualifydir, probe:30
CALLED : OS, -, unspecified_sys tem_function
OSERR : ENOENT (2) "A file or directory in the path name does not
exist."
DATA #1 : File name, 27 bytes
/u01/home/db2inst1/db2inst1
This is repeating through out the day. I cannot find anything in the
dbm or db parameters that point to this location. This being a new
machine no other users are connected to it. I am just prepping up the
machine.
It _appears_ that DB2 is trying to write to a specfic path,
/u01/home/db2inst1/db2inst1, and not finding it.
I think you need to figure out _why_ it is trying to write to that
path. Then, if that is the correct path, you'll need to create the
necessary directories or, if it isn't the correct path, you'll want to
change the parameters to make it point to the desired path.
Based on the "FUNCTION:" line, I'm _guessing_ that DB2 is trying to
write a log file to that path. I would have expected to see the
troublesome path in your dbm or db configurations but you say that you
have already checked them and that path is not used. All I can suggest
is that you double-check them just to see if you missed one. Perhaps it
is the data warehouse database, not one of the ones you created for
yourself??
--
Rhino
actually I found one more thing, this error happens when I start the
control center. Well that does not solve the problem.
Asphalt Blazer wrote:
It is a dw database, i had redirected restored the database from
another machine. But even in that machine there is no path like this. I
double and triple checked the paths in db and dbm cfg's there is no
path like this
the salient paths:
db cfg
Path to log files =
/u02/db2alogs/cdxxxx/NODE0000/
dbm cfg
Default database path (DFTDBPATH) =
/u01/db2catalogs
I dont know why it is still looking for this path rh*********@yah oo.ca wrote:
Asphalt Blazer wrote:
Hi,
here is a message I have been recieving in my db2diag.log file
>
240 E457831A419 LEVEL: Warning (OS)
>
PID : 369436 TID : 5707 PROC : java
>
INSTANCE: db2inst1 NODE : 000
>
FUNCTION: DB2 UDB, oper system services, sqloqualifydir, probe:30
>
CALLED : OS, -, unspecified_sys tem_function
>
OSERR : ENOENT (2) "A file or directory in the path name does not
exist."
>
DATA #1 : File name, 27 bytes
>
/u01/home/db2inst1/db2inst1
>
>
This is repeating through out the day. I cannot find anything in the
dbm or db parameters that point to this location. This being a new
machine no other users are connected to it. I am just prepping up the
machine.
It _appears_ that DB2 is trying to write to a specfic path,
/u01/home/db2inst1/db2inst1, and not finding it.
I think you need to figure out _why_ it is trying to write to that
path. Then, if that is the correct path, you'll need to create the
necessary directories or, if it isn't the correct path, you'll want to
change the parameters to make it point to the desired path.
Based on the "FUNCTION:" line, I'm _guessing_ that DB2 is trying to
write a log file to that path. I would have expected to see the
troublesome path in your dbm or db configurations but you say that you
have already checked them and that path is not used. All I can suggest
is that you double-check them just to see if you missed one. Perhaps it
is the data warehouse database, not one of the ones you created for
yourself??
--
Rhino
If you're going to start top-posting, this is going to get
confusing....
Asphalt Blazer wrote:
It is a dw database, i had redirected restored the database from
another machine. But even in that machine there is no path like this. I
double and triple checked the paths in db and dbm cfg's there is no
path like this
the salient paths:
db cfg
Path to log files =
/u02/db2alogs/cdxxxx/NODE0000/
dbm cfg
Default database path (DFTDBPATH) =
/u01/db2catalogs
I dont know why it is still looking for this path
It looks like you're working with a flavour of Unix or Linux. Could
there be a symbolic link pointing from one of your paths to the one
mentioned in the message?
Other than that, I'm not sure what else to suggest.
You could try googling on sqloqualifydir or other keywords in the log
entry (in both Google Groups and Google Web) to see if you can find
other problem reports that might be related. That might give you a clue
about what you should do.
You could create the path it wants - just leave it empty or put a
harmless file in there - and see if the problem goes away. This _might_
increase the scope of the problem if the file it wants is critical but
that might be helpful if you get more and/or clearer messages that tell
you what exactly is wrong.
You could ignore the message since there is apparently nothing
misbehaving within your system beyond the generation of this message.
You could call IBM Support and ask for their help. That will cost you
something if you don't already have a support contract but maybe it
will be worth if for your peace of mind.
I suppose it depends on how much this bothers you and how much time and
money you're willing to spend to resolve the problem.
--
Rhino
>
rh*********@yah oo.ca wrote:
Asphalt Blazer wrote:
Hi,
here is a message I have been recieving in my db2diag.log file
>
240 E457831A419 LEVEL: Warning (OS)
>
PID : 369436 TID : 5707 PROC : java
>
INSTANCE: db2inst1 NODE : 000
>
FUNCTION: DB2 UDB, oper system services, sqloqualifydir, probe:30
>
CALLED : OS, -, unspecified_sys tem_function
>
OSERR : ENOENT (2) "A file or directory in the path name does not
exist."
>
DATA #1 : File name, 27 bytes
>
/u01/home/db2inst1/db2inst1
>
>
This is repeating through out the day. I cannot find anything in the
dbm or db parameters that point to this location. This being a new
machine no other users are connected to it. I am just prepping up the
machine.
It _appears_ that DB2 is trying to write to a specfic path,
/u01/home/db2inst1/db2inst1, and not finding it.
I think you need to figure out _why_ it is trying to write to that
path. Then, if that is the correct path, you'll need to create the
necessary directories or, if it isn't the correct path, you'll want to
change the parameters to make it point to the desired path.
Based on the "FUNCTION:" line, I'm _guessing_ that DB2 is trying to
write a log file to that path. I would have expected to see the
troublesome path in your dbm or db configurations but you say that you
have already checked them and that path is not used. All I can suggest
is that you double-check them just to see if you missed one. Perhaps it
is the data warehouse database, not one of the ones you created for
yourself??
--
Rhino
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Klemens |
last post by:
what do entry's like this in db2diag.log indicate?
-------------------------------------------
2004-01-14-09.07.52.650000 Instance:WWS Node:000
PID:3512(db2syscs.exe) TID:1116 Appid:*LOCAL.WWS.01AFC9110326
data protection sqlpALR_OpenExtent Probe:5 Database:XTRADE
RenameArray: add unarchived log 1227.
...
|
by: Shawn |
last post by:
We are on IBM DB2 7.1 ON WINDOWS. The db2diag.log is not working and
no new line written into it for few days. The last lines in
db2diag.log shows:
Warning: active log held by dirty pages.
Decrease softmax and/or increase num_iocleaners.
repeatedly . What is the problem? How can resolve it quickly? The
applicatipna dnLDAP is up and...
|
by: richardshen |
last post by:
Instead of watching it manually.
|
by: soccertl |
last post by:
I wrote code that parses the db2diag.log to look for errors that would
require us to generate a message to a service center indicating
something is wrong. My problem is trying to figure out what the errors
are. From studying the log, I noticed the codes on the first line after
the date/time are all the same for the same message. For example:
...
|
by: Praveen_db2 |
last post by:
Hi All
I am getting strange errors in my db2diag.log can any one tell me what
these errors mean??
Following is the code from my db2diag.log
*********************************************************************************************
2006-02-23-17.53.12.253000 Instance:DB2 Node:000
PID:1600(db2syscs.exe) TID:440 ...
| |
by: Gio Galma |
last post by:
how I can invoke the db2diag utility in a Windows environment?
in my D:\Program Files\IBM\SQLLIB\BIN directory I can see only
db2diag.dll, and it seems there isn't the command line version; which is
the DB2 tool that uses this dll, in order to analyze the db2diag.log?
thank you in advance for help (and please, excuse my bad english)
Jo
...
|
by: oddbande |
last post by:
We have just upgraded a test enviroment to db2 9, and have set both the
notifylevel and diaglevel to 3. But even so I get a lot of these
messages in my db2diag.log:
2006-11-02-00.10.11.951000+060 I326548H465 LEVEL: Info
PID : 3008 TID : 4072 PROC : db2dasstm.exe
INSTANCE: DB2 NODE : 000...
|
by: Norm |
last post by:
Does anyone have any suggestions for securing against this
vulnerability:
http://nvd.nist.gov/nvd.cfm?cvename=CVE-2007-1027
Fixes are not yet available from IBM. They will be in FP2 for V9 and
FP15 for V8.
Would changing the permissions on the db2dump directory so that only
instance owner has access be enough?
|
by: KG |
last post by:
Hi,
Does anyone knows how to recover the test file db2diag.log. By mistake
I have delete the contents of db2diag.log, wondering if I could
restore the contents of my db2diag.log.
|
by: eddy82 |
last post by:
Hi All,
I have this db2start in my db2diag.log everyday around the same time. But no db2stop in the db2diag.log or in the db2.nfy.
I already check and no corruption or cronjob running during that time. However when i check the db up time, it is different from the one specified in the db2diag.log. So i suspect, the db2start didn't ran, but it...
|
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...
| |
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...
|
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...
|
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...
|
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 presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes...
|
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...
|
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...
| |
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...
| |