Db2 Tools

 View Only

  • 1.  What changes should be done to enable for PA use DB2 V12 plan tables?

    Posted Nov 21, 2018 09:28 AM

    Hi community members.
    We use CA DB2 Plan Analyzer V 121M100
    After upgrading to DB2 V12, PA explain job produces messages as:
    PLAN_TABLE table was auto-created and format is V11
    SQLCODE = 20520
    Packages were bound with EXPLAIN(NO)
    What changes should be done to enable for PA use DB2 V12 plan tables?
    Regards



  • 2.  Re: What changes should be done to enable for PA use DB2 V12 plan tables?

    Broadcom Employee
    Posted Nov 21, 2018 02:05 PM

    If you do not receive feedback from the community, please open a case with support to research further.



  • 3.  Re: What changes should be done to enable for PA use DB2 V12 plan tables?
    Best Answer

    Broadcom Employee
    Posted Nov 26, 2018 04:19 PM

    Hi Eugene, I opened a case for you and you should get an email from the case I created for you.

    Thanks