Unanswered: Selecting Record results in Lock Timeout
I have a table that has two records that if they are queries result in a Lock Timeout. For instance:
select * FROM FBNEXUS.FBLOCATION WHERE locationid=231959
SQL0911N The current transaction has been rolled back because of a deadlock
or timeout. Reason code "68". SQLSTATE=40001
All other records in the table can be queried without problem. When taking a snapshot, I do see that there is one reorg that is also in a lock wait status. But otherwise, I cannot figure out what is keeping these records from being read. Out of desperation, I did bounce the db2 server, but the problem remained.
1. Is there some way I can force DB2 to "release" whatever is keeping these records from being read?
2. What circumstances can lead to a record being held in such a way that trying to read it results in a lock timeout?