News
Abstract
Add QSYS2.REMOVE_PERFORMANCE_MONITOR procedure
Content
You are in: IBM i Technology Updates > Db2 for i - Technology Updates > Db2 for i Database Engineer (DBE) Enhancements > Add QSYS2.REMOVE_PERFORMANCE_MONITOR procedure
Db2 for IBM i plan cache snapshots and performance monitors reside within physical files and are tracked for System i Navigator users within the QUSRSYS/QAUGDBPMD2 *FILE.
When the DUMP_PLAN_CACHE procedure is called to create an SQL Plan Cache snapshot, a procedure interface is needed to remove the snapshot file object and any entries for the file object from the tracking table.
The QSYS2/REMOVE_PERFORMANCE_MONITOR() procedure accepts two parameters and removes the SQL table matching that name and the associated entries from the QUSRSYS/QAUGDBPMD2 *FILE.
Example usage where the last 6 months of SQL Plan Cache data are saved:
-- Dump current month
CALL QSYS2.DUMP_PLAN_CACHE('CACHELIB','NOV2011')
-- Remove dump no longer needed
CALL QSYS2.REMOVE_PERFORMANCE_MONITOR('CACHELIB','MAY2011')
[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SWG60","label":"IBM i"},"Component":"","Platform":[{"code":"PF012","label":"IBM i"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"LOB57","label":"Power"}}]
Was this topic helpful?
Document Information
Modified date:
11 April 2021
UID
ibm11169272