SQL0911N with RC=68 means "transaction rolled back due to lock timeout".
So maybe check your LOCKTIMEOUT setting or snapshot (if there is) to see
if the target table is locked by another application.

About LOAD utility and LOCK, you can refer to DB2 Info Center ->
Administrating -> Database System -> Moving Data -> Loading Data.

Bandaru Jayaprakash wrote:

>Hi,
>
>I am getting the following error when trying to load the data into a
>table. I have terminated the load once on this table
>And trying to restart the data on that table.
>
>"SQL0911N The current transaction has been rolled back because of a
>deadlock
>or timeout. Reason code "68". SQLSTATE=40001".
>
>If anybody has idea about this, please let me know.
>
>Thanks,
>Jayaprakash.
>
>
>
>---------------------------------------------------------------------
>PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
>website: http://www.LazyDBA.com
>To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
>
>
>


DB2 & UDB email list listserv db2-l LazyDBA home page