RE: Dbexport

Apparently the issue is with Informix software and not the OS. As I stated before we can write files using the OS larger than 2 gigs. Technical support indicated the problem is that dbaccess (unload, etc) and dbexport links to lseek which uses a 32 bit pointer and therefore a limit of a two gig file size. If however, the link was to lseek64 we could then write files larger than 2 gigs. If you have imperical experience with writing flat files using one of the above Informix utilities (or any for that matter) on a HP/UX 10.20 system please let me know how. I would be greatly indebted to you. BTW, we do not want to consider having to break this huge table into a bunch of small pieces. That method is cumbersome to manage and takes far more time to complete. We cannot afford to miss a single piece of data. Thanks, Mark Cardinal Health, Inc. ---------- From: <mdstock@informix.com> Sent: Wednesday, November 05, 1997 4:07 PM To: informix-list@rmy.emory.edu Subject: Re: Dbexport <<File: RFC822.TXT>> 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"!|/ ////////| +----------------------+-----------------------------------+-----------+