Solved

MAXFILOP, why not start with a large value?

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

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
how can i import or extract data from Progressor db? 6 279
db2 connect on mac 3 490
Connect SQL Developer to zO/S DB2 database 6 223
Access to SYSIBM tables 7 95
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…
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…
I designed this idea while studying technology in the classroom.  This is a semester long project.  Students are asked to take photographs on a specific topic which they find meaningful, it can be a place or situation such as travel or homelessness.…
A company’s greatest vulnerability is their email. CEO fraud, ransomware and spear phishing attacks are the no1 threat to a company’s security. Cybercrime is responsible for the largest loss of money to companies today with losses projected to r…

930 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now