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