Re: Exclusive Locks and Indexes

In article <64bam4$af5@cssun.mathcs.emory.edu>, Richard Wellis Sinyem <senyem@malitnet.net.my> writes >-- [ 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. > Yes, the user LOKCING at the table should get an error, but the engine should not crash. >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 -------- > > -- David Williams