DB2 Version 9.7 for Linux, UNIX, and Windows
DB2 Version 9.7 for Linux, UNIX, and Windows
The threaded database manager maintains a single shared file handle table for each database and all agents working on each database so that I/O requests made on the same file do not require the file to be reopened and closed.
Prior to Version 9.5, the file handle table was maintained separately by each DB2® agent, and the size of the per-agent file handle table was controlled by the maxfilop configuration parameter. Starting in Version 9.5, the database manager maintains a single shared file handle table for the entire database, such that the same file handle can be shared among all agents working on the same database file. As a result, the maxfilop configuration parameter is used to control the size of the shared file handle table.
Because of this change, the maxfilop configuration parameter has a different default value and new minimum and maximum values starting in Version 9.5. During database upgrade, the maxfilop configuration parameter is automatically set to this default value if you are upgrading from a release prior to Version 9.5.