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.