Re: TBLSPACES and Frag Index Creation

charlie.muntz@vallley.net (Charlie Muntz) wrote: >Online 7.1 on a SPARC/1000; Solaris 2.4 >Trying to create an index on an integer field in a fragmented table (fragged on the int); >If the table is approx 20K rows, engine wants about 50 TBLSPACES during index creation; >If the table is 200K rows, the engine wants about 400 TBLSPACES; >We need 15 million rows; >Engine initializes with TBLSPACES set at 500, but not with TBLSPACES set at 600. >I have not tried any larger values. >The manual says nothing about (temporary) need for lots of TBLSPACES when >creating an index on a fragged table. >Any suggestions? johnl? >TIA >Ken Ketchum >ETAK IG 603-448-0001 X203 or 209 W're testing Online 7.1 on a Stratus FTX 2.3 platform. The sizes of our tables range between 1.5 and 30 million rows. We encountered the same problem in the case of a fragmented table and a similar problem with an unfragmented table (create index cannot allocate shared memory). For both problems we use the following workaround. We set the undocumented environment-variable NOSORTINDEX to true. (export NOSORTINDEX=true) Both problems (index creation on fragmented and unfragmented tables) have been reported to our Informix support contact. We were informed that both problems have informix bugnumbers. I hope the mentioned workaround will also work for you. With kind regards, Paul Bonting (pbonting@worldaccess.nl)