470,836 Members | 1,897 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,836 developers. It's quick & easy.

An SQL error "-911" occurred during processing

DB2 7.2. I do an export each night of important tables.
Nothing else should be touching the DB at this time.
About every 2 days I get the error below on the same tables
most of the time.
What could be causing this??????

SQL3104N The Export utility is beginning to export data to file
"/db2/data/crprod/exports/TBL_PREMINDERS_CA.ixf".

SQL3015N An SQL error "-911" occurred during processing.

SQL0911N The current transaction has been rolled back because of a deadlock
or timeout. Reason code "2". SQLSTATE=40001

SQL3105N The Export utility has finished exporting "9202778" rows.

Thanks

Oct 5 '06 #1
1 21612
Reason Code 02 is a DEAD LOCK.
Reason Code 68 is a LOCK TIME OUT.

So clearly there is a contention for your EXPORT with another process
on that table.
Schedule a DB2 EVENT MONITOR to find the SQL(applications) which are
involved in this DEAD LOCK.
Cheers...
Shashi Mannepalli
Willard Farwark wrote:
DB2 7.2. I do an export each night of important tables.
Nothing else should be touching the DB at this time.
About every 2 days I get the error below on the same tables
most of the time.
What could be causing this??????

SQL3104N The Export utility is beginning to export data to file
"/db2/data/crprod/exports/TBL_PREMINDERS_CA.ixf".

SQL3015N An SQL error "-911" occurred during processing.

SQL0911N The current transaction has been rolled back because of a deadlock
or timeout. Reason code "2". SQLSTATE=40001

SQL3105N The Export utility has finished exporting "9202778" rows.

Thanks
Oct 5 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Oliver Stratmann | last post: by
9 posts views Thread by Mairhtin O'Feannag | last post: by
5 posts views Thread by Kivak Wolf | last post: by
reply views Thread by smkkaleem | last post: by
reply views Thread by mihailmihai484 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.