Error in log file

[Sandeep Menon_1]

I am a DBA and am facing an error that is related to a file system issue. I am using a jfs file system for one of my database tablespaces. During the run of some jobs, the error that gets logged in the log file is

SMS Tablespace 4(TEMP4K) is FULL or file is too large (at OS or user limit).

This ia a 10G file system. I know that this error occurs either when the filesystem is full or an individual file crosses it's maximum limit in size. I made this file system large file enabled. I thought that the max limit of a file on a large file enabled file system was above 2 Gigs. Do correct me if I am wrong.
Sandeep

[Rick Garland]

What is the ulimit for the user trying to save the file?

This can govern how big a file the user can save.

[RAC_1]

As you said, FS is large files enabled, ensure it. mount -v|grep FS, does it show large files enabled?? Is the FS mounted as largefiles enabled?

Anil

[A. Clay Stephenson · Accepted solution]

Generally, you will also see the OS errno. ENOSPC (28) means that the filesystem (or device) is full. EFBIG (27) means that you have exceeded ulimit or quotas. You are correct that enabling largefiles allows you to exceed the 2GB filesize limit; However, it does not mean that your particular application will support files larger than 2GB. It would be helpful to know what the size of the file is that is having problems and is the filesystem full?

[Sandeep Menon_1]

I am running AIX ver 5.1 and I checked the file system characteristics using smit - and it shows large file enabled as true. About the ulimit of the users, the application writes the file using the database instance owner authority and the ulimit is set as unlimited for that user. How much is the max limit of a file on a large file enabled file system? I am using the 32 bit AIX.

[Sandeep Menon_1]

The system error messages you mentioned, ENOSPC (28) and EFBIG (27) - where can I see these errors from a system standpoint? which file logs these errors?
Thanks for the replies.