Re: [DB2EUG] DB2 Row Lock

[Pierrre Saint-Jacques]

I hadn't realized this was for a zSeries environment. zSeries - DB2 - Row,Page,Table  locking - DB2/zOS e,xSeries - Row, Table locking - DB2 Win/AIX/UNIX/Solaris/Linux iSeries - I'm not sure but I think Row, Table. - DB2/400 Sorry for mix up,  Pierre. Fazal, Syed (TATA) wrote: Hello Pierre~ I am not sure if Locking mechanism is different in AIX/UNIX and others compared to Mainframe. My thinking based on experience with DB2 on mainframe was that the default locking in DB2 is PAGE. When you specify NONE then DB2 decides which type of lock it will use for the specific request. They can be Row,Page, Table or Tablespace also LOB. There is overhead for Row level locking compared to any other locking. Row level locking is only used when you want other users to access uncommitted data and data availability is a issues for users. Generally when a tablespace is defined the lock parameter is defined as NONE so that DB2 can decide what locking is good at that moment. Syed -----Original Message----- From: Pierrre Saint-Jacques [mailto:[EMAIL PROTECTED]] Sent: Friday, July 25, 2003 12:21 PM To: Carla Cristina Alonzo Duclós Cc: [EMAIL PROTECTED] Subject: Re: [DB2EUG] DB2 Row Lock DB2 does row locak and table lock, no page lock. 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