IBM Support

QSYS2.DUMP_PLAN_CACHE procedure

News


Abstract

QSYS2.DUMP_PLAN_CACHE procedure

Content

For complete detail, visit this IBM Documentation page: DUMP_PLAN_CACHE procedure

Enhanced with IBM i 7.5 SF99950 Level 7 & IBM i 7.4 SF99704 Level 28:

  • Add IASP_NAME optional filter parameter

Enhanced with IBM i 7.5 SF99950 Level 5 & IBM i 7.4 SF99704 Level 26:

  • Add SQL_STATEMENT_TEXT_FILTER and INCLUDE_SYSTEM_QUERIES optional filter parameters

Enhanced with IBM i 7.4 SF99704 Level 13 and IBM i 7.3 SF99703 Level 24:

  • Add PLAN_IDENTIFIER optional filter parameter

[{"Type":"MASTER","Line of Business":{"code":"LOB68","label":"Power HW"},"Business Unit":{"code":"BU070","label":"IBM Infrastructure"},"Product":{"code":"SWG60","label":"IBM i"},"ARM Category":[{"code":"a8m0z0000001go6AAA","label":"IBM i Db2-\u003ESQL Services \/ table functions"}],"ARM Case Number":"","Platform":[{"code":"PF012","label":"IBM i"}],"Version":"6.1.0;and future releases"}]

Document Information

Modified date:
21 April 2024

UID

ibm16442053