For DB2: What level of locking should be used?
Article ID: KB0085336
Updated On:
| Products | Versions |
|---|---|
| TIBCO ActiveMatrix BusinessWorks Plug-in for Database | - |
| Not Applicable | - |
Description
Resolution:
Locking is a very complicated subject and depends on a lot of factor. Your Shop DBA should have a better perspective in what best for your needs. DB2 supports locking at four different levels: tablesspace-level locking, table-level locking, page-level locking and row-level locking. In general, let DB2 handle the level of locking required is best. Specify LOCKSIZE ANY unless it is determined that row-level locking is feasible. In this case specify LOCKSIZE ROW in the “create tablespace” statement.
Locking is a very complicated subject and depends on a lot of factor. Your Shop DBA should have a better perspective in what best for your needs. DB2 supports locking at four different levels: tablesspace-level locking, table-level locking, page-level locking and row-level locking. In general, let DB2 handle the level of locking required is best. Specify LOCKSIZE ANY unless it is determined that row-level locking is feasible. In this case specify LOCKSIZE ROW in the “create tablespace” statement.
Issue/Introduction
For DB2: What level of locking should be used?
Feedback
Yes
No
Powered by
