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

Stored Procedure causing lots of entries on db2diag.log ...

P: n/a
Hi,
(LUW 8.2 fp8)
We are getting lots of these messages being logged in the db2diag.log

As far as I can tell, the SP in question is not error'ing, but it
doesn't have an exit handler
defined, could this lack of an exit handler be connected with these
messages?
2007-02-08-16.54.11.835674+000 I151042028A1096 LEVEL: Error
PID : 1110236 TID : 1 PROC : db2agent
(JBSLIV28)
INSTANCE: db2proi1 NODE : 000 DB : JBSLIV28
APPHDL : 0-91 APPID: C0A832BB.BE8F.070201072232
MESSAGE : sqlriInvokeInvoker ignored because of prior condition, probe
184
DATA #1 : Hexdump, 136 bytes
0x000000011198E728 : 5351 4C43 4120 2020 0000 0088 0000 01D2
SQLCA ........
0x000000011198E738 : 0017 4A41 4253 2E4F 425F 4445 4C49
5645 ..JABS.OB_DELIVE
0x000000011198E748 : 5259 5F43 484B FF31 FF20 2020 2020 2020 RY_CHK.
1.
0x000000011198E758 : 2020 2020 2020 2020 2020 2020 2020 2020
0x000000011198E768 : 2020 2020 2020 2020 2020 2020 2020 2020
0x000000011198E778 : 2020 2020 2020 2020 5351 4C43 534D
4342 SQLCSMCB
0x000000011198E788 : 893E 001A 0000 001A 0000 0000 0000
0000 .>..............
0x000000011198E798 : 0000 0000 0000 0000 2020 2020 2020
2020 ........
0x000000011198E7A8 : 2020 2020 2020 2020

Feb 8 '07 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.