Reducing memory consumption using CATALOG_OBJECTS

When Db2 Query Monitor collects object details for a site that runs a large number of dynamic SQL statements, the number of catalog objects that are tracked by Db2 Query Monitor may grow quite large.

For instance, numerous catalog objects are accessed during the bind (prepare) process for a dynamic SQL statement. Since Db2 Query Monitor collects statistics on those objects, a large number of objects are tracked when numerous dynamic SQL statements execute. This results in the increased consumption of dataspace storage per interval.

Db2 Query Monitor enables you to turn off the collection of object-related data for SQL PREPARE calls, resulting in lower CPU consumption and memory savings when you specify a value of N for the CATALOG_OBJECTS startup parameter.