DB2 10.5 for Linux, UNIX, and Windows

maxfilop - Maximum database files open per database

This parameter specifies the maximum number of file handles that can be open per database. Each active application is counted towards the value specified by maxfilop.

Configuration type

Database

Parameter type

Configurable online
Configurable by member in a DB2® pureScale® environment

Propagation class

Transaction boundary

Default [range]

AIX®, Sun, HP, and Linux 64-bit: 61 440 [64 - 61 440]
Linux 32-bit: 30 720 [64 - 30 720]
Windows 32-bit: 32 768 [64 - 32 768]
Windows 64-bit: 65 335 [64 - 65 335]

Unit of measure

Counter

If opening a file causes this value to be exceeded, some files in use by this database are closed. If maxfilop is too small, the additional processing time of opening and closing files will become excessive and might degrade performance.

Both SMS table spaces and DMS table space file containers are treated as files in the database manager's interaction with the operating system, and file handles are required. More files are generally used by SMS table spaces compared to the number of containers used for a DMS file table space. Therefore, if you are using SMS table spaces, you will need a larger value for this parameter compared to what you would require for DMS file table spaces.

You can also use this parameter to ensure that the overall total of file handles used by the database manager does not exceed the operating system limit by limiting the number of handles per database to a specific number; the actual number will vary depending on the number of databases running concurrently.