473,698 Members | 2,704 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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.p 2alius1.AUTOVIE W.tmp4

2006-01-25-06.20.02.489192 Instance:p2aliu s1 Node:000
PID:2085100(db2 bp) Appid:*LOCAL.p2 alius1.06012812 1254
oper_system_ser vices 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 1854
Richard McCutcheon wrote:
2006-01-25-06.20.02.489192 Instance:p2aliu s1 Node:000
PID:2085100(db2 bp) Appid:*LOCAL.p2 alius1.06012812 1254
oper_system_ser vices 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
6546
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 Workshop program: hcw.exe that's included with Visual Basic. This exact same file compiled perfectly with no notes, warnings or errors prior to reformatting my system. Prior to the reformatting, I copied the help.rtf file onto a CD and checked the box to...
2
3551
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 lexPOV.cxx file in the package, but I can not find any POV keywords in any file ( there are about 150 POV keywords). Did i miss it, and if not, how do I create one and include it for the library building ?
7
2502
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 to get my MSDN documentation to work?!? I'm dead in the water here, so any help is greatly appreciated. Tom
2
384
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
4351
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 predecessor, I hasten to add) so that each day it creates a copy of the record for each company, changes the date to today's date, and prompts the user for any changes of ratings on that day. The resulting data table grows by approx 600 records per...
7
5375
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 from clicking on many of the available topics (mostly methods but some properties are also unavailable). This same problem occurs with many, if not most, keywords. Is there any way I can activate these "missing" help topics? HELP!
1
1589
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 I want to append the records. Unfortunately the MS access book is out of the library. Does any one know how to supress these dialog boxes (i.e., say yes to every box that appears)? Thanks in advance Donagh
7
3283
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 I believe if it's solved, the remaining stuff is easy... my full program until now is here: http://www.geocities.com/tom4_h4wk/progmail.zip the problem is the segmentation fault when main trys to run leficheiro.c.... the *.c2 files are the...
2
5816
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 Probe:443 Database:DB2XXX DIA9999E An internal error occurred. Report the following error code : "0xFFFF8544". 2007-03-23-11.08.12.495222 Instance:db2inst1 Node:000 PID:204782(db2agent (DB2XXX)) Appid:*LOCAL.db2inst1.070323232921
0
8674
marktang
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...
0
9023
jinu1996
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 captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
8893
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
8861
tracyyun
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...
1
6518
isladogs
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 instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5860
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();...
0
4366
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...
0
4615
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
2
2327
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

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.