Solved

AIX ulimit

Posted on 2013-01-31
13
927 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
Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

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

ScreenConnect 6.0 Free Trial

Want empowering updates? You're in the right place! Discover new features in ScreenConnect 6.0, based on partner feedback, to keep you business operating smoothly and optimally (the way it should be). Explore all of the extras and enhancements for yourself!

Question has a verified solution.

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

Suggested Solutions

In tuning file systems on the Solaris Operating System, changing some parameters of a file system usually destroys the data on it. For instance, changing the cache segment block size in the volume of a T3 requires that you delete the existing volu…
Java performance on Solaris - Managing CPUs There are various resource controls in operating system which directly/indirectly influence the performance of application. one of the most important resource controls is "CPU".   In a multithreaded…
Learn several ways to interact with files and get file information from the bash shell. ls lists the contents of a directory: Using the -a flag displays hidden files: Using the -l flag formats the output in a long list: The file command gives us mor…
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.

810 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