Hi,
A few datastage jobs seem to 'hang' while updating an Oracle Table.
This has occured ever since the Oracle DBAs have started using PIT (Point-In-Time) technology to create snapshots of a database (for our development environment)
When you stop the datastage job, the oracle connection remains active.
So, on re-running the job, another oracle connection is created, which according to the DBA's, is locked out by the other existing connection.
They are unable to resolve this matter as yet, so I'm wondering if any other Oracle DS users have experienced similar problems....
Job 'hangs' while writing to Oracle 'PIT' database
Moderators: chulett, rschirm, roy
It's always been an issue that DS Server threads get zombied when you Stop a job. It's your responsibility to do a "ps -ef|grep phantom" after stopping jobs to make sure there aren't zombies out there. You can kill them or ask that a DBA kill the Oracle session which will let the zombie die.
Kenneth Bland
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle