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
Solved

MAXFILOP, why not start with a large value?

Posted on 2004-09-06
2
643 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
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: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say 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 (you can use 'recursive' and 'SQL' in the same sentence) A growing number of database queries lend themselves to recursive solutions.  It's not always easy to spot when recursion is called for, especially for people una…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…
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…

792 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