TBLSPACES and Frag Index Creation

Posted in 1995

Charlie Muntz — Thu, 27 Apr 95 17:11:36 GMT — source: Informix-list mailing list archive (1991-1998)

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