473,326 Members | 2,090 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,326 software developers and data experts.

Help with diaglog message

Hi all.

I have written a homegrown monitoring script to capture table snapshots
and dynamic sql statements. I run this script for a period of about 20
hours a day from Monday to Friday. It uses work files to store interim
data while formatting the snapshot outputs, and the final output
dataset is formatted so I can import the day's perf data into a DB2
table.

This works most days, but every few days this monitoring job fails. It
appears to be hanging and the temp workfiles do not get cleaned up.
When the next day's run of the script starts it does not write out any
data until I kill the previous day's script and manually remove the
work datasets.
My environment is AIX 5.2 ML6, and DB2 V7.2 fp11. I am receiving the
following diaglog messages:

String Title:Path/Filename PID:2085100 Node:000
/tmp/trace/db2_mon_stmts.p2alius1.AUTOVIEW.tmp4

2006-01-25-06.20.02.489192 Instance:p2alius1 Node:000
PID:2085100(db2bp) Appid:*LOCAL.p2alius1.060128121254
oper_system_services sqloopenp Probe:20

errno: 0000 001a ....

My questions are: Can anyone help me identify the diaglog messaging?
and Has anyone experienced a similar issue?/How did you deal with it?
Regards in advance,
Richard McCutcheon
Honda of Canada Mfg.

Jan 25 '06 #1
3 1828
Richard McCutcheon wrote:
2006-01-25-06.20.02.489192 Instance:p2alius1 Node:000
PID:2085100(db2bp) Appid:*LOCAL.p2alius1.060128121254
oper_system_services sqloopenp Probe:20
sqloopenp opens a file.
errno: 0000 001a ....


The file-open operation failed and the errno is set to 0x1a = 26 = ETXTBSY.
It appears that some file (you might see which if you set the diaglevel to
4) could not be opened because it is currently accessed.

--
Knut Stolze
DB2 Information Integration Development
IBM Germany
Jan 25 '06 #2
Thanks for the response Knut.

By the way, where did you find the interpretation of the 0000 001a
message? Is this in a manual I should have ?
Regards,
Richard McCutcheon.

Jan 25 '06 #3
Richard McCutcheon wrote:
Thanks for the response Knut.

By the way, where did you find the interpretation of the 0000 001a
message? Is this in a manual I should have ?


I had a look at /usr/include/errno.h and with "man errno" you will get a
short description of the error (well, sort of).

--
Knut Stolze
DB2 Information Integration Development
IBM Germany
Jan 25 '06 #4

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

Similar topics

21
by: Dave | last post by:
After following Microsofts admonition to reformat my system before doing a final compilation of my app I got many warnings/errors upon compiling an rtf file created in word. I used the Help...
2
by: fabien | last post by:
Hi, I am writing a POV-RAY editor with Python using either QT or GTK as GUI 'wrapper'. ( I am still trying both ) * * * * PYGTK * * * * I have downloaded PygtkScintilla-1.99.5. There is a...
7
by: tcarvin | last post by:
The .NET studio help system seems to use these odd URLs to locate (html) help files to display. But on my system, I get "Server not found" web errors whenever I access Help. What do I have to do...
2
by: Ilyas | last post by:
Hai, I'm new here. Sorry For typos. How can i open a file save dialog in a dotnet web app. (.aspx) to save my file at clients computer. Thanx. Greatings from Holland.
9
by: Dom Boyce | last post by:
Hi First up, I am using MS Access 2002. I have a database which records analyst rating changes for a list of companies on a daily basis. Unfortunately, the database has been set up (by my...
7
by: Corepaul | last post by:
Missing Help Files When I enter "recordset" as the keyword and search the Visual Basic Help index, I get many topics of interest in the resulting list. But there isn't any information available...
1
by: Donagh Berry | last post by:
hi all, I am a newcomer to using modules in microsoft access. I have written code to create a table and append other tables onto it. However, with each step a dialog box appears to ask if I'm sure...
7
by: tyler_durden | last post by:
thanks a lot for all your help..I'm really appreciated... with all the help I've been getting in forums I've been able to continue my program and it's almost done, but I'm having a big problem that...
2
by: matias.cornejo | last post by:
¿¿¿¿¿¿Anybody knows this error?????? 2007-03-23-11.08.12.484581 Instance:db2inst1 Node:000 PID:204782(db2agent (DB2XXX)) Appid:*LOCAL.db2inst1.070323232921 data_management sqldmdpi ...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

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.