Operating System - HP-UX
1823999 Members
3452 Online
109667 Solutions
New Discussion юеВ

ulimit for informix user.

 
SOLVED
Go to solution
someone_4
Honored Contributor

ulimit for informix user.

Hi everyone,

I am having problems finding something some information about the ulimit for the user informix. One of the dbas is trying to do an unload like so:

set pdqpriority 30;
unload to '/archive2/cdr_d_dest_feb.txt'
select * from cdr_d_dest where call_date
between '02/01/2002' and '02/28/2002';
order by call_date;

but she gets the error:

Write failed. 3852553 rows unloaded (check ulimit or disk space).

The size is 2147483647
on the file there is plenty of disk space in /archive2

for the user infomrix:
ulimit
4194303

Thanks
~ Richard
2 REPLIES 2
James R. Ferguson
Acclaimed Contributor
Solution

Re: ulimit for informix user.

Hi Richard:

You need to enable 'largefiles' for the filesystem you are writing in. (2^31) -1 = 2147483647 ~ 2GB.

Regards!

...JRF...
A. Clay Stephenson
Acclaimed Contributor

Re: ulimit for informix user.


WEll that value of ulimit is 2GB - 4194393 x 512 bytes/block. I suspect that this user is using ksh and that is the maximum ulimit. You might try using the POSIX shell but I suspect that you are hitting a restriction in the informix code itself especially if this is 32-bit code. Not all code is able to use largefiles. Have you made sure that largefiles are enabled in this filesystem? That could easily be yoiur problem. Finally, you need to check to see if quotas are in play for this user.
If it ain't broke, I can fix that.