Re: -242 non-exclusive access

Upgrade to IDS 11.50.xC6 which has online index building. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) IIUG Board of Directors (art@iiug.org) See you at the 2010 IIUG Informix Conference April 25-28, 2010 Overland Park (Kansas City), KS www.iiug.org/conf Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Fri, Mar 26, 2010 at 5:30 PM, Kennedy, Randy <RKennedy@scottsdaleaz.gov>wrote: > IDS 9.4FC3 > HP/UX 11.11 > > I am trying to create an index and get this error sometimes. I > understand getting it during the day when the system is heavily > utilized, but I am trying to create this off hours when there should be > no activity. How can I see what process/session/etc is using a table > and giving this error? > > Is there a way of creating an index that doesn't lock the table so I > could create them during the day. The time to build it doesn't matter > to me if I don't have to tie up the table. > > TIA, > Randy > > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list >