Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

AIX ulimit

Posted on 2013-01-31
13
Medium Priority
?
944 Views
Last Modified: 2013-01-31
Hi wmp,

I'm having a issue writing a file (db export) that seems to be larger than 2Gb.

A file cannot be larger than the value set by ulimit.

 ulimit -a
time(seconds)        unlimited
file(blocks)         unlimited
data(kbytes)         unlimited
stack(kbytes)        4194304
memory(kbytes)       65536
coredump(blocks)     0
nofiles(descriptors) unlimited

However, file limit doesn't seem to exist.

Any idea how to solve this one?
It's AIX 5L 5.3.

Thanks!
0
Comment
Question by:g0all
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 7
  • 6
13 Comments
 
LVL 68

Expert Comment

by:woolmilkporc
ID: 38839075
Well,

the ulimit seems indeed OK.

Does the target directory reside on a JFS (not JFS2) filesystem?

With JFS there is a file size limit of 2 GB, unless the FS was created using the largefiles option ("bf=true").
Check with  "lsfs -q /mount/point" and search for the "VFS" type and for "bf:"

Could it be that quota checking is enabled on the target filesystem?

Check with "quota" and "quota -g".
0
 
LVL 1

Author Comment

by:g0all
ID: 38839078
Currently checking.
0
 
LVL 68

Expert Comment

by:woolmilkporc
ID: 38839083
Listening ...
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 1

Author Comment

by:g0all
ID: 38839105
/data/ora/bla/bla2:
        dev             = /dev/lv_bla
        vfs             = jfs
        log             = /dev/lj_vg_bla
        mount           = true
        check           = false
        options         = rw,nodev
        account         = false


Seems to be JFS1...
0
 
LVL 68

Expert Comment

by:woolmilkporc
ID: 38839111
lsfs -q /data/ora/bla/bla2

?
0
 
LVL 1

Author Comment

by:g0all
ID: 38839148
Half an hour please driving
0
 
LVL 68

Expert Comment

by:woolmilkporc
ID: 38839156
Bon voyage!
0
 
LVL 1

Author Comment

by:g0all
ID: 38839157
Thanks.

smitty drive.
0
 
LVL 1

Author Comment

by:g0all
ID: 38839353
Name            Nodename   Mount Pt               VFS   Size    Options    Auto Accounting
/dev/lv_bla --        /data/ora/bla/bla2   jfs   25690112 rw,nodev   yes  no
  (lv size: 25690112, fs size: 25690112, frag size: 4096, nbpi: 4096, compress: no, bf: false, ag: 8)
0
 
LVL 68

Accepted Solution

by:
woolmilkporc earned 2000 total points
ID: 38839382
OK, JFS without large files support (bf:false) has a 2 GB file size limit.

Large files support is configured (or not!) at FS creation time and cannot be added afterwards.

Sad to say - either use a different FS (JFS2 or bf:true) as the target for the DB exports or delete the FS and recreate it as JFS2 or at least with bf:true.

Or convice the DB export utility to create chunks of output data not larger than 2 GB.

ORACLE exp and expdp have a parameter "FILESIZE", for example.
0
 
LVL 1

Author Closing Comment

by:g0all
ID: 38839398
Thanks, wmp.
0
 
LVL 1

Author Comment

by:g0all
ID: 38839651
wmp, are you into Oracle also?

export chunks was the accepted solution. I wasn't aware of such option.
0
 
LVL 68

Expert Comment

by:woolmilkporc
ID: 38839670
Well, I know a bit about Oracle, but I'm sure there's quite a lot of fine Oracle experts around here at EE to assist you much better than I could.
OK, might be worth a try ...
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction Regular patching is part of a system administrator's tasks. However, many patches require that the system be in single-user mode before they can be installed. A cluster patch in particular can take quite a while to apply if the machine…
FreeBSD on EC2 FreeBSD (https://www.freebsd.org) is a robust Unix-like operating system that has been around for many years. FreeBSD is available on Amazon EC2 through Amazon Machine Images (AMIs) provided by FreeBSD developer and security office…
Learn how to navigate the file tree with the shell. Use pwd to print the current working directory: Use ls to list a directory's contents: Use cd to change to a new directory: Use wildcards instead of typing out long directory names: Use ../ to move…
In a previous video, we went over how to export a DynamoDB table into Amazon S3.  In this video, we show how to load the export from S3 into a DynamoDB table.
Suggested Courses

636 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question