Return
-
Title
select * from table results in lock which cannot be released -
Description
Select * from table results in lock which cannot be released.
Tools | Options | Database | General:
- Number = 1000
- Apply to editor is checked
- Commit after each statement is checkedselect * from large_table shows 1000 rows and the query is cancelled automatically.. This can cause an exclusive lock on the tables involved.ÂIn DB2M query shows as "Last operaton = SQL Static Commit" and "Locks currently held = 4".ÂA Load started by a different user then fails because of deadlock.ÂSometimes "Disconnect all" resolves the problem, sometimes it doesn't.
Sign In Required
You need to be signed in and under a current maintenance contract to view premium knowledge articles.