By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,874 Members | 1,027 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,874 IT Pros & Developers. It's quick & easy.

Help with diaglog message

P: n/a
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
Share this Question
Share on Google+
3 Replies


P: n/a
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

P: n/a
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

P: n/a
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 discussion thread is closed

Replies have been disabled for this discussion.