Exforsys

Online Training

Locking Levels

This is a discussion on Locking Levels within the DB2 forums, part of the Database category; I want to know about the locking levels available in DB2. If someone could mention it here it would be ...


Go Back   Exforsys > Database > DB2

Locking Levels Locking Levels

Register FAQ Members List Calendar Search Today's Posts Mark Forums Read

Reply

 

LinkBack Thread Tools
  #1 (permalink)  
Old 12-18-2006, 02:42 AM
Senior Member
  
Join Date: Apr 2006
Posts: 145
Rahulbatra is on a distinguished road
Locking Levels
I want to know about the locking levels available in DB2. If someone could mention it here it would be of great help.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 12-19-2006, 03:31 PM
Senior Member
  
Join Date: Apr 2006
Posts: 162
sammy is on a distinguished road
I know that for sure PAGE and TABLE are the locking levels available in DB2. But I doubt whether TABLESPACE is also a locking level available in DB2. Someone has to clarify this.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #3 (permalink)  
Old 04-07-2007, 09:28 AM
Senior Member
  
Join Date: Apr 2006
Posts: 145
Rahulbatra is on a distinguished road
The locking levels available in DB2 are PAGE, TABLE and TABLESPACE. You can lock in any of the three levels in DB2 database.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #4 (permalink)  
Old 04-09-2007, 07:53 AM
Senior Member
  
Join Date: Apr 2006
Posts: 141
Adrian is on a distinguished road
The available locking levels in DB2 are PAGE, TABLE and TABLESPACE. Hope you want to know about this. Let me know if you have any other query.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply

« How to Remove | Implement Join »
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads

Thread Thread Starter Forum Replies Last Post
Isolation levels ashlee SQL Server 0 12-14-2006 05:42 AM
Clovis, Various Domains and Exp Levels, BE/BTech/MCA Bangalore lokeshm Experienced Job Seekers - India 0 09-26-2006 04:35 PM
Solving Lazy Initialization and double checked locking problem Vinay Aggarwal Software Patterns 19 02-18-2004 05:34 PM


All times are GMT -4. The time now is 08:31 PM.

Contact Us - Exforsys - Archive - Privacy Statement - Top

Powered by vBulletin® Version 3.7.3
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.1.0
Copyright 2004 - 2007 Exforsys Inc. All rights reserved.