Solved

MAXFILOP, why not start with a large value?

Posted on 2004-09-06
2
639 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

Master Your Team's Linux and Cloud Stack!

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.

Question has a verified solution.

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

Suggested Solutions

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…
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …

809 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