RE: error during export procedure-"File size limit exceeded"
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