IBM i Global

 View Only
Expand all | Collapse all

How to reuse sql plan cache snapshot on IBM i?

  • 1.  How to reuse sql plan cache snapshot on IBM i?

    Posted Mon October 18, 2021 08:41 PM

    Hi, I would like to reuse our sql plan cache upon IPL as our server tends to be slower the first few hours after an IPL as it rebuilds MTI's, etc. I've discovered information on how to dump the sql plan cache using qsys2.dump_plan_cache stored procedure. What are the necessary steps to reuse this information?

    Thanks, L


    #IBMi
    #Support
    #SupportMigration


  • 2.  RE: How to reuse sql plan cache snapshot on IBM i?

    Posted Tue October 19, 2021 06:59 AM

    Hi,

    IPL Clear Plan Cache and there isn't possible to rebuild or recreate ... The Dump or snapshop are created to analyze.

    If you want avoid rebuild MTI you must create permanent Index ... or do less IPL ...


    #Support
    #IBMi
    #SupportMigration