|
View previous topic :: View next topic
|
| Author |
Message |
sasanka
Warnings : 1
New User
Joined: 18 Jan 2008
Posts: 34
Location: India
|
|
|
|
Hi,
Consider a COBOL-DB2 application program contains a SQL query which tries to access 5 records from a table. When creating BIND PLAN, I am using both ISOLATION(CS) and ACQUIRE(USE) options. Suppose all the 5 recods are on the same page of the same table space and each table space contains 20 pages. My question is, when the SQL query will run which locking strategy is used; that means only that particular page is locked or that whole table space is locked. |
|
| Back to top |
|
 |
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne
|
|
|
|
first, db2 tables have ROWS not records....
second, I would look-up and read about locking.
understanding db2 locking
there are 321,000 topics for db2 locking in google. |
|
| Back to top |
|
|
sushanth bobby
Senior Member
Joined: 29 Jul 2008
Posts: 1020
Location: India
|
|
|
|
sasanka,
If you locksize is row, only 5 records will be locked. But overhead is more.
Sushanth |
|
| Back to top |
|
|
|
|
