467,189 Members | 1,338 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

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

DB2-Mystery with Multithreading and new compiler


I have an unusual Problem with DB2.
It is DB2 Version 7 and Fixpack 13 under Windows.

We have written an application server which is accessing db2 via c++
and the cli interface.
We used IBM Visual Age as our compiler, because we had to support OS/2.

Now we ported it this year to windows and the microsoft-compiler (V8).
The access methods, the cli calls and so on didn't change.

Now the Problem:
The application server has to use multithreading to handle the client
requests. With the "old" server, everything is ok.
With the "new" server, on the same database, with the same settings,
multithreading doesn't work.
DB2 acts, as if the "MULTICONNECT" cli-property was not set. But the
db2cli.ini is default and the default value for MULTICONNECT is "1".
All funcion calls run without errors, I get different connection
But when I run a long SQL-statement for example, every other request is
The CLI is waiting at the "SQLAllocHandle (SQL_HANDLE_STMT ..."

I'm sitting here and I don't find any solution. It is exactly the same
system, the same database, the same CLI settings, the same accessing

And the most confused is:
I tried DB2 Version 8.2 and there, everything is running right.
I hope I could make myself clear, if there are any questions, ask.

I hope there are any ideas here.



May 10 '06 #1
  • viewed: 1053

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by richardshen@canada.com | last post: by
138 posts views Thread by Ian Boyd | last post: by
1 post views Thread by Massimiliano Campagnoli | last post: by
5 posts views Thread by news.cyberlink.ch | last post: by
3 posts views Thread by Anoop | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.