Results 1 to 8 of 8
  1. #1
    Join Date
    Apr 2004
    Posts
    58

    Exclamation Unanswered: File size too large

    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!

  2. #2
    Join Date
    Jul 2003
    Location
    Austin, TX, USA
    Posts
    278

    Create multiple files.

    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..
    HTH

    Nitin

    Ask the experienced rather than the learned

  3. #3
    Join Date
    Nov 2002
    Location
    Delaware
    Posts
    186
    check your user limits if your using AIX, if the file size is set, make it unlimited.
    David Quigley

  4. #4
    Join Date
    Apr 2004
    Posts
    58
    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.

  5. #5
    Join Date
    Nov 2002
    Location
    Delaware
    Posts
    186
    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.
    David Quigley

  6. #6
    Join Date
    Nov 2002
    Location
    Delaware
    Posts
    186
    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
    David Quigley

  7. #7
    Join Date
    Apr 2004
    Posts
    58
    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.

  8. #8
    Join Date
    Nov 2002
    Location
    Delaware
    Posts
    186
    did you recycle db2 after you changed the ulimits??
    David Quigley

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •