Re: Committed read

Mukund AFAIK, an ALTER TABLE tries to grab an exclusive lock on the table before it can do anything. Your best bet would probably be to revoke permissions on the quote table from all but informix, bounce the engine, alter the table, and re-grant all permissions the way it was on the table. HTH Sujit Mukund D Shevkar <mukund@imsn.net> on 01/12/2000 01:24:54 AM To: informix-list@iiug.org cc: Subject: Committed read I am working on stock trading database where there is a 'quote' table accessed by multiple web users in commited read islation level. onstat -k shows a shared lock for placed. Now I want to alter table and change the page level locking of the table to row level. It returns an error -242 Could not open database table table-name. What isolation level do I use for alteration to a table when the table will have a shared lock? TIA Mukund