Update DS job hanging
Posted: Sat Sep 06, 2008 8:30 pm
There is simple parallel DS job which has a data set and Oracle Enterprize Stage. The data is read from data set and rows are updated in table in Oracle. Oracle stage has upsert mode with update statement.
The jobs shows inital 1000 rows are read and then job hangs...DS director is not showing any specific errors. We had to kill job.. We checked with DBAs and there are no table specific locks..
I would appreciate if anybody has encountered this beofre and can offer some advice..
The jobs shows inital 1000 rows are read and then job hangs...DS director is not showing any specific errors. We had to kill job.. We checked with DBAs and there are no table specific locks..
I would appreciate if anybody has encountered this beofre and can offer some advice..