IBM Books

System Monitor Guide and Reference


System Monitor Memory Requirements - (mon_heap_sz)

The memory required for maintaining the private views of the database system monitor system monitor data is allocated from the monitor heap. Its size is controlled by the mon_heap_sz configuration parameter. The amount of memory required for monitoring activity varies widely depending on the number of monitoring applications and event monitors, the switches set, and the level of database activity. The following formula provides an approximation of the number of pages required for the monitor heap.

     (number of monitoring applications + 1) *
     (number of databases *
       (800 + (number of tables accessed * 20) +
         ((number of applications connected + 1) *
           (600 + (number of table spaces * 100)))))
     / 4096

You may need to experiment with this value, increasing it if monitor commands occasionally fail with an SQLCODE of -973, when the database manager switches are on.


[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]

[ DB2 List of Books | Search the DB2 Books ]