473,499 Members | 1,660 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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 7125
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
4358
by: AIM | last post by:
Error in msvc in building inheritance.obj to build hello.pyd Hello, I am trying to build the boost 1.31.0 sample extension hello.cpp. I can not compile the file inheritance.cpp because the two...
5
16213
by: Tony Wright | last post by:
Hi, I am having a problem installing an msi for a web site. The error message I am getting is: "The specified path 'http://mipdev05/features/Fas2' is unavailable. The Internet Information...
1
8392
by: Aravind | last post by:
we have two files: 1. rc4.c (defines one function "create_pin()") 2. MyImpl.c(calling the function "create_pin()"),This implements JNI method. 1.When I am trying to create .dll file with one...
1
6381
by: yanwan | last post by:
I met this problem in executing a c++ project in visual studio. Does anyone have suggestions to resolve "error lnk 2001"? --------------------Configuration: reconstruction - Win32...
13
6569
by: deko | last post by:
I use this convention frequently: Exit_Here: Exit Sub HandleErr: Select Case Err.Number Case 3163 Resume Next Case 3376 Resume Next
7
4976
by: p | last post by:
WE had a Crystal 8 WebApp using vs 2002 which we upgraded to VS2003. I also have Crystal 9 pro on my development machine. The web app runs fine on my dev machine but am having problems deploying....
0
4033
by: mail2bharatsimha | last post by:
Hi, I'm getting this error. I use ojb with spring as my persistence layer. org.springframework.jdbc.UncategorizedSQLException: OJB operation; uncategorized SQLException for SQL ; SQL state ;...
2
19393
hyperpau
by: hyperpau | last post by:
Before anything else, I am not a very technical expert when it comes to VBA coding. I learned most of what I know by the excellent Access/VBA forum from bytes.com (formerly thescripts.com). Ergo, I...
0
2897
hyperpau
by: hyperpau | last post by:
Before anything else, I am not a very technical expert when it comes to VBA coding. I learned most of what I know by the excellent Access/VBA forum from bytes.com (formerly thescripts.com). Ergo, I...
0
7134
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,...
0
7014
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
7229
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...
1
6905
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...
0
7395
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
5485
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,...
1
4921
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...
0
4609
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...
0
3108
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...

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.