Help on DB2 log mesg

[lcklee]

Can someone tell me what wrong is this log mesg stands for ?
my DB2 is work on AIX.

Feb 19 00:59:23 sftpdb1 DB2[31406]: DB2 (db2inst1.000) INFO oper_system_services sqlofica reports: probe id 10 with error 2055 and alert num 0
Feb 19 00:59:23 sftpdb1 DB2[31406]: data: 53514c43 41202020 00000088 fffffed3 SQLCA ....ÿÿþÓ
Feb 19 00:59:23 sftpdb1 DB2[31406]: data: 00002020 20202020 20202020 20202020 ..
Feb 19 00:59:23 sftpdb1 DB2[31406]: data: 20202020 20202020 20202020 20202020

 

[gregsimpson]

IBM seem to think this is a bug.

http://dbforums.com/arch/39/2002/3/328794

Cheers
Greg

 

[MarcLodge]

It could be something to do with the maximum number of locks as implied in this article (you have to find 2055 in it):

http://www.cs.yorku.ca/~seela/db2/problem.htm

hth
Marc

 

[lcklee]

MarcLodge (Programmer) Feb 20, 2003
It could be something to do with the maximum number of locks as implied in this article (you have to find 2055 in it):

http://www.cs.yorku.ca/~seela/db2/problem.htm

hth
Marc

thx for reply, but the link require me login password. Can you also give me ?

Calvin

 

[MarcLodge]

How strange! Yesterday, I got hold of this quite happily, but today, it's asking me for a password too. I will examine the cache on the machine that I accessed it on and see if I can get the page and post the specific article.
Marc

 

[MarcLodge]

Calvin,
Fraid I can't get hold of it. Can you tell me what it is you are trying to do when you get the error?

You might section '2.2.2 Format of the SYSLOG' in this link helpful:

http://reference.dexis.net/vajava/redbooks/sg244759.pdf

and if you need to determine the sqlcodes etc. then this link might be of help:

http://webdocs.caspur.it/ibm/web/udb-6.1/db2m0/index.htm

Marc

 

[gregsimpson]

I don't know if your interested but the link I gave you contains exactly what you had in your post in terms of

probe id 10 with error 2055 and alert num 0

Greg

 

[MarcLodge]

Hi Greg how's it going,
I have a feeling that this error message is a bit of a generic one that requires us to look elsewhere for the error. I'm not certain of this, as I can't find any indication as to what error 2055 means. The probe id seems to differ from one run to the next (I think) and it may be a red herring. If you type 'with error 2055 and alert num' into google you get quite a number of different errors, albeit with a different probeid. Do you think the probeid is the key rather than the (meaningless?) error num?

From the info that Icklee has given us in the dump I think that fffffed3 is an sqlcode, and from my digging, I reckon this is a -301. According to the stuff I found, a -301 is a data mismatch when performing a dynamic sql call. I'm therefore curious to see what Icklee was up to when the error came up.

This is all theory, as the link mentioned in my 1st post that we can no longer get into, suggested that it was a running out of available locks to do with memory.

I'm in the dark, so come on back Icklee, let us know what you were up to.

Marc

 

[lcklee]

thx for all your reply.
Let me talk about the background.
I am using AIX DB2 and I have a java application run with the DB2. Now the application is run smooth, however I find that there are many DB2 log message in the AIX syslog. The log is the one I post at my question, I don know why DB2 send the log to syslog and is the log mesg a error mesg....

Is it related to the diaglog level 4 ?