unloading a table

Posted in 2000

David Kulkarni — Mon, 14 Aug 2000 14:33:26 -0700 (PDT) — source: Informix-list mailing list archive (1991-1998)

On Informix ver. 5.10UC5 (OS HP-UX 10.20) I am trying to unload a table that has 24570444 rows but it keeps failing giving me the following error message: Write failed. 16794517 rows unloaded (check ulimit or disk space). I have a filesystem with 18 gigs of space so I know that space is not a problem. What is ulimit? Is this a parameter that I have to set for tables over 2GiGs in size. The statement I am executing is as follows: unload to cost.unl select * from cost; dbaccess -e son_db unload.sql > unload.out Can anybody tell me where I am going wrong here. TIA ===== David Kulkarni New York, NY 10021 email: dkulkarni@cgsh.com __________________________________________________ Do You Yahoo!? Yahoo! Mail ' Free email you can access from anywhere! http://mail.yahoo.com/