We have a program which extracts records from two large tables (50 million rows each). The program fails after the file size reached 2.1 GB. From the log, it says 'file size too large'. Our fsize in /etc/security/limits is default to
-1 (unlimited).

Any ideas or suggestions would be greatly appreciated.
Thank you!

Hi.

We faced an issue like that only when we were working with db2 data propogator where the system would hang when the spill file went to 2.1GB.

If it is possible u can create multiple files of smaller sizes that would resolve your issue temporarily.

Try giving it a shot..

check your user limits if your using AIX, if the file size is set, make it unlimited.

The file(blocks) is already set to unlimited.
We are on AIX. Isn't the file size limit 64G?
If so, why program stops when it reaches 2.1G?
Please advise. Thanks.

as the id thats running db2 type ulimit -a and see what its set too, also if its JFS, its is 64 gig, jfs2, its over 2T.

as the id thats running db2 type ulimit -a and see what its set too, also if its JFS, its is 64 gig, jfs2, its over 2T.

Also make sure the file is if LARGE FILE ENABLED, if not that will cause a problem too

We have large file enabled. 'ulimit' setting for user running the program is unlimited. However, still get 'file size too large'. Please advise. Thank you.

did you recycle db2 after you changed the ulimits??