How to change next size on 24x7 table
This is a discussion on How to change next size on 24x7 table within the Informix forums, part of the Database Server Software category; --> I have a table which is over 200 extents - already had problems with it. It was orginally defined ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-20-2008, 07:48 AM
| ||||
| ||||
 How to change next size on 24x7 table 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      |
|
04-20-2008, 07:48 AM
| |||
| |||
| Re: How to change next size on 24x7 table "Chris Bullivant" <cbullivant@orange.net.au> wrote in message news:21e62a09.0409302258.29b08d5b@posting.google.c om... > 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) Can't think of one :-( |
|
04-20-2008, 07:48 AM
| ||||
| ||||
| Re: How to change next size on 24x7 table 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 # |
Linear Mode
