Oracle Connector Deadlock Issue
Moderators: chulett, rschirm, roy
Oracle Connector Deadlock Issue
Hi,
My Datastage job loads data to Oracle table with below properties
Write Mode: Update then Insert
Table Action : Append
Record Count : 100000
Array Size: 2000
Today the job failed (Update Query failed) with Deadlock issue
"The OCI function OCIStmtExecute returned status 1. Error code: 60, Error message: ORA-00060: deadlock detected while waiting for resource."
"The connector is not able to resume the write operation because multiple arrays of data were written to the database on one or more input links under the transaction that was active at the time of failover."
Is this because of Record Count and Array size being different. For Update operations, do we need to keep them same?
From: http://pic.dhe.ibm.com/infocenter/iisin ... 4050W.html
Please suggest.
My Datastage job loads data to Oracle table with below properties
Write Mode: Update then Insert
Table Action : Append
Record Count : 100000
Array Size: 2000
Today the job failed (Update Query failed) with Deadlock issue
"The OCI function OCIStmtExecute returned status 1. Error code: 60, Error message: ORA-00060: deadlock detected while waiting for resource."
"The connector is not able to resume the write operation because multiple arrays of data were written to the database on one or more input links under the transaction that was active at the time of failover."
Is this because of Record Count and Array size being different. For Update operations, do we need to keep them same?
From: http://pic.dhe.ibm.com/infocenter/iisin ... 4050W.html
Please suggest.
-
- Participant
- Posts: 251
- Joined: Mon Jun 09, 2008 5:52 am
-
- Participant
- Posts: 251
- Joined: Mon Jun 09, 2008 5:52 am