The optimizer will always attempt to give you row locks as they provide better cooncurrency. That's the way you can understand the default as none is set.
You can force DB2 to give you only table lock by using the proper parm in table create/alter command.
You can also issue the SQL stmt. LOCK TABLE in <share/exclusive> MODE if you want to do this selectively. These are strict table locks and will not provide row locks.
HTH, Pierre.
Carla Cristina Alonzo Ducl�s wrote:
Hello,
I'm here again. :)
I'd like to know if DB2 does row lock or only page lock. I found at documentantion that there is a row lock mode.
How can I check if my database is configured to row lock mode or page lock mode? How can I change this configuration if I want to?
If anyone knows or if anyone indicate me a good documentation about this, I'll be gratefull.
Thank you,
Carla
Carla Alonzo Ducl�s Systems Administrator SoLvo - Servi�os de Miss�o Cr�tica @ www.solvo.com.br
--- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.495 / Virus Database: 294 - Release Date: 30/6/2003
- ::: When replying to the list, please use 'Reply-All' and make sure ::: a copy goes to the list ([EMAIL PROTECTED]). *** To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED] *** For more information, check http://www.db2eug.uni.cc
-- Pierre Saint-Jacques, IBM Certified Solutions Expert - Administration SES Consultants Inc. 514-737-4515
- ::: When replying to the list, please use 'Reply-All' and make sure ::: a copy goes to the list ([EMAIL PROTECTED]). *** To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED] *** For more information, check http://www.db2eug.uni.cc
