468,532 Members | 1,830 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

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

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 2146
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 this site, you agree to our Privacy Policy and Terms of Use.