Locking

Hi, As I know by default Informix use page locking, unless if has been defined otherwise during table creation. How is possible to change locking mechanism to row for all tables (and not for each table individually) OS wWndows 2000, Informix IDS 9.30 TC3 Thanks in advance Sergios Disclaimer This message may contain privileged - confidential information and is intended exclusively to the addressees (or any person in charge to deliver to the addresses) . If you are not the intended recipient, you may not use, copy, distribute or deliver this message (or part of its contents) to anyone or take any action in reliance on it. In such a case, you should destroy this message, and notify the sender. All reasonable precautions have been taken to ensure no viruses are present in this e-mail. However, as Internet is a non secure environment; we will bear no responsibility for any loss or damage arising from the use of this e-mail or attachments. Thus, we recommend that you subject these to your virus checking procedures prior to use. If any investment information is contained herein, it has been provided to you for informational purposes only and may not be relied upon in the process of evaluating the merits of investing in any financial instruments referred to herein. It is not a research report, a trade confirmation or an offer or solicitation of an offer to buy/ sell any financial instruments Views, opinions, conclusions and other information expressed in this e-mail are not given or endorsed by Marfin Egnatia Bank S.A. Group of Companies unless otherwise indicated by an authorized representative independent of this message. Ãíùóôïðïßçóç/ Áðïðïßçóç Åõèýíçò Tï ðáñüí ìÞíõìá åíäÝ÷åôáé íá ðåñéëáìâÜíåé åìðéóôåõôéêÝò – áðüññçôåò ðëçñïöïñßåò êáé áðåõèýíåôáé áðïêëåéóôéêÜ óôïõò óêïðïýìåíïõò ðáñáëÞðôåò (Þ õðåýèõíï ãéá ôçí ðáñÜäïóÞ ôïõ óôïõò áíôßóôïé÷ïõò óêïðïýìåíïõò ðáñáëÞðôåò). Óå ðåñßðôùóç ðïõ ðåñéÝëèåé óå åóÜò áðü ëÜèïò, äåí èá ðñÝðåé íá ÷ñçóéìïðïéÞóåôå, áíôéãñÜøåôå, äéáíåßìåôå Þ ðáñáäþóåôå óå ïðïéïíäÞðïôå ôï ðáñüí ìÞíõìá (Þ ôìÞìá ôïõ ðåñéå÷ïìÝíïõ ôïõ), ïýôå íá ðñïâåßôå óå ïðïéáäÞðïôå åíÝñãåéá âÜóåé áõôïý. Óôçí ðåñßðôùóç áõôÞ èá ðñÝðåé íá êáôáóôñÝøåôå ôï ðáñüí ìÞíõìá êáé íá åéäïðïéÞóåôå ôïí áðïóôïëÝá. ¸÷ïõí ëçöèåß üëá ôá åýëïãá ìÝôñá áóöáëåßáò ðñïêåéìÝíïõ ôï ðáñüí ìÞíõìá íá ìçí ðåñéëáìâÜíåé éïýò. ÄåäïìÝíïõ üôé ç åðéêïéíùíßá ìÝóù äéáäéêôýïõ (Internet) äåí åßíáé áóöáëÞò, äåí áðïäå÷üìáóôå ôçí åõèýíç ãéá ïðïéáäÞðïôå æçìßá Þ áðþëåéá ðñïêýøåé áðü ôç ÷ñÞóç ôïõ ðáñüíôïò Þ ôùí óõíçììÝíùí ôïõ êáé óõíéóôïýìå íá ôï õðïâÜëåôå óôéò äéáäéêáóßåò ðñüëçøçò éþí ðïõ äéáèÝôåôå ðñéí ôç ÷ñÞóç áõôïý. Áí ôï ðáñüí ðåñéëáìâÜíåé ðëçñïöïñßá åðåíäõôéêïý ðåñéå÷ïìÝíïõ, áõôÞ ðáñÝ÷åôáé áðïêëåéóôéêÜ ãéá åíçìåñùôéêïýò óêïðïýò êáé äåí èá ðñÝðåé íá âáóéóôåßôå óå áõôÞ êáôÜ ôçí áîéïëüãçóç ôçò óêïðéìüôçôáò ôçò åðÝíäõóçò óå ïðïéáäÞðïôå áðü ôá ÷ñçìáôïïéêïíïìéêÜ ðñïúüíôá ðïõ ôõ÷üí áíáöÝñïíôáé. Ôï ðáñüí äåí áðïôåëåß áíÜëõóç, åðéâåâáßùóç óõíáëëáãÞò Þ ðñïóöïñÜ Þ ðñïþèçóç ðñïóöïñÜò ãéá áãïñÜ/ ðþëçóç ïðïéùíäÞðïôå ÷ñçìáôïïéêïíïìéêþí ðñïúüíôùí. Ïé áðüøåéò, ãíþìåò, óõìðåñÜóìáôá êáé Üëëåò ðëçñïöïñßåò ðïõ ðåñéëáìâÜíïíôáé óôï ðáñüí ìÞíõìá çëåêôñïíéêïý ôá÷õäñïìåßïõ äåí äßäïíôáé ïýôå Ý÷ïõí åãêñéèåß áðü ôéò åôáéñåßåò ôïõ Ïìßëïõ Marfin Åãíáôßá ÔñÜðåæá Á.Å., åêôüò åÜí äçëùèåß ôï áíôßèåôï áðü åîïõóéïäïôçìÝíï åêðñüóùðü ôïõ áíåîáñôÞôùò ôïõ ðáñüíôïò.

Sergios Zagotsis said: > Hi, > > As I know by default Informix use page locking, unless if has been defined > otherwise during table creation. > > How is possible to change locking mechanism to row for all tables (and not > for each table individually) > > OS wWndows 2000, Informix IDS 9.30 TC3 Not in that version. A later version, I'm not sure which, does offer an onconfig parameter. I think it's 10.0, but I'm not sure. And 9.30 is out of support. ;o) -- Bye now, Obnoxio http://obotheclown.blogspot.com/

There is no way to globally change the lockung mode for all existing tables. You have to do them one at a time. If you are creating a new database, you can set an ONCONFIG parameter so that row level locking is the default. That said, changing a whole database isn't hard, just: Unload to fix.sql delimiter ';' Select 'alter table ' || tabname || ' lock mode (row)' From systables Where tabid > 100 and tabtype = ''T'' '; Art -----Original Message----- From: Sergios Zagotsis <szagotsis@marfinbank.gr> Sent: Wednesday, July 30, 2008 8:51 AM To: ids@iiug.org Subject: Locking [12964] Hi, As I know by default Informix use page locking, unless if has been defined otherwise during table creation. How is possible to change locking mechanism to row for all tables (and not for each table individually) OS wWndows 2000, Informix IDS 9.30 TC3 Thanks in advance Sergios Disclaimer This message may contain privileged - confidential information and is intended exclusively to the addressees (or any person in charge to deliver to the addresses) . If you are not the intended recipient, you may not use, copy, distribute or deliver this message (or part of its contents) to anyone or take any action in reliance on it. In such a case, you should destroy this message, and notify the sender. All reasonable precautions have been taken to ensure no viruses are present in this e-mail. However, as Internet is a non secure environment; we will bear no responsibility for any loss or damage arising from the use of this e-mail or attachments. Thus, we recommend that you subject these to your virus checking procedures prior to use. If any investment information is contained herein, it has been provided to you for informational purposes only and may not be relied upon in the process of evaluating the merits of investing in any financial instruments referred to herein. It is not a research report, a trade confirmation or an offer or solicitation of an offer to buy/ sell any financial instruments Views, opinions, conclusions and other information expressed in this e-mail are not given or endorsed by Marfin Egnatia Bank S.A. Group of Companies unless otherwise indicated by an authorized representative independent of this message. Ãíùóôïðïßçóç/ Áðïðïßçóç Åõèýíçò Tï ðáñüí ìÞíõìá åíäÝ÷åôáé íá ðåñéëáìâÜíåé åìðéóôåõôéêÝò – áðüññçôåò ðëçñïöïñßåò êáé áðåõèýíåôáé áðïêëåéóôéêÜ óôïõò óêïðïýìåíïõò ðáñáëÞðôåò (Þ õðåýèõíï ãéá ôçí ðáñÜäïóÞ ôïõ óôïõò áíôßóôïé÷ïõò óêïðïýìåíïõò ðáñáëÞðôåò). Óå ðåñßðôùóç ðïõ ðåñéÝëèåé óå åóÜò áðü ëÜèïò, äåí èá ðñÝðåé íá ÷ñçóéìïðïéÞóåôå, áíôéãñÜøåôå, äéáíåßìåôå Þ ðáñáäþóåôå óå ïðïéïíäÞðïôå ôï ðáñüí ìÞíõìá (Þ ôìÞìá ôïõ ðåñéå÷ïìÝíïõ ôïõ), ïýôå íá ðñïâåßôå óå ïðïéáäÞðïôå åíÝñãåéá âÜóåé áõôïý. Óôçí ðåñßðôùóç áõôÞ èá ðñÝðåé íá êáôáóôñÝøåôå ôï ðáñüí ìÞíõìá êáé íá åéäïðïéÞóåôå ôïí áðïóôïëÝá. ¸÷ïõí ëçöèåß üëá ôá åýëïãá ìÝôñá áóöáëåßáò ðñïêåéìÝíïõ ôï ðáñüí ìÞíõìá íá ìçí ðåñéëáìâÜíåé éïýò. ÄåäïìÝíïõ üôé ç åðéêïéíùíßá ìÝóù äéáäéêôýïõ (Internet) äåí åßíáé áóöáëÞò, äåí áðïäå÷üìáóôå ôçí åõèýíç ãéá ïðïéáäÞðïôå æçìßá Þ áðþëåéá ðñïêýøåé áðü ôç ÷ñÞóç ôïõ ðáñüíôïò Þ ôùí óõíçììÝíùí ôïõ êáé óõíéóôïýìå íá ôï õðïâÜëåôå óôéò äéáäéêáóßåò ðñüëçøçò éþí ðïõ äéáèÝôåôå ðñéí ôç ÷ñÞóç áõôïý. Áí ôï ðáñüí ðåñéëáìâÜíåé ðëçñïöïñßá åðåíäõôéêïý ðåñéå÷ïìÝíïõ, áõôÞ ðáñÝ÷åôáé áðïêëåéóôéêÜ ãéá åíçìåñùôéêïýò óêïðïýò êáé äåí èá ðñÝðåé íá âáóéóôåßôå óå áõôÞ êáôÜ ôçí áîéïëüãçóç ôçò óêïðéìüôçôáò ôçò åðÝíäõóçò óå ïðïéáäÞðïôå áðü ôá ÷ñçìáôïïéêïíïìéêÜ ðñïúüíôá ðïõ ôõ÷üí áíáöÝñïíôáé. Ôï ðáñüí äåí áðïôåëåß áíÜëõóç, åðéâåâáßùóç óõíáëëáãÞò Þ ðñïóöïñÜ Þ ðñïþèçóç ðñïóöïñÜò ãéá áãïñÜ/ ðþëçóç ïðïéùíäÞðïôå ÷ñçìáôïïéêïíïìéêþí ðñïúüíôùí. Ïé áðüøåéò, ãíþìåò, óõìðåñÜóìáôá êáé Üëëåò ðëçñïöïñßåò ðïõ ðåñéëáìâÜíïíôáé óôï ðáñüí ìÞíõìá çëåêôñïíéêïý ôá÷õäñïìåßïõ äåí äßäïíôáé ïýôå Ý÷ïõí åãêñéèåß áðü ôéò åôáéñåßåò ôïõ Ïìßëïõ Marfin Åãíáôßá ÔñÜðåæá Á.Å., åêôüò åÜí äçëùèåß ôï áíôßèåôï áðü åîïõóéïäïôçìÝíï åêðñüóùðü ôïõ áíåîáñôÞôùò ôïõ ðáñüíôïò. ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

Sergio, If I understand your request, here's what I ran in dbaccess......... output to livetst.sql without headings select unique 'alter table '||(tabname)||' lock mode ( row ) ; ' from systables where locklevel = 'P' and tabid > 99 then run "livetst.sql" You may want to take out the line with "locklevel = 'P'" if you have lock modes other than page for you tables. Joe "Sergios Zagotsis" <szagotsis@marfinbank.gr> Sent by: ids-bounces@iiug.org 07/30/2008 07:52 AM Please respond to ids@iiug.org To ids@iiug.org cc Subject Locking [12964] Hi, As I know by default Informix use page locking, unless if has been defined otherwise during table creation. How is possible to change locking mechanism to row for all tables (and not for each table individually) OS wWndows 2000, Informix IDS 9.30 TC3 Thanks in advance Sergios Disclaimer This message may contain privileged - confidential information and is intended exclusively to the addressees (or any person in charge to deliver to the addresses) . If you are not the intended recipient, you may not use, copy, distribute or deliver this message (or part of its contents) to anyone or take any action in reliance on it. In such a case, you should destroy this message, and notify the sender. All reasonable precautions have been taken to ensure no viruses are present in this e-mail. However, as Internet is a non secure environment; we will bear no responsibility for any loss or damage arising from the use of this e-mail or attachments. Thus, we recommend that you subject these to your virus checking procedures prior to use. If any investment information is contained herein, it has been provided to you for informational purposes only and may not be relied upon in the process of evaluating the merits of investing in any financial instruments referred to herein. It is not a research report, a trade confirmation or an offer or solicitation of an offer to buy/ sell any financial instruments Views, opinions, conclusions and other information expressed in this e-mail are not given or endorsed by Marfin Egnatia Bank S.A. Group of Companies unless otherwise indicated by an authorized representative independent of this message. Ãíùóôïðïßçóç/ Áðïðïßçóç Åõèýíçò Tï ðáñüí ìÞíõìá åíäÝ÷åôáé íá ðåñéëáìâÜíåé åìðéóôåõôéêÝò ? áðüññçôåò ðëçñïöïñßåò êáé áðåõèýíåôáé áðïêëåéóôéêÜ óôïõò óêïðïýìåíïõò ðáñáëÞðôåò (Þ õðåýèõíï ãéá ôçí ðáñÜäïóÞ ôïõ óôïõò áíôßóôïé÷ïõò óêïðïýìåíïõò ðáñáëÞðôåò). Óå ðåñßðôùóç ðïõ ðåñéÝëèåé óå åóÜò áðü ëÜèïò, äåí èá ðñÝðåé íá ÷ñçóéìïðïéÞóåôå, áíôéãñÜøåôå, äéáíåßìåôå Þ ðáñáäþóåôå óå ïðïéïíäÞðïôå ôï ðáñüí ìÞíõìá (Þ ôìÞìá ôïõ ðåñéå÷ïìÝíïõ ôïõ), ïýôå íá ðñïâåßôå óå ïðïéáäÞðïôå åíÝñãåéá âÜóåé áõôïý. Óôçí ðåñßðôùóç áõôÞ èá ðñÝðåé íá êáôáóôñÝøåôå ôï ðáñüí ìÞíõìá êáé íá åéäïðïéÞóåôå ôïí áðïóôïëÝá. ¸÷ïõí ëçöèåß üëá ôá åýëïãá ìÝôñá áóöáëåßáò ðñïêåéìÝíïõ ôï ðáñüí ìÞíõìá íá ìçí ðåñéëáìâÜíåé éïýò. ÄåäïìÝíïõ üôé ç åðéêïéíùíßá ìÝóù äéáäéêôýïõ (Internet) äåí åßíáé áóöáëÞò, äåí áðïäå÷üìáóôå ôçí åõèýíç ãéá ïðïéáäÞðïôå æçìßá Þ áðþëåéá ðñïêýøåé áðü ôç ÷ñÞóç ôïõ ðáñüíôïò Þ ôùí óõíçììÝíùí ôïõ êáé óõíéóôïýìå íá ôï õðïâÜëåôå óôéò äéáäéêáóßåò ðñüëçøçò éþí ðïõ äéáèÝôåôå ðñéí ôç ÷ñÞóç áõôïý. Áí ôï ðáñüí ðåñéëáìâÜíåé ðëçñïöïñßá åðåíäõôéêïý ðåñéå÷ïìÝíïõ, áõôÞ ðáñÝ÷åôáé áðïêëåéóôéêÜ ãéá åíçìåñùôéêïýò óêïðïýò êáé äåí èá ðñÝðåé íá âáóéóôåßôå óå áõôÞ êáôÜ ôçí áîéïëüãçóç ôçò óêïðéìüôçôáò ôçò åðÝíäõóçò óå ïðïéáäÞðïôå áðü ôá ÷ñçìáôïïéêïíïìéêÜ ðñïúüíôá ðïõ ôõ÷üí áíáöÝñïíôáé. Ôï ðáñüí äåí áðïôåëåß áíÜëõóç, åðéâåâáßùóç óõíáëëáãÞò Þ ðñïóöïñÜ Þ ðñïþèçóç ðñïóöïñÜò ãéá áãïñÜ/ ðþëçóç ïðïéùíäÞðïôå ÷ñçìáôïïéêïíïìéêþí ðñïúüíôùí. Ïé áðüøåéò, ãíþìåò, óõìðåñÜóìáôá êáé Üëëåò ðëçñïöïñßåò ðïõ ðåñéëáìâÜíïíôáé óôï ðáñüí ìÞíõìá çëåêôñïíéêïý ôá÷õäñïìåßïõ äåí äßäïíôáé ïýôå Ý÷ïõí åãêñéèåß áðü ôéò åôáéñåßåò ôïõ Ïìßëïõ Marfin Åãíáôßá ÔñÜðåæá Á.Å., åêôüò åÜí äçëùèåß ôï áíôßèåôï áðü åîïõóéïäïôçìÝíï åêðñüóùðü ôïõ áíåîáñôÞôùò ôïõ ðáñüíôïò. ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

Whoa I don't even speak gibberish! Art=20 -----Original Message----- From: Art S. Kagel <art.kagel@gmail.com> Sent: Wednesday, July 30, 2008 9:11 AM To: ids@iiug.org Subject: RE: Locking [12966] VGhlcmUgaXMgbm8gd2F5IHRvIGdsb2JhbGx5IGNoYW5nZSB0aGUgbG9ja3VuZyBtb2RlIGZvciB= h=20 bGwgZXhpc3RpbmcgdGFibGVzLiBZb3UgaGF2ZSB0byBkbyB0aGVtIG9uZSBhdCBhIHRpbWUuICB= J=20 ZiB5b3UgYXJlIGNyZWF0aW5nIGEgbmV3IGRhdGFiYXNlLCB5b3UgY2FuIHNldCBhbiBPTkNPTkZ= J=20 RyBwYXJhbWV0ZXIgc28gdGhhdCByb3cgbGV2ZWwgbG9ja2luZyBpcyB0aGUgZGVmYXVsdC4NCg0= K=20 VGhhdCBzYWlkLCBjaGFuZ2luZyBhIHdob2xlIGRhdGFiYXNlIGlzbid0IGhhcmQsIGp1c3Q6DQo= N=20 ClVubG9hZCB0byBmaXguc3FsIGRlbGltaXRlciAnOycNClNlbGVjdCAnYWx0ZXIgdGFibGUgJyB= 8=20 fCB0YWJuYW1lIHx8ICcgbG9jayBtb2RlIChyb3cpJw0KRnJvbSBzeXN0YWJsZXMNCldoZXJlIHR= h=20 YmlkID4gMTAwIGFuZCB0YWJ0eXBlID0gJydUJycgJzsNCg0KQXJ0DQoNCg0KLS0tLS1PcmlnaW5= h=20 bCBNZXNzYWdlLS0tLS0NCkZyb206IFNlcmdpb3MgWmFnb3RzaXMgPHN6YWdvdHNpc0BtYXJmaW5= i=20 YW5rLmdyPg0KU2VudDogV2VkbmVzZGF5LCBKdWx5IDMwLCAyMDA4IDg6NTEgQU0NClRvOiBpZHN= A=20 aWl1Zy5vcmcNClN1YmplY3Q6IExvY2tpbmcgIFsxMjk2NF0NCg0KSGksIA0KDQpBcyBJIGtub3c= g=20 YnkgZGVmYXVsdCBJbmZvcm1peCB1c2UgcGFnZSBsb2NraW5nLCB1bmxlc3MgaWYgaGFzIGJlZW4= g=20 ZGVmaW5lZCANCm90aGVyd2lzZSBkdXJpbmcgdGFibGUgY3JlYXRpb24uIA0KDQpIb3cgaXMgcG9= z=20 c2libGUgdG8gY2hhbmdlIGxvY2tpbmcgbWVjaGFuaXNtIHRvIHJvdyBmb3IgYWxsIHRhYmxlcyA= o=20 YW5kIG5vdCANCmZvciBlYWNoIHRhYmxlIGluZGl2aWR1YWxseSkgDQoNCk9TIHdXbmRvd3MgMjA= w=20 MCwgSW5mb3JtaXggSURTIDkuMzAgVEMzIA0KDQpUaGFua3MgaW4gYWR2YW5jZSANCg0KU2VyZ2l= v=20 cyANCg0KRGlzY2xhaW1lciANCg0KVGhpcyBtZXNzYWdlIG1heSBjb250YWluIHByaXZpbGVnZWQ= g=20 LSBjb25maWRlbnRpYWwgaW5mb3JtYXRpb24gYW5kIGlzIGludGVuZGVkIA0KZXhjbHVzaXZlbHk= g=20 dG8gdGhlIGFkZHJlc3NlZXMgKG9yIGFueSBwZXJzb24gaW4gY2hhcmdlIHRvIGRlbGl2ZXIgdG8= g=20 dGhlIA0KYWRkcmVzc2VzKSAuIElmIHlvdSBhcmUgbm90IHRoZSBpbnRlbmRlZCByZWNpcGllbnQ= s=20 IHlvdSBtYXkgbm90IHVzZSwgY29weSwgDQpkaXN0cmlidXRlIG9yIGRlbGl2ZXIgdGhpcyBtZXN= z=20 YWdlIChvciBwYXJ0IG9mIGl0cyBjb250ZW50cykgdG8gYW55b25lIG9yIHRha2UgDQphbnkgYWN= 0=20 aW9uIGluIHJlbGlhbmNlIG9uIGl0LiBJbiBzdWNoIGEgY2FzZSwgeW91IHNob3VsZCBkZXN0cm9= 5=20 IHRoaXMgbWVzc2FnZSwgDQphbmQgbm90aWZ5IHRoZSBzZW5kZXIuIA0KDQpBbGwgcmVhc29uYWJ= s=20 ZSBwcmVjYXV0aW9ucyBoYXZlIGJlZW4gdGFrZW4gdG8gZW5zdXJlIG5vIHZpcnVzZXMgYXJlIHB= y=20 ZXNlbnQgaW4gDQp0aGlzIGUtbWFpbC4gSG93ZXZlciwgYXMgSW50ZXJuZXQgaXMgYSBub24gc2V= j=20 dXJlIGVudmlyb25tZW50OyB3ZSB3aWxsIGJlYXIgbm8gDQpyZXNwb25zaWJpbGl0eSBmb3IgYW5= 5=20 IGxvc3Mgb3IgZGFtYWdlIGFyaXNpbmcgZnJvbSB0aGUgdXNlIG9mIHRoaXMgZS1tYWlsIG9yIA0= K=20 YXR0YWNobWVudHMuIFRodXMsIHdlIHJlY29tbWVuZCB0aGF0IHlvdSBzdWJqZWN0IHRoZXNlIHR= v=20 IHlvdXIgdmlydXMgY2hlY2tpbmcgDQpwcm9jZWR1cmVzIHByaW9yIHRvIHVzZS4gDQoNCklmIGF= u=20 eSBpbnZlc3RtZW50IGluZm9ybWF0aW9uIGlzIGNvbnRhaW5lZCBoZXJlaW4sIGl0IGhhcyBiZWV= u=20 IHByb3ZpZGVkIHRvIHlvdSANCmZvciBpbmZvcm1hdGlvbmFsIHB1cnBvc2VzIG9ubHkgYW5kIG1= h=20 eSBub3QgYmUgcmVsaWVkIHVwb24gaW4gdGhlIHByb2Nlc3Mgb2YgDQpldmFsdWF0aW5nIHRoZSB= t=20 ZXJpdHMgb2YgaW52ZXN0aW5nIGluIGFueSBmaW5hbmNpYWwgaW5zdHJ1bWVudHMgcmVmZXJyZWQ= g=20 dG8gDQpoZXJlaW4uIEl0IGlzIG5vdCBhIHJlc2VhcmNoIHJlcG9ydCwgYSB0cmFkZSBjb25maXJ= t=20 YXRpb24gb3IgYW4gb2ZmZXIgb3IgDQpzb2xpY2l0YXRpb24gb2YgYW4gb2ZmZXIgdG8gYnV5LyB= z=20 ZWxsIGFueSBmaW5hbmNpYWwgaW5zdHJ1bWVudHMgDQoNClZpZXdzLCBvcGluaW9ucywgY29uY2x= 1=20 c2lvbnMgYW5kIG90aGVyIGluZm9ybWF0aW9uIGV4cHJlc3NlZCBpbiB0aGlzIGUtbWFpbCANCmF= y=20 ZSBub3QgZ2l2ZW4gb3IgZW5kb3JzZWQgYnkgTWFyZmluIEVnbmF0aWEgQmFuayBTLkEuIEdyb3V= w=20 IG9mIENvbXBhbmllcyANCnVubGVzcyBvdGhlcndpc2UgaW5kaWNhdGVkIGJ5IGFuIGF1dGhvcml= 6=20 ZWQgcmVwcmVzZW50YXRpdmUgaW5kZXBlbmRlbnQgb2YgdGhpcyANCm1lc3NhZ2UuIA0KDQrD7fn= z=20 9O/w79/n8+cvIMHw7/Dv3+fz5yDF9ej97efyIA0KDQpU7yDw4fH87SDs3u317OEg5e3k3ffl9OH= p=20 IO3hIPDl8enr4ezi3O3l6SDl7PDp8/Tl9fTp6t3yIJYg4fD88fHn9OXyIA0K8Ovn8e/27/Hf5fI= g=20 6uHpIOHw5fXo/e3l9OHpIOHw7+rr5enz9Onq3CDz9O/18iDz6u/w7/3s5e3v9fIg8OHx4eve8PT= l=20 8iAo3iANCvXw5f3o9e3vIOPp4SD05+0g8OHx3OTv894g9O/1IPP07/XyIOHt9N/z9O/p9+/18iD= z=20 6u/w7/3s5e3v9fIg8OHx4eve8PTl8ikuINPlIA0K8OXx3/D0+fPnIPDv9SDw5fHp3evo5ekg8+U= g=20 5fPc8iDh8Pwg69zo7/IsIOTl7SDo4SDw8d3w5ekg7eEg9/Hn8+ns7/Dv6d7z5fTlLCANCuHt9On= j=20 8dz45fTlLCDk6eHt5d/s5fTlIN4g8OHx4eT+8+X05SDz5SDv8O/p7+3k3vDv9OUg9O8g8OHx/O0= g=20 7N7t9ezhICjeIPTs3uzhIA0K9O/1IPDl8enl9+/s3e3v9SD07/UpLCDv/fTlIO3hIPDx7+Ll3/T= l=20 IPPlIO/w7+nh5N7w7/TlIOXt3fHj5enhIOLc8+XpIOH19O/9LiANCtP05+0g8OXx3/D0+fPnIOH= 1=20 9N4g6OEg8PHd8OXpIO3hIOrh9OHz9PHd+OX05SD07yDw4fH87SDs3u317OEg6uHpIO3hIA0K5en= k=20 7/Dv6d7z5fTlIPTv7SDh8O/z9O/r3eEuIA0KDQq49+/17SDr5/bo5d8g/OvhIPThIOX96+/j4SD= s=20 3fTx4SDh8/bh6+Xf4fIg8PHv6uXp7N3t7/Ug9O8g8OHx/O0g7N7t9ezhIO3hIOzn7SANCvDl8en= r=20 4ezi3O3l6SDp7/3yLiDE5eTv7N3t7/Ug/PTpIOcg5fDp6u/p7fnt3+Eg7N3z+SDk6eHk6er0/e/= 1=20 IChJbnRlcm5ldCkg5OXtIA0K5d/t4ekg4fP24eve8iwg5OXtIOHw7+Tl9/zs4fP05SD05+0g5fX= o=20 /e3nIOPp4SDv8O/p4eTe8O/05SDm5+zf4SDeIOHw/uvl6eEgDQrw8e/q/fjl6SDh8Pwg9Ocg9/H= e=20 8+cg9O/1IPDh8fzt9O/yIN4g9PntIPP17efs7N3t+e0g9O/1IOrh6SDz9e3p8/Tv/ezlIO3hIPT= v=20 IA0K9fDv4tzr5fTlIPP06fIg5Onh5Onq4fPf5fIg8PH86+f45/Ig6f7tIPDv9SDk6eHo3fTl9OU= g=20 8PHp7SD05yD38d7z5yDh9fTv/S4gDQoNCsHtIPTvIPDh8fztIPDl8enr4ezi3O3l6SDw6+fx7/b= v=20 8d/hIOXw5e3k9fTp6u/9IPDl8enl9+/s3e3v9Swg4fX03iDw4fHd9+X04ekgDQrh8O/q6+Xp8/T= p=20 6twg4+nhIOXt5+zl8fn06erv/fIg8+rv8O/98iDq4ekg5OXtIOjhIPDx3fDl6SDt4SDi4fPp8/T= l=20 3/TlIPPlIOH19N4gDQrq4fTcIPTn7SDh7unv6/zj5/PnIPTn8iDz6u/w6ez89Of04fIg9OfyIOX= w=20 3e3k9fPn8iDz5SDv8O/p4eTe8O/05SDh8Pwg9OEgDQr38efs4fTv7+nq7+3v7Onq3CDw8e/6/O3= 0=20 4SDw7/Ug9PX3/O0g4e3h9t3x7+304ekuINTvIPDh8fztIOTl7SDh8O/05evl3yANCuHt3Ov18+c= s=20 IOXw6eLl4uHf+fPnIPP17eHr6+Hj3vIg3iDw8e/z9u/x3CDeIPDx7/7o5/PnIPDx7/P27/Hc8iD= j=20 6eEg4ePv8dwvIA0K8P7r5/PnIO/w7+n57eTe8O/05SD38efs4fTv7+nq7+3v7Onq/u0g8PHv+vz= t=20 9PntLiANCg0Kz+kg4fD8+OXp8iwg4+3+7OXyLCDz9ezw5fHc8+zh9OEg6uHpINzr6+XyIPDr5/H= v=20 9u/x3+XyIPDv9SDw5fHp6+Hs4tzt7+304ekg8/TvIA0K8OHx/O0g7N7t9ezhIOfr5er08e/t6er= v=20 /SD04ff15PHv7OXf7/Ug5OXtIOTf5O/t9OHpIO/99OUg3ffv9e0g5ePq8eno5d8g4fD8IA0K9On= y=20 IOX04enx5d/l8iD07/Ugz+zf6+/1IE1hcmZpbiDF4+3h9N/hINTx3PDl5uEgwS7FLiwg5er0/PI= g=20 5dztIOTn6/no5d8g9O8gDQrh7fTf6OX07yDh8Pwg5e7v9fPp7+Tv9Ofs3e3vIOXq8PH88/nw/CD= 0=20 7/Ug4e3l7uHx9N70+fIg9O/1IPDh8fzt9O/yLiANCg0KDQoqKioqKioqKioqKioqKioqKioqKio= q=20 KioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKio= q=20 IA0KICBGb3J1bSBOb3RlOiBVc2UgIlJlcGx5IiB0byBwb3N0IGEgcmVzcG9uc2UgaW4gdGhlIGR= p=20 c2N1c3Npb24gZm9ydW0uIA0KDQo=3D=20 ***************************************************************************= ****=20 Forum Note: Use "Reply" to post a response in the discussion forum.=20

Art S. Kagel wrote: > There is no way to globally change the lockung mode for all existing tables. You have to do them one at a time. If you are creating a new database, you can set an ONCONFIG parameter so that row level locking is the default. > > That said, changing a whole database isn't hard, just: > > Unload to fix.sql delimiter ';'> Select 'alter table ' || tabname || ' lock mode (row)' > From systables > Where tabid > 100 and tabtype = ''T'' '; > > Art > > > -----Original Message----- > From: Sergios Zagotsis <szagotsis@marfinbank.gr> > Sent: Wednesday, July 30, 2008 8:51 AM > To: ids@iiug.org > Subject: Locking [12964] > > Hi, > > As I know by default Informix use page locking, unless if has been defined > otherwise during table creation. > > How is possible to change locking mechanism to row for all tables (and not > for each table individually) > > OS wWndows 2000, Informix IDS 9.30 TC3 > > Thanks in advance > > Sergios > > Disclaimer > > This message may contain privileged - confidential information and is intended > exclusively to the addressees (or any person in charge to deliver to the > addresses) . If you are not the intended recipient, you may not use, copy, > distribute or deliver this message (or part of its contents) to anyone or take > any action in reliance on it. In such a case, you should destroy this message, > and notify the sender. > > All reasonable precautions have been taken to ensure no viruses are present in > this e-mail. However, as Internet is a non secure environment; we will bear no > responsibility for any loss or damage arising from the use of this e-mail or > attachments. Thus, we recommend that you subject these to your virus checking > procedures prior to use. > > If any investment information is contained herein, it has been provided to you > for informational purposes only and may not be relied upon in the process of > evaluating the merits of investing in any financial instruments referred to > herein. It is not a research report, a trade confirmation or an offer or > solicitation of an offer to buy/ sell any financial instruments > > Views, opinions, conclusions and other information expressed in this e-mail > are not given or endorsed by Marfin Egnatia Bank S.A. Group of Companies > unless otherwise indicated by an authorized representative independent of this > message. > > Ãíùóôïðïßçóç/ Áðïðïßçóç Åõèýíçò > > Tï ðáñüí ìÞíõìá åíäÝ÷åôáé íá ðåñéëáìâÜíåé åìðéóôåõôéêÝò – áðüññçôåò > ðëçñïöïñßåò êáé áðåõèýíåôáé áðïêëåéóôéêÜ óôïõò óêïðïýìåíïõò ðáñáëÞðôåò (Þ > õðåýèõíï ãéá ôçí ðáñÜäïóÞ ôïõ óôïõò áíôßóôïé÷ïõò óêïðïýìåíïõò ðáñáëÞðôåò). Óå > ðåñßðôùóç ðïõ ðåñéÝëèåé óå åóÜò áðü ëÜèïò, äåí èá ðñÝðåé íá ÷ñçóéìïðïéÞóåôå, > áíôéãñÜøåôå, äéáíåßìåôå Þ ðáñáäþóåôå óå ïðïéïíäÞðïôå ôï ðáñüí ìÞíõìá (Þ ôìÞìá > ôïõ ðåñéå÷ïìÝíïõ ôïõ), ïýôå íá ðñïâåßôå óå ïðïéáäÞðïôå åíÝñãåéá âÜóåé áõôïý. > Óôçí ðåñßðôùóç áõôÞ èá ðñÝðåé íá êáôáóôñÝøåôå ôï ðáñüí ìÞíõìá êáé íá > åéäïðïéÞóåôå ôïí áðïóôïëÝá. > > ¸÷ïõí ëçöèåß üëá ôá åýëïãá ìÝôñá áóöáëåßáò ðñïêåéìÝíïõ ôï ðáñüí ìÞíõìá íá ìçí > ðåñéëáìâÜíåé éïýò. ÄåäïìÝíïõ üôé ç åðéêïéíùíßá ìÝóù äéáäéêôýïõ (Internet) äåí > åßíáé áóöáëÞò, äåí áðïäå÷üìáóôå ôçí åõèýíç ãéá ïðïéáäÞðïôå æçìßá Þ áðþëåéá > ðñïêýøåé áðü ôç ÷ñÞóç ôïõ ðáñüíôïò Þ ôùí óõíçììÝíùí ôïõ êáé óõíéóôïýìå íá ôï > õðïâÜëåôå óôéò äéáäéêáóßåò ðñüëçøçò éþí ðïõ äéáèÝôåôå ðñéí ôç ÷ñÞóç áõôïý. > > Áí ôï ðáñüí ðåñéëáìâÜíåé ðëçñïöïñßá åðåíäõôéêïý ðåñéå÷ïìÝíïõ, áõôÞ ðáñÝ÷åôáé > áðïêëåéóôéêÜ ãéá åíçìåñùôéêïýò óêïðïýò êáé äåí èá ðñÝðåé íá âáóéóôåßôå óå áõôÞ > êáôÜ ôçí áîéïëüãçóç ôçò óêïðéìüôçôáò ôçò åðÝíäõóçò óå ïðïéáäÞðïôå áðü ôá > ÷ñçìáôïïéêïíïìéêÜ ðñïúüíôá ðïõ ôõ÷üí áíáöÝñïíôáé. Ôï ðáñüí äåí áðïôåëåß > áíÜëõóç, åðéâåâáßùóç óõíáëëáãÞò Þ ðñïóöïñÜ Þ ðñïþèçóç ðñïóöïñÜò ãéá áãïñÜ/ > ðþëçóç ïðïéùíäÞðïôå ÷ñçìáôïïéêïíïìéêþí ðñïúüíôùí. > > Ïé áðüøåéò, ãíþìåò, óõìðåñÜóìáôá êáé Üëëåò ðëçñïöïñßåò ðïõ ðåñéëáìâÜíïíôáé óôï > ðáñüí ìÞíõìá çëåêôñïíéêïý ôá÷õäñïìåßïõ äåí äßäïíôáé ïýôå Ý÷ïõí åãêñéèåß áðü > ôéò åôáéñåßåò ôïõ Ïìßëïõ Marfin Åãíáôßá ÔñÜðåæá Á.Å., åêôüò åÜí äçëùèåß ôï > áíôßèåôï áðü åîïõóéïäïôçìÝíï åêðñüóùðü ôïõ áíåîáñôÞôùò ôïõ ðáñüíôïò. > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > I bet you say that to all the girls. -- Cheers, Obnoxio the Clown http://obotheclown.blogspot.com

-----Original Message----- From: Obnoxio The Clown <obnoxio@serendipita.com> Sent: Wednesday, July 30, 2008 9:46 AM To: ids@iiug.org Subject: Re: Locking [12969] Art S. Kagel wrote:=20 <Snip>=20 I bet you say that to all the girls.=20 Only the cute ones. I do have standards! Art=20 --=20 Cheers,=20 Obnoxio the Clown=20 http://obotheclown.blogspot.com=20 ***************************************************************************= ****=20 Forum Note: Use "Reply" to post a response in the discussion forum.=20

Thanks very much PS I don't understand what Art means by his e-mail Sergios -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Obnoxio The Clown Sent: Wednesday, July 30, 2008 4:46 PM To: ids@iiug.org Subject: Re: Locking [12969] Art S. Kagel wrote: > There is no way to globally change the lockung mode for all existing tables. You have to do them one at a time. If you are creating a new database, you can set an ONCONFIG parameter so that row level locking is the default. That said, changing a whole database isn't hard, just: Unload to fix.sql delimiter ';'Select 'alter table ' || tabname || ' lock mode (row)' From systables Where tabid > 100 and tabtype = ''T'' '; Art -----Original Message----- From: Sergios Zagotsis <szagotsis@marfinbank.gr> Sent: Wednesday, July 30, 2008 8:51 AM To: ids@iiug.org Subject: Locking [12964] Hi, As I know by default Informix use page locking, unless if has been defined otherwise during table creation. How is possible to change locking mechanism to row for all tables (and not for each table individually) OS wWndows 2000, Informix IDS 9.30 TC3 Thanks in advance Sergios Disclaimer This message may contain privileged - confidential information and is intended exclusively to the addressees (or any person in charge to deliver to the addresses) . If you are not the intended recipient, you may not use, copy, distribute or deliver this message (or part of its contents) to anyone or take any action in reliance on it. In such a case, you should destroy this message, and notify the sender. All reasonable precautions have been taken to ensure no viruses are present in this e-mail. However, as Internet is a non secure environment; we will bear no responsibility for any loss or damage arising from the use of this e-mail or attachments. Thus, we recommend that you subject these to your virus checking procedures prior to use. If any investment information is contained herein, it has been provided to you for informational purposes only and may not be relied upon in the process of evaluating the merits of investing in any financial instruments referred to herein. It is not a research report, a trade confirmation or an offer or solicitation of an offer to buy/ sell any financial instruments Views, opinions, conclusions and other information expressed in this e-mail are not given or endorsed by Marfin Egnatia Bank S.A. Group of Companies unless otherwise indicated by an authorized representative independent of this message. Ãíùóôïðïßçóç/ Áðïðïßçóç Åõèýíçò Tï ðáñüí ìÞíõìá åíäÝ÷åôáé íá ðåñéëáìâÜíåé åìðéóôåõôéêÝò – áðüññçôåò ðëçñïöïñßåò êáé áðåõèýíåôáé áðïêëåéóôéêÜ óôïõò óêïðïýìåíïõò ðáñáëÞðôåò (Þ õðåýèõíï ãéá ôçí ðáñÜäïóÞ ôïõ óôïõò áíôßóôïé÷ïõò óêïðïýìåíïõò ðáñáëÞðôåò). Óå ðåñßðôùóç ðïõ ðåñéÝëèåé óå åóÜò áðü ëÜèïò, äåí èá ðñÝðåé íá ÷ñçóéìïðïéÞóåôå, áíôéãñÜøåôå, äéáíåßìåôå Þ ðáñáäþóåôå óå ïðïéïíäÞðïôå ôï ðáñüí ìÞíõìá (Þ ôìÞìá ôïõ ðåñéå÷ïìÝíïõ ôïõ), ïýôå íá ðñïâåßôå óå ïðïéáäÞðïôå åíÝñãåéá âÜóåé áõôïý. Óôçí ðåñßðôùóç áõôÞ èá ðñÝðåé íá êáôáóôñÝøåôå ôï ðáñüí ìÞíõìá êáé íá åéäïðïéÞóåôå ôïí áðïóôïëÝá. ¸÷ïõí ëçöèåß üëá ôá åýëïãá ìÝôñá áóöáëåßáò ðñïêåéìÝíïõ ôï ðáñüí ìÞíõìá íá ìçí ðåñéëáìâÜíåé éïýò. ÄåäïìÝíïõ üôé ç åðéêïéíùíßá ìÝóù äéáäéêôýïõ (Internet) äåí åßíáé áóöáëÞò, äåí áðïäå÷üìáóôå ôçí åõèýíç ãéá ïðïéáäÞðïôå æçìßá Þ áðþëåéá ðñïêýøåé áðü ôç ÷ñÞóç ôïõ ðáñüíôïò Þ ôùí óõíçììÝíùí ôïõ êáé óõíéóôïýìå íá ôï õðïâÜëåôå óôéò äéáäéêáóßåò ðñüëçøçò éþí ðïõ äéáèÝôåôå ðñéí ôç ÷ñÞóç áõôïý. Áí ôï ðáñüí ðåñéëáìâÜíåé ðëçñïöïñßá åðåíäõôéêïý ðåñéå÷ïìÝíïõ, áõôÞ ðáñÝ÷åôáé áðïêëåéóôéêÜ ãéá åíçìåñùôéêïýò óêïðïýò êáé äåí èá ðñÝðåé íá âáóéóôåßôå óå áõôÞ êáôÜ ôçí áîéïëüãçóç ôçò óêïðéìüôçôáò ôçò åðÝíäõóçò óå ïðïéáäÞðïôå áðü ôá ÷ñçìáôïïéêïíïìéêÜ ðñïúüíôá ðïõ ôõ÷üí áíáöÝñïíôáé. Ôï ðáñüí äåí áðïôåëåß áíÜëõóç, åðéâåâáßùóç óõíáëëáãÞò Þ ðñïóöïñÜ Þ ðñïþèçóç ðñïóöïñÜò ãéá áãïñÜ/ ðþëçóç ïðïéùíäÞðïôå ÷ñçìáôïïéêïíïìéêþí ðñïúüíôùí. Ïé áðüøåéò, ãíþìåò, óõìðåñÜóìáôá êáé Üëëåò ðëçñïöïñßåò ðïõ ðåñéëáìâÜíïíôáé óôï ðáñüí ìÞíõìá çëåêôñïíéêïý ôá÷õäñïìåßïõ äåí äßäïíôáé ïýôå Ý÷ïõí åãêñéèåß áðü ôéò åôáéñåßåò ôïõ Ïìßëïõ Marfin Åãíáôßá ÔñÜðåæá Á.Å., åêôüò åÜí äçëùèåß ôï áíôßèåôï áðü åîïõóéïäïôçìÝíï åêðñüóùðü ôïõ áíåîáñôÞôùò ôïõ ðáñüíôïò. ******************************************************************************* Forum Note: Use "Reply" to post a response in the di > c2N1c3Npb24gZm9ydW0uIA0KDQo= > > I bet you say that to all the girls. -- Cheers, Obnoxio the Clown http://obotheclown.blogspot.com **************************************************************************** *** Forum Note: Use "Reply" to post a response in the discussion forum. Disclaimer This message may contain privileged - confidential information and is intended exclusively to th