By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,983 Members | 1,597 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,983 IT Pros & Developers. It's quick & easy.

From Oracle to db2 Federation - db2 "crash"

P: 10
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
Share this Question
Share on Google+
1 Reply

P: 112
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.