469,903 Members | 1,902 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,903 developers. It's quick & easy.

DB2ConnectionCorrelator error on DB2 9.1

Hello,

I have a custom task manager application that makes a call to a stored
procedure with an output parameter.

To achieve this, I constructed the stored procedure in an atomic
statement as follows:

BEGIN ATOMIC DECLARE v_out integer; set v_out = 0; call task_proc(80,
v_out); END

This worked fine on DB2 v8 but gives the following error on DB2 v9:

actual code point, 8723 does not match expected code point, 9224
DB2ConnectionCorrelator: AC103072.H37B.070122094024

I'm running DB2 9.1. Is this perhaps a DB CFG setting that I must
adjust?

Thank you.

Jan 22 '07 #1
2 6952
db2inst2 wrote:
Hello,

I have a custom task manager application that makes a call to a stored
procedure with an output parameter.

To achieve this, I constructed the stored procedure in an atomic
statement as follows:

BEGIN ATOMIC DECLARE v_out integer; set v_out = 0; call task_proc(80,
v_out); END

This worked fine on DB2 v8 but gives the following error on DB2 v9:

actual code point, 8723 does not match expected code point, 9224
DB2ConnectionCorrelator: AC103072.H37B.070122094024

I'm running DB2 9.1. Is this perhaps a DB CFG setting that I must
adjust?
What's the complete error message that you got?

At first glance, I would say that something in V9 doesn't quite work as
expected...

--
Knut Stolze
DB2 z/OS Utilities Development
IBM Germany
Jan 22 '07 #2
I solved this problem by using the JDBC driver that is bundled with v9.
Was originally using the older v8 driver.

db2inst2 wrote:
Hello,

I have a custom task manager application that makes a call to a stored
procedure with an output parameter.

To achieve this, I constructed the stored procedure in an atomic
statement as follows:

BEGIN ATOMIC DECLARE v_out integer; set v_out = 0; call task_proc(80,
v_out); END

This worked fine on DB2 v8 but gives the following error on DB2 v9:

actual code point, 8723 does not match expected code point, 9224
DB2ConnectionCorrelator: AC103072.H37B.070122094024

I'm running DB2 9.1. Is this perhaps a DB CFG setting that I must
adjust?

Thank you.
Jan 22 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

5 posts views Thread by Tony Wright | last post: by
1 post views Thread by Aravind | last post: by
1 post views Thread by yanwan | last post: by
7 posts views Thread by p | last post: by
reply views Thread by Salome Sato | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.