Re: Large Table Reorg

This is a multi-part message in MIME format. --------------4DD5158A658C Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Rick Ward wrote: > > 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. Well if you can't use disk or tape, then I don't know. CDROM? Are you sure that 2GB limit is Solaris or a kernal parameter? It depends on what you mean by reorganise, but onunload and onload allow you to move databases and tables around in binary form. These are generally the quickest Informix data transfer utilities, but require the use of tape. :-) Don't forget to post your favoured solution. Good luck, -- --------------4DD5158A658C Content-Type: text/plain; charset=us-ascii; name="ATT_SIG.TXT" Content-Transfer-Encoding: 7bit Content-Disposition: inline; filename="ATT_SIG.TXT" Mark. +------------------------------------------------------------------+ |Mark D. Stock - The West Solutions Group http://www.west.co.za | | The Informix FAQ is at http://www.iiug.org | |mailto:marks@west.co.za +-----------------------------------------+ |Tel: +27 11 803 2151 |If it doesn't work, force it! | |Fax: +27 11 803 2189 |If it breaks, it needed replacing anyway!| |Cell: +27 83 250 2325 |Well, that's how I code anyway! | +------------------------+-----------------------------------------+ --------------4DD5158A658C--