topic Re: File: Table is Full in Operating System - HP-UX

File: Table is Full

sycncs — Mon, 06 Jan 2003 03:53:57 GMT

I have this error (File: Table is full). When I checked, I could not find anything wrong. But it is affecting databases...can someone advice me? Thanks in advance.

Re: File: Table is Full

Veron Le — Mon, 06 Jan 2003 03:56:46 GMT

Can you try to recycle power, It seems that too many user login at this time.

Re: File: Table is Full

avsrini — Mon, 06 Jan 2003 03:57:06 GMT

Hi Lauren,
You have to increase the no. of open file (nfile) in kernel.

schedule an outage and do this, modifing the kernel requires a reboot.

Srini.

Re: File: Table is Full

avsrini — Mon, 06 Jan 2003 04:00:37 GMT

Hi Lauren,
Your system is exceeding the no. of open file size. You have to increase the nfiles parameter in your kernel.

give sar -v 2 3 and check the file-sz column.
first no. shows the current no of open files and the second no. shows the maximum configured open files.

Also you can try increasing the MAXFILES parameters.

Re: File: Table is Full

Rajeev Shukla — Mon, 06 Jan 2003 04:01:17 GMT

Yes it seems that the limit for the number of files opened has exceeded the value set by OS in the kernel. You need to increase the nfile in your kernel.

Rajeev

Re: File: Table is Full

Michael Tully — Mon, 06 Jan 2003 04:05:10 GMT

You can also utilise 'glance' to see what is being used.

(/opt/perf/bin/glance) if it is installed.

Using kmtune will give you the current information:
# kmtune -l -q nproc
# kmtune -l -q maxusers

You'll need to increase most likely both parameters, which will mean a new kernel and a reboot.

Re: File: Table is Full

sycncs — Mon, 06 Jan 2003 04:07:26 GMT

Thank you very very much, folks!! I am so impressed and touched by the strong close ties we have here.
I will take your valuable advice now and rectify the problem.

Thanks very much again! Cheers.

Re: File: Table is Full

Brian Watkins — Mon, 06 Jan 2003 19:45:28 GMT

This has always worked for me:

1. Start glance
2. Look at the System Tables Report (shortcut to this is the "t" key)

Are any of these paramters at 80% utilization or higher? If so, you should consider making a backup of your current kernel and increasing the affected values by at least 10 or 20%.

After the reboot, repeat the steps above to see what the utilization levels are, and continue to monitor them, especially during peak processing hours when the errors have been happening.

Hope this helps!

Re: File: Table is Full

sycncs — Tue, 07 Jan 2003 02:14:47 GMT

Hi Brian

Thank you very much.
Indeed it works. :-)