Re: lock mode

braispa@mail.northgrum.com wrote: >I am running Informix Dynamic Server 7.23.UC4 >Is it possible to set lock mode for the entire database globaly to row or >table or whatever? >My users are using people soft and are running into the situation in which it >appears they are locking their own process out because they are acquiring >exclusive table locks and page level locks. Consequently no work is being >done. I am not detecting dead locks either. >Any help would be appreciated >Paul >-----== Posted via Deja News, The Leader in Internet Discussion ==----- >http://www.dejanews.com/ Now offering spam-free web-based newsreading Paul, we run the following script in isql, output to "mod_locks.sql" select "alter table", tabname, "lock mode (row);" from systables where tabid > 100 and locklevel ="P" to create another sql file that can be run to alter tables that are currently page level locking to row level locking. You have to edit the generated file as the output from isql creates a couple of header line that need to be removed. Tables with tabid < 100 are system tables and should not be altered without a great deal of thought and soul searching. Lem Beason lbeason@redneck-trailer.com DBA, Redneck Trailer Supplies