News
Abstract
The CLEAR_PLAN_CACHE procedure is a plan cache clearing alternative to performing a system IPL.
Content
You are in: IBM i Technology Updates > Db2 for i - Technology Updates > Db2 for i Performance Enhancements > QSYS2.CLEAR_PLAN_CACHE() procedure
See the IBM i Knowledge Center for details: CLEAR_PLAN_CACHE procedure
Enhanced with IBM i 7.4 SF99704 Level 13 and IBM i 7.3 SF99703 Level 24:
- Add QRO_HASH and PLAN_IDENTIFIER optional filter parameters
[{"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:
12 April 2021
UID
ibm11168282