?
Solved

AIX ulimit

Posted on 2013-01-31
13
Medium Priority
?
936 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
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
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

When you do backups in the Solaris Operating System, the file system must be inactive. Otherwise, the output may be inconsistent. A file system is inactive when it's unmounted or it's write-locked by the operating system. Although the fssnap utility…
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 get help with Linux/Unix bash shell commands. Use help to read help documents for built in bash shell commands.: Use man to interface with the online reference manuals for shell commands.: Use man to search man pages for unknown command…
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

770 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