471,084 Members | 801 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,084 software developers and data experts.

From Oracle to db2 Federation - db2 "crash"

Hello everyone,

I have a problem with federation between Oracle and DB2. Once every few weeks my DB2 federation request "dies". What happens is DB2 thinks it is still geting information from oracle, but on Oracle there is nothing executing. This connection then stays active for undefined amount of time ( 5 days was the last accurance).

Killing the process doesnt work, all I can do to remove it is to restart the server.

Db2stop force doesnt do the job it just waits there. Normal db2stop force, stops db2 in 5 minutes. I have waited for 2 hours before i restarted the server.

I checked db2diag.log and there is nothing there ( diaglevel 3 ).

Any ideas are welcome.

With regards,

Marko Kozjak
Sep 2 '09 #1
1 2211
112 100+
There are lot many things that should be there before diagnosing this issue. Better raise a call with IBM.

Cheers, Vijay
Sep 5 '09 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

134 posts views Thread by James A. Donald | last post: by
28 posts views Thread by Robert Gamble | last post: by
2 posts views Thread by cs | last post: by
4 posts views Thread by jason.awlt | last post: by

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.