Db2

Db2

Where DBAs and data experts come together to stop operating and start innovating. Connect, share, and shape the AI era with us.


#Data


#Data
#Databases
#Operatingsystems
#Db2
#Databasesolutions
 View Only

  • 1.  DMC 3.1.4 does not show OPTGUIDELINES

    Posted 03/03/21 09:13 AM
    Hi,

    DMC does not show OPTGUIDLINES in In-flight executions.
    When OPTGUIDLINES are issued within SQL it should be displayed in the statement text (In-flight executions, package cache, etc.)

    Regards,
    Gerhard

    ------------------------------
    Gerhard Paulus
    ------------------------------

    #Db2


  • 2.  RE: DMC 3.1.4 does not show OPTGUIDELINES

    Posted 03/03/21 09:34 PM
    Hi Gerhard,

    I did a test with your use case with OPTGUIDELINES.  And I cannot find the OPTGUIDELINES syntax by default.  

    But, if you uncheck the "Normalize captured SQL statements" option in Monitor Profile > Monitor Settings section.  You should be able to see the OPTGUIDELINES syntax in Statements page.  Hope this helps.



    ------------------------------
    Jason Sizto
    ------------------------------



  • 3.  RE: DMC 3.1.4 does not show OPTGUIDELINES

    Posted 03/04/21 03:34 PM
    Edited by System Admin 01/20/23 04:50 PM
    Hi Jason,

    yes when I uncheck "Normalize captured SQL statements" the OptGuidlines are shown but this generates much more data within the repository database.
    Is it possible to change the DMC behaviour in one of these ways?
    • Normalize=checked and OptGuides are contained -> normalize and also show the OptGuides
    • add another check box "Capture OptGuidelines"
    It would be great when OptGuidelines are captured and shown though SQL are normalized.

    Best regards,
    Gerhard

    ------------------------------
    Gerhard Paulus
    ------------------------------

    Original Message


  • 4.  RE: DMC 3.1.4 does not show OPTGUIDELINES

    Posted 03/04/21 08:18 PM
    Hi Gerhard,

    Thanks for confirming the action, and your suggestions.

    I would like to understand your usage.  Do you want to know if a query uses OPTGUILDLINES or you are interested to see the OPTGUIDELINES actual syntax?

    ------------------------------
    Jason Sizto
    ------------------------------

    Original Message


  • 5.  RE: DMC 3.1.4 does not show OPTGUIDELINES

    Posted 03/05/21 09:54 AM
    Hi Jason,

    I would like to know if a query uses OPTGUIDELINES and would like to see the complete OPTGUIDELINES also for normalized SQL statements.

    Regards,
    Gerhard

    ------------------------------
    Gerhard Paulus
    ------------------------------

    Original Message


Related Content