Solved

AIX ulimit

Posted on 2013-01-31
13
925 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
  • 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
 
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
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
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 500 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Let's say you need to move the data of a file system from one partition to another. This generally involves dismounting the file system, backing it up to tapes, and restoring it to a new partition. You may also copy the file system from one place to…
I have been running these systems for a few years now and I am just very happy with them.   I just wanted to share the manual that I have created for upgrades and other things.  Oooh yes! FreeBSD makes me happy (as a server), no maintenance and I al…
Learn how to find files with the shell using the find and locate commands. Use locate to find a needle in a haystack.: With locate, check if the file still exists.: Use find to get the actual location of the file.:
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…

895 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

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now