Maximum Total Files Open per Application (maxtotfilop)

Configuration Type

Database manager

Applies to

• Database Server with local and remote clients
• Database Server with local clients
• Partitioned Database Server with local and remote clients
• Satellite Database Server with local clients

Parameter Type

Configurable

Default [Range]

16 000 [ 100 - 32 768 ]

Unit of Measure

Counter

Related Parameters

Maximum Database Files Open per Application (maxfilop)

This parameter defines the maximum number of files that can be opened by all agents and other threads executing in a single database manager instance. If opening a file causes this value to be exceeded, an error is returned to your application.

Note:

This parameter does not apply to UNIX-based platforms.

Recommendation: When setting this parameter, you should consider the number of file handles that could be used for each database in the database manager instance. To estimate an upper limit for this parameter:

1. Calculate the maximum number of file handles that could be opened for each database in the instance, using the following formula:

       maxappls * maxfilop
   

2. Calculate the sum of above results and verify that it does not exceed the parameter maximum.

If a new database is created, you should re-evaluate the value for this parameter.

You should also validate the total file handles that may be used on your system does not exceed the system maximum using the following formula:

     (sum of maxtotfilop for all instances on machine)
   + (estimate of file handles required by other applications)
   <= 65535