IBM i Global

IBM i 

A space for professionals working with IBM’s integrated OS for Power systems to exchange ideas, ask questions, and share expertise on topics like RPG and COBOL development, application modernization, open source integration, system administration, and business continuity.


#Power


#IBMi
#Power
 View Only

  • 1.  Visual Explain Optimizer Not Available

    Posted Wed August 23, 2023 10:14 AM

    When using Visual Explain in ACS the Optimizer Messages tab displays "Optimizer messages are not available."

    How can I get the optimizer messages to show up?



    ------------------------------
    David Hammond
    ------------------------------

    #IBMiAccessClientSolutions



  • 2.  RE: Visual Explain Optimizer Not Available

    Posted Thu August 24, 2023 02:09 AM

    Dear David

    What is IBM i release in the server and what release is your ACS?    Do you access database tables/views or do you invoke SQL service?  Can you post the access plan graph you see?



    ------------------------------
    Education is not the learning of facts but the training of the mind to think. -- Albert Einstein.
    ------------------------------
    Satid S.
    ------------------------------

    Original Message


  • 3.  RE: Visual Explain Optimizer Not Available

    Posted Thu August 24, 2023 02:15 AM

    Another thing to check is whether you have already enabled debug messages?   

    From the main menu bar of Run SQL Script, select Edit --> Preferences....     Then look for and check the option "Include debug messages in job log" and click OK.



    ------------------------------
    Education is not the learning of facts but the training of the mind to think. -- Albert Einstein.
    ------------------------------
    Satid S.
    ------------------------------

    Original Message


  • 4.  RE: Visual Explain Optimizer Not Available

    Posted Thu August 24, 2023 12:41 PM

    Thank you! It was the "Include debug messages in job log" option that fixed it for me.

    By the way, the IBM i version is 7.4 and the ACS version is 1.1.9.3.



    ------------------------------
    David Hammond
    ------------------------------

    Original Message


Related Content