Hi Cristian.
Yep, this is restriction in 7.x, 9.2, and 9.3.
In 9.4 does not have this restriction.
OR
Use sqlcmd of Jonathan Leffer or utlity of Art S Kagel.
Both utility exists http://www.iiug.org .
HTH.
--
Tsutomu Ogiwara from Tokyo Japan.
ICQ#:168106592
>From: cristizaharioiu@hotmail.com (Cristian Zaharioiu)
>Reply-To: cristizaharioiu@hotmail.com (Cristian Zaharioiu)
>To: informix-list@iiug.org
>Subject: error during export procedure-"File size limit exceeded"
>Date: 27 Sep 2004 03:40:19 -0700
>
>hello all,
>
>i am running dbexport procedure on the database and the return is next
>error: "File size limit exceeded. Please increase hard resource limit
>using ulimit."
>The file which generated the error has about 2,137Gbytes.
>
>The machine running Linux Mandrake 9.0-kernel 2.4 and Informix 9.21
>UC1
>
>The output of ulimit -a:
>$ulimit -a
>core file size (blocks, -c) 0
>data seg size (kbytes, -d) unlimited
>file size (blocks, -f) unlimited
>max locked memory (kbytes, -l) unlimited
>max memory size (kbytes, -m) unlimited
>open files (-n) 1024
>pipe size (512 bytes, -p) 8
>stack size (kbytes, -s) 8192
>cpu time (seconds, -t) unlimited
>max user processes (-u) 1023
>virtual memory (kbytes, -v) unlimited
>
>Is this limitation the same with chunk limit (2 Gb) or not?
>
>Is there a solution for this problem?
>
>Thank you!
_________________________________________________________________
MSN 8 with e-mail virus protection service: 2 months FREE*
http://join.msn.com/?page=features/virus
sending to informix-list