Large Table Reorg

Posted in 1997

Rick Ward — 15 Jan 1997 04:58:31 -0500 — source: Informix-list mailing list archive (1991-1998)

Using: ONLINE DSA V7.13 on SUN SOLARIS 2.5 We are building a large(ish) DSS system, and some table will become 10GB in size. Does anyone out there have tables this big which the rebuild to reorganise the data ? If so, how do you do this given that unloading the table to disk is not viable because of (the Sun Solaris) 2GB UNIX file size limit ? I do not want to unload this to tape because 1, its slow and 2, tapes are not the most reliable media. Thanks, -- Rick Ward Senior DBA Great Universal Stores Home Shopping MANCHESTER, UK