DB2 8.2 on AIX
Online database backup fails.(SQLCODE -911, Reason Code 68) if an INPLACE REORG is in progress on a table in the database.
Curious to know what the conflicting lock is here, that causes a timeout? Any idea?
If it makes a difference, the table is in SMS tablespace.
Visit the new-look IDUG Website , register to gain access to the excellent content.
I am not sure what is causing the problem either. It looks like the reorg has a bunch of Intent-None (IN) row locks. The only thing that this would prevent is a super-exclusive (Z) lock, and I do not see how the online backup would try that.
The only thing I can suggest is to monitor the lock chain that occurs during the lock wait. This should give you a better insight as to what is causing the problem. Other than that, you can open a PMR with IBM to get an answer.
The problem of addressing a lockwait timeout issue is catching the lockwait. You have to constantly keep snapshot monitoring the lock situation with an interval between snapshots less than the lockwait timeout value. So, if as in your condition, the lockwait timeout value is 15 seconds, you have to get the snapshots every 10 seconds or so. This can be very tedious and rather boring if done manually. If you automate it, you will have tons of data to sift through.