dbexport limit

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

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.

Are you exporting to disk or to tape? If disk, what is the file-size limit on the filesystem you are exporting to? Which system error message did you receive? Brett Randall Luiz Schwartz 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

Hi, use Art's load/unload utility from www.iiug.org. HTH Dirk Luiz Schwartz schrieb: > 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

Some systems have a limit of the size of the file written to disk, that is your falsedisk full. Luiz Schwartz 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

dbexport has a built in limit of 2GB for each file it creates. For each table, dbexport creates a .unl file. This limit isn't so much an Informix limitation but a unix limitation at files being no larger than 2GB. There are ways around that, but that's another issue not so much related to Informix as it is to Unix. Mark Peterson wrote: > Some systems have a limit of the size of the file written to disk, that is > your falsedisk full. > > Luiz Schwartz 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 -- Phillip Tien Database Administrator Whole Foods Market, Inc. If I ever get rich, I hope I'm not real mean to poor people, like I am now.

In article <3A0B007B.12070E35@wholefoods.com>, Phillip <tienp@wholefoods.com> writes >dbexport has a built in limit of 2GB for each file it creates. For each >table, dbexport creates a .unl file. This limit isn't so much an Informix >limitation but a unix limitation at files being no larger than 2GB. There are >ways around that, but that's another issue not so much related to Informix as >it is to Unix. Specifically you will probably not be running dbexport as 'root', so will be subject to whatever ulimit is set to unless you take steps to override it to be unlimited. > >Mark Peterson wrote: > >> Some systems have a limit of the size of the file written to disk, that is >> your falsedisk full. >> >> Luiz Schwartz 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 > >-- >Phillip Tien >Database Administrator >Whole Foods Market, Inc. > >If I ever get rich, I hope I'm not real mean to poor people, like I am now. > > -- Surfer!

My dbexport replacement utility, myexport, is completely compatible with dbexport and does not have any hard limits. If you OS supports large files so does myexport. Myexport is available from the IIUG Software Repository in the package myexport.shar. Note a new version was uploaded this week. Art S. Kagel Luiz Schwartz 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

I don't agree with you. It IS an Informix limit, not a UNIX limit. Hence with most versions of IDS the 2GByte limit is present even if files >2GBytes are permitted by the OS. Phillip <tienp@wholefoods.com> wrote in message news:3A0B007B.12070E35@wholefoods.com... > dbexport has a built in limit of 2GB for each file it creates. For each > table, dbexport creates a .unl file. This limit isn't so much an Informix > limitation but a unix limitation ...