row-locking-mode

Hi all My environment is an Informix-online 7.23 on AIX Unix Version 4. All tables on my database are working with page-locking-mode. Now I've heard about the row-locking-mode for tables. Is it clever to set all tables to row-locking-mode? I guess for some tables it is better work with page-locking-mode and for others it is better to work with row-locking-mode. Is there any rule on which table which mode works the best? thanks Mattias Meyerhoefer

Depending on the application, really. If you have page level locking, this obviously uses less lock resource as it will only put out one lock per page rather that one lock per row, thus reducing the overhead on the engine. If you have processes that updates or inserts a large amount of data ( if you don't want to exclusively lock the entire table ) then page level locking is better. For OLTP systems, as a general rule, you would tend to use row level as this would eliminate or at lease reduce the potential for a user to be locking another user out of a row just because it was in the same page as the one another process was updating. As an overhead, it uses loads more locks and should be monitored accordingly. Also, your application should, where appropriate, use table level locking if used to update an entire table or the majority of rows within a table. Batch jobs tend to use page or table locking. Sean Matthias Meyerh'fer wrote in message <771un5$e2$1@news.online.de>... >Hi all > >My environment is an Informix-online 7.23 on AIX Unix Version 4. > >All tables on my database are working with page-locking-mode. >Now I've heard about the row-locking-mode for tables. >Is it clever to set all tables to row-locking-mode? >I guess for some tables it is better work with page-locking-mode >and for others it is better to work with row-locking-mode. >Is there any rule on which table which mode works the best? > >thanks >Mattias Meyerhoefer > >