Products | Versions |
---|---|
TIBCO ActiveMatrix BusinessWorks Plug-in for Database | - |
Not Applicable | - |
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.