topic Re: Error in log file in Operating System - HP-UX

Error in log file

Sandeep Menon_1 — Tue, 15 Feb 2005 12:05:26 GMT

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

Re: Error in log file

Rick Garland — Tue, 15 Feb 2005 12:12:46 GMT

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

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

Re: Error in log file

RAC_1 — Tue, 15 Feb 2005 12:13:59 GMT

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

Re: Error in log file

A. Clay Stephenson — Tue, 15 Feb 2005 12:18:01 GMT

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?

Re: Error in log file

Sandeep Menon_1 — Tue, 15 Feb 2005 12:25:25 GMT

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.

Re: Error in log file

Sandeep Menon_1 — Tue, 15 Feb 2005 12:45:07 GMT

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.