DSXchange

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....

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.