Hello, I've studied and I discovered somethings. I'm not absolutely sure, but I understand that Mainframe is different from others.
> -----Original Message----- > From: Fazal, Syed (TATA) > > 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. In AIX/UNIX I didn't find anything about PAGE. All informatin I found was about ROW or TABLE lock. I discovered that lock is a table configuration, and you can alter that using command ALTER TABLE # db2 alter table <tabela> locksize <ROW / TABLE > And, to check actual configuration at database, you can use SYSCAT.TABLES # db2 select tabname, locksize from syscat.tables I found all this information about lock in DB2/AIX using information about LOCK in Mainframe that you answer to this list. If I am wrong, please correct me. :) Thanks for all help in list, I hope I've had contributed with some useful information... :) Regards, 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.504 / Virus Database: 302 - Release Date: 24/7/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
