Topic
IC4NOTICE: developerWorks Community will be offline May 29-30, 2015 while we upgrade to the latest version of IBM Connections. For more information, read our upgrade FAQ.
No replies
AngocA
AngocA
25 Posts
ACCEPTED ANSWER

Pinned topic Quantity of open files in DB2

‏2013-04-27T14:02:44Z |

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?

Thanks.