Solved

MAXFILOP, why not start with a large value?

Posted on 2004-09-06
2
653 Views
Last Modified: 2008-01-09
Hey,

I got asked by a colleague why bother tuning the MAXFILOP parameter, if there are no other important systems on the server, why not just start off with a value of 500 or 1000. The best I can come up with is Antivirus :P

Anyone else got a better reason/explanation?
0
Comment
Question by:meehange
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 18

Expert Comment

by:BigSchmuh
ID: 11990982
I think (means I'm not sure) this parameter make some virtual memory space reservation for the file to open thus lowering your available virtual memory for bufferpools and others.
==> Remember on Win2000 or XP, you only have up to 2 Gb (or 3 Gb starting with Advanced Server Edition and /3GB parameter) which is very short for usual db with many conccurent users.

But you are correct that this parameter should not be on the priority 1 list of the tuning team...
NB: I think good antivirus don't care of direct IO to open files but they may act at closing time on your db...

Hope this helps.
0
 
LVL 13

Accepted Solution

by:
ghp7000 earned 50 total points
ID: 11992717
well, the default should work well in most cases, thats why there are default values. I don't think you'll see much degradtion in performance if you set this higher than the default, but you may see an improvement because too small values increase the overhead of closing files that the agent no longer needs to make room for the file(s) that is does need. If no files can be closed, then an error message will be returned.
Also, the database manager parameter maxtotfilop, that is the maximum total files open configuration parameter
is calculated as maxappls*maxfilops, if this exceeds 32,768, you will get error messages

0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

November 2009 Recently, a question came up in the DB2 forum regarding the date format in DB2 UDB for AS/400.  Apparently in UDB LUW (Linux/Unix/Windows), the date format is a system-wide setting, and is not controlled at the session level.  I'm n…
Recursive SQL in UDB/LUW (it really isn't that hard to do) Recursive SQL is most often used to convert columns to rows or rows to columns.  A previous article described the process of converting rows to columns.  This article will build off of th…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an antispam), the admini…

732 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