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

Parsing errors in db2diag log

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:

2005-11-17-09.55.31.988098-420 E5537C330 LEVEL: Error (OS)
PID : 21700 TID : 1 PROC : db2pclnr 0
INSTANCE: hdbuser NODE : 000
FUNCTION: DB2 UDB, oper system services, sqloDispatchNBlocks, probe:30
CALLED : OS, -, unspecified_system_function
OSERR : EFAULT (14) "Bad address"

2005-11-17-09.55.31.989606-420 I5868C367 LEVEL: Severe
PID : 21700 TID : 1 PROC : db2pclnr 0
INSTANCE: hdbuser NODE : 000
FUNCTION: DB2 UDB, buffer pool services, sqlbClnrDispatchSomeAIO,
probe:100
MESSAGE : writeStatus =
DATA #1 : Hexdump, 8 bytes
0x2FF21270 : 0000 0000 0000 0000 ........
These entries are from a db2diag.log file on our systems. The first one
has a "code" of C330 and the second a "code" of C367. The C330 and C367
are the same for identical log messages. The only thing that changes is
the date/time and the numbers before the C330 and C367. So, I assumed I
could check for these types of errors. My problem is I can relate that
number to anything I can find in documentation. Are these numbers valid
to check? We already have code to check the sql errors from APIs so I
am not sure I need to parse for those.

I looked at the db2diag tool but it seemed quite cumbersome for what I
needed and is confusing to use in my opinion.

Has anyone done anything like this, can help identify what the codes
are, or have any suggestions? I am on AIX 5.3.

Jan 26 '06 #1
2 2388
I would suggest you to reconsider in favor to using db2diag because, as
far as I know, most of the codes/keywords/messages in the db2diag.log
are not documented and can be changed by IBM at any time which will
break your parser.

-Eugene

Jan 26 '06 #2
If that is the case then I am in trouble no matter what I do since I
need to check for specific errors. If they change them, then my code
has to change to look for the new codes.

I can change to use db2diag so I don't get in trouble with placement of
codes, but that doesn't help me if they actually change. They only
thing I can do in this case if be more generic, which defeats the
purpose. I don't want to send a message for every error or severe level
message in the log. I want to be more precise in what we look at.

Jan 26 '06 #3

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

Similar topics

16
by: Terry | last post by:
Hi, This is a newbie's question. I want to preload 4 images and only when all 4 images has been loaded into browser's cache, I want to start a slideshow() function. If images are not completed...
4
by: Sean C. | last post by:
Helpful folks, I've just migrated our test server from V7.2 -FP11 to V8.1.3, on WinNT 4.0. Everything went pretty darn smoothly, however I get the following errors when using the Control Center:...
7
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....
3
by: yerim y via DBMonster.com | last post by:
Hello there, I am having these recurring errors on the diaglog of my DB2 server and they are the same ones on all databases. Can someone please help me diagnose it. What's making me nervous is the...
4
by: Pierre Saint-Jacques | last post by:
DB21085I Instance "SES" uses "32" bits and DB2 code release "SQL08022" with level identifier "03030106". Informational tokens are "DB2 v8.1.9.917", "OD_14086", "WR21350_14086", and FixPak "9"....
4
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...
0
by: mngrl | last post by:
I have DB2 V8.2 installed on an AIX system and I want to see the sql errors that are occurring on the system. When I look at db2diag.log the messages all look like this: ...
14
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...
6
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.
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
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...
0
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...
0
agi2029
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,...

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.