Job failure issue

[chandra.shekhar@tcs.com]

Hi,

One of my jobs aborted giving the following error:-

Code: Select all

"An insert, update, or delete statement failed to run. (CC_DB2DBStatement::processRowStatusArray, file CC_DB2DBStatement.cpp, line 2,367)".

I dont know what this is? I reset my job and restarted it and surprisingly it ran suucessfully!!

Can some body explain what happened during the first run??

[ray.wurlod]

Maybe the database wasn't ready, or another process had a lock, or some other condition that had been cleared by the time you re-ran the job. There's probably some diagnostic information in the database's logs.

[chandra.shekhar@tcs.com]

Thanx Ray,

I guessed that more than 1 records were trying to insert at the same time, so thats why the insert statement failed to execute.
Can this also might be one of the reason??

[ray.wurlod]

Probably not. The error is "statement failed to run". Something in the database server actually prevented execution of the statement.

[chandra.shekhar@tcs.com]

Ok,
But we are still trying to find the root cause.
No success yet