Re: unloading a table

--- David Kulkarni <dnk61@yahoo.com> > wrote: >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: ulimit is a UNIX system parameter that limits the size of a file a user can create. You can type ulimit at the prompt to see what your current setting is. Do a man on ulimit for syntax. There are two kinds of ulimit, by the way. Hard and soft. You can change your soft ulimit up to the hard ulimit, but the sysadmin will have to change the hard limit if need be. >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/ == Maintainer of the procrastinator's FAQ. Well, maybe tomorrow I will be. _____________________________________________________________ Want a new web-based email account ? ---> http://www.firstlinux.net