<div>
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.<br />
==&gt; 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.<br />
<br />
But you are correct that this parameter should not be on the priority 1 list of the tuning team...<br />
NB: I think good antivirus don't care of direct IO to open files but they may act at closing time on your db...<br />
<br />
Hope this helps.
</div>


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.

<div>
<div class="content wysiwyg-content">
Hey,<br />
<br />
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<br />
<br />
Anyone else got a better reason/explanation?
</div>
</div>


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?

MAXFILOP, why not start with a large value?

IBM DB2 is a family of relational database server products developed by IBM that have been extended to support object-relational features and non-relational structures like JSON and XML. There are three main products in the DB2 family: DB2 for Linux, UNIX and Windows (informally known as DB2 LUW), DB2 for z/OS (mainframe), and DB2 for i (formerly OS/400), plus a version for IBM's Virtual Storage Extended (VSE) operating system.