RE: dbexport limit

Slightly different topic, but you call it to mind. When you unload using HPL or Pload you can unload to a pipe and get around the 2GB limit. I have a lovely script which dumps XPS tables through a pipe into gzip (or flat files). It even works some times. The basic procedure is: create external table ........ datafiles ("pipe:n:/tmp/pipe.n"..... in a shell, cat /tmp/pipe.n | gzip > outputfile insert into ext_table select * from internal_table You can do the same sort of thing under devices in HPL. cheers j. -----Original Message----- From: Murray Wood [mailto:murray@quanta.co.nz] Sent: Tuesday, November 07, 2000 7:59 PM To: informix-list@iiug.org Subject: RE: dbexport limit You should be able to unload all tables greater than 2Gb (concurrently), dbschema of the table(s), drop them then dbexport the rest. The issue is a unix command that Informix uses - cant recall which one - that is limited to a maximum value of 2Gb. This can be corrected, but as it is only a convenience utility, it is unlikely to emerge from the bottom of the priority queue. MW -----Original Message----- From: owner-informix-list@iiug.iiug.org [mailto:owner-informix-list@iiug.iiug.org]On Behalf Of Norman Erickson Lugtu Sent: Wednesday, November 08, 2000 8:08 AM To: informix-list@iiug.org Subject: Re: dbexport limit 2GB is the file size limit in Informix. Others might say that this is an OS limit but it really is an Informix limit. In article <8u9ije$o8p$1@news.xmission.com>, Luiz Schwartz <tl1312190@terra.com.br> wrote: > > Hi everybody! > > Somebody knows if the dbexport have a limit by table ? > I tried did dbexport but i cant unload tables with more 2GB . Why? > > I receive system message : Maybe Disk Full, but i have 4GB free > space. > > Thanks > > Luiz Schwartz > Informix Consultant > > Sent via Deja.com http://www.deja.com/ Before you buy.