• No replies
25 Posts

Pinned topic Quantity of open files in DB2

‏2013-04-27T14:02:44Z | db2 dbdsupport files maxfilop open

I would like to monitor the quantity of open files by DB2, and then compare that value with MAXFILOP.

Actually, I want to monitor if DB2 arrives to the limit and it is opening and closing files, but this is the "critical" state.

Before, I want to warn the DBA when the quantity of open files is arriving to the limit. Probably, the DBA will do something to prevent the other situation, that in some cases produces problems (LOADs with SQL0958C) or the performace is impacted.

The only monitor element is files_closed, but is there something similar for open_files?