Re: 141: ISAM error: TBLspace table overflow

Doug Johnson <johnson_doug@emc.com> wrote: >I'm trying to create a detached index with Informix Online 7.10.UC1 on a >three-processor SPARC 1000 with SOLARIS 2.4 using: > create unique index index01 on table01 (col01, col02) in dbspace01; >It consistently fails after about 30 minutes with: > 141: ISAM error: TBLspace table overflow >The table has about 18 million rows and is less than 2.5GB. >The columns col01 and col02 are defined as "integer not null". >The index should be less than 500MB. >The target dbspace (which is empty) and DBSPACETEMP are both 4GB. >The root dbspace is 800MB with about 400MB free. >$INFORMIXDIR/etc/$ONCONFIG(TBLSPACES) = 2000 but this shouldn't matter. >The database was created without logging. >Logical logs are 6*40MB for checkpoint and other stuff. >"alter table table01 add constraint primary key (col01, col02)" works OK. >Note that you can't direct a primary key to a separate dbspace. >I've read the informix FAQ and checked InfoTech. >I talked to five people from Informix engineering and ATG. >I'm stuck. Anyone know how to fix this? Thanks. >Doug Johnson >EMC >johnson_doug@emc.com My understanding is the tablespace parameter does not become dynamic until 7.1 ud1; therefore if you are using > 300 tables for a small table index maybe you are reaching the 2000 limit on the big table. The other thing is if you alter the table and add the primary constraint before you add the index informix is going to dynamically build an index on the constraint for you. After the number of tablespaces open becomes dynamic the error message changes to tell you to add more virtual memory that online can get. -- Tolly Brumbelow, Informix DBA email:tolly.brumbelow@bridge.bellsouth.com