Re: How to change next size on 24x7 table

Try "set lock mode to wait " . Hoping you will get some access , whenever the lock is released at some point. JP Paul Watson <paul@oninit.com> Sent by: To owner-informix-li informix-list@iiug.org st@iiug.org cc Subject 10/01/2004 03:37 Re: How to change next size on 24x7 AM table Please respond to paul@oninit.com I think you are going to have to schedule some time. You are going to run out of extents, personally I worry about 150 Chris Bullivant wrote: > > I have a table which is over 200 extents - already had problems with > it. > It was orginally defined with first extent = next extent = 16. > I want to do ALTER TABLE...MODIFY NEXT EXTENT (before I do the ALTER > FRAGMENT...) and set it to about 100000, but I keep getting > 242: Could not open database table (informix.transaction). > 106: ISAM error: non-exclusive access.> > The table is accessed 24x7. > > Does anyone have any tricks on how to modify the next extent size > without throwing users off to do it? (this is my last resort) > > I'm using 7.31.UC7 on solaris 7 > > Thanks for any help you may give -- Paul Watson # Oninit Ltd # Growing old is mandatory Tel: +44 1436 672201 # Growing up is optional Fax: +44 1436 678693 # Mob: +44 7818 003457 # www.oninit.com # sending to informix-list