Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Locking used when both ISOLATION(CS) & ACQUIRE(USE) pres

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
sasanka
Warnings : 1

New User


Joined: 18 Jan 2008
Posts: 34
Location: India

PostPosted: Thu Apr 22, 2010 11:57 am    Post subject: Locking used when both ISOLATION(CS) & ACQUIRE(USE) pres
Reply with quote

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
View user's profile Send private message

dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6968
Location: porcelain throne

PostPosted: Thu Apr 22, 2010 5:01 pm    Post subject:
Reply with quote

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
View user's profile Send private message
sushanth bobby

Senior Member


Joined: 29 Jul 2008
Posts: 1013
Location: India

PostPosted: Thu Apr 22, 2010 6:13 pm    Post subject:
Reply with quote

sasanka,

If you locksize is row, only 5 records will be locked. But overhead is more.

Sushanth
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts DB2 10.1 Share level locking and Sele... Mary Lewis DB2 1 Wed Apr 15, 2015 9:51 pm
This topic is locked: you cannot edit posts or make replies. Locking question VarunJ1991 IMS DB/DC 1 Mon Mar 11, 2013 9:17 pm
No new posts GDG Locking after reaching maximum limit riteshsingh92 JCL & VSAM 17 Thu Feb 07, 2013 1:56 pm
No new posts transactions locking files sandy mf CICS 2 Fri Jan 20, 2012 7:14 pm
No new posts Current Isolation level Pandora-Box DB2 2 Fri Jan 13, 2012 6:59 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us