Timeout and Locking Tables

[reddy]

Hello Gurus,

Some of my jobs are failing some times because of Timeout (even we are not using hash files) problem and some are locking database tables

Please give me suggestions on how to rectify these problems.

Thanks in advance.

Thanks
Narasa

[Kirtikumar]

If you are using database stages, then changing transaction and array size to 1 may help.
But this will affect the performance as after each row commit will be executed after any update or insert statement on target DataBase stage.

We have faced this problem when we were using a table for reference and we were updating the same table as target stage.
Changing the transaction and array size to 1 helped to remove this error.

Hope this helps.