max file size issue

[billy1]

Hi,

AIX 5.3

Root user
# ulimit -a
time(seconds) unlimited
file(blocks) unlimited
data(kbytes) unlimited
stack(kbytes) 32768
memory(kbytes) 32768
coredump(blocks) 2097151
nofiles(descriptors) 2000
#

Oracle user :
# ulimit -a
time(seconds) unlimited
file(blocks) unlimited
data(kbytes) 131072
stack(kbytes) 32768
memory(kbytes) 32768
coredump(blocks) 2097151
nofiles(descriptors) 2000

When I try to create a database file larger than 2GB it fails. Where is this limit set ?
The ulimits for root and oracle are unlimited as above. Is there a parameter within the filesystem somewhere which needs to be set ?
The filesystem was created as "Enhanced JFS"

Thanks,
Billy

 

[DukeSSD]

I guess you are using JFS.

"By default, JFS does not support file sizes greater than 2GB. When you create a file system, it is recommended that you create a Large File Enabled Journaled File System, which enables the file system to support file sizes up to 64GB.

 

[khalidaaa]

DukeSSD is right!

I will just add if your machine has a 64 kernel support and you are already running AIX 5.3 then why don't you go to JFS2?

It will not restrict you upto 2G and it has a much better performance than JFS!

Regards,
Khalid

 

[tempest92]

you say the filesystem was created as an "enhanced file system" i.e. jfs2. you should check this with mount or lsfs -a

 

[billy1]

Thanks !

This was fixed by another member of my team, basically for the oracle user parameters were changed :

time(seconds) unlimited
file(blocks) unlimited
data(kbytes) unlimited
stack(kbytes) 4194304
memory(kbytes) 32768
coredump(blocks) 2097151
nofiles(descriptors) 2000


The filesystem itself was an enhanced journal filesystem.
I'm not sure what the stack(kbytes) refers to but I think this was the difference.
If not feel free to correct me.

many thanks again !