Re: Exclusive Locks and Indexes

-- [ From: Richard Wellis Sinyem * EMC.Ver #2.5.02 ] -- Dear Paul, For this kind of maintenance (alter/drop table/indexes), you should be doing it only if no one use the system (or that particular table). I think there's no point of doing maintenance when someone still want to have access to the database/tables. Can't have two ways traffic here, so to speak. regards RWS -------- REPLY, Original message follows -------- Date: Tuesday, 11-Nov-97 11:01 PM From: Paul N. Daly \\ Internet: (pdaly@globalnet.co.uk) To: INFORMIX Worldwide List \\ Internet: (informix-list@rmy.emory.edu) Subject: Exclusive Locks and Indexes I have encountered a problem with Online v7, where if you try to drop an index, even with exclusive lock set on the table, if the table is being looked at, the engine crashes. Does anybody know of a way round this problem, apart from waiting until no one else is in the system? -------- REPLY, End of original message --------