How to change next size on 24x7 table

Posted in 2004

Topics: Storage & Space Management, Error Codes & Troubleshooting, Platform-Specific Issues

Chris Bullivant — 30 Sep 2004 23:58:32 -0700 — source: Usenet: comp.databases.informix

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

↪ replying to Chris Bullivant

Neil Truby — Fri, 1 Oct 2004 08:20:21 +0100 — source: Usenet: comp.databases.informix

"Chris Bullivant" <cbullivant@orange.net.au> wrote in message news:21e62a09.0409302258.29b08d5b@posting.google.com... > 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 :-(

↪ replying to Chris Bullivant

Paul Watson — Fri, 01 Oct 2004 08:37:02 +0100 — source: Usenet: comp.databases.informix

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 #

Glossary

ISAM error