Code: Select all
target_load,7: SQL0911N The current transaction has been rolled back because of a deadlock or timeout. Reason code "68". SQLSTATE=40001
Before this job was submitted, the DBA made sure there were no locks on the database.
There were no issues with this job before and recently we are having these deadlock , timeout issues.
Is it true that PX holds a lock on the database object that is not visible in DB2?
Appreciate any valuable feedback from DS Gurus.
Thanks