Re: Dbexport

David Williams wrote: > > In article <63ku36$6e1@cssun.mathcs.emory.edu>, > mbaumgartner@cardhealth.com writes > > > >Last week there was a thread that asked how long it would take to > dbexport a 28 > >Gig db. Well this past weekend we were trying to dbexport a 68 Gig > db only to > >have it blow up when one of the .unl files reached 2 Gig. > > > >We are running on HP/UX 10.20, ODS 7.14 UC1. The Unix ulimit is set > to > >unlimited and we are able to create a file on the file system larger > than 2 Gig > >using Unix utilities. > > > But not with Informix. Informix does not support files/devices > > 2Gig. No. you're thinking of chunk sizes. Flat files are governed by UNIX. Check the kernel parameters again. There might be a system wide ulimit as well as a user ulimit. Also I've seen this problem where people assumed the block size was 1024 when in fact it was 512! So make sure your ulimit IS what you think it is. ;-) > You will have to unload the table in sections by hand:- > > unload to "<table>1.unl" > select * from <table> where <primary_key> <= <value>> > unload to "<table>2.unl" > select * from <table> where <primary_key> > <value>> > then > > load from "<table>1.unl" insert into <table> > load from "<table>2.unl" insert into <table> No. Use dbexport. Cheers, -- Mark. +----------------------------------------------------------+-----------+ |Mark D. Stock - Informix SA http://www.informix.com |//////// /| |mailto:mdstock@informix.com FAQ http://www.iiug.org |///// / //| | +-----------------------------------+//// / ///| | Tel: +27 11 807 0313 |If it's slow, the users complain. |/// / ////| | Fax: +27 11 807 2594 |If it's fast, the users keep quiet.|// / /////| |Cell: +27 83 250 2325 |Therefore, "No news: travels fast"!|/ ////////| +----------------------+-----------------------------------+-----------+