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

re: From Oracle to db2 Federation - db2 "crash"

There are lot many things that should be there before diagnosing this issue. Better raise a call with IBM.

Cheers, Vijay