By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
448,486 Members | 1,024 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 448,486 IT Pros & Developers. It's quick & easy.

An SQL error "-911" occurred during processing

P: n/a
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
Share this Question
Share on Google+
1 Reply


P: n/a
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.