News
Abstract
QSYS2.DATABASE_MONITOR_INFO Catalog
Content
You are in: IBM i Technology Updates > Db2 for i - Technology Updates > Db2 for i Performance Enhancements > QSYS2.DATABASE_MONITOR_INFO Catalog
See the IBM i Knowledge Center for details: DATABASE_MONITOR_INFO view
Examples:
Example 1. An active SQL plan cache event and database monitor query:
Example 2. Show column FILE_FILTERING specified on output for active database public and current private monitors query:
Example 3. Use Database_Monitor_Info view for finding SQL plan cache event monitors that need to be ended because they are larger then a specified size:
Example 4. Using the MONITOR_ID to end an SQL plan cache event monitor:
[{"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:
21 January 2020
UID
ibm11168246