[IQUG] SQLtrace

Mumy, Mark mark.mumy at sap.com
Mon Jul 9 07:37:38 MST 2018


 -zr won't generate a plan.  That comes from using IQ set options like query_plan_as_html and query_plan_after_run.

Mark
 
Mark Mumy
Strategic Technology Incubation Group
SAP Global Center of Excellence |  SAP
M +1 347-820-2136 | E mark.mumy at sap.com
My Blogs: https://blogs.sap.com/author/markmumy/
                      
https://sap.na.pgiconnect.com/I825063
Conference tel: 18663127353,,8035340905#

On 7/9/18, 9:27 AM, "iqug-bounces at iqug.org on behalf of Alexander Blyakher" <iqug-bounces at iqug.org on behalf of alexblyakher at yahoo.com> wrote:

    After 15.4 to 16 upgrade we’ve noticed that enabling logging with -zr ALL option on 16 fails to capture detailed query info, there is no plan and even sql is abbreviated or hidden for some commands.
    
    Sent from my iPhone
    _______________________________________________
    IQUG mailing list
    IQUG at iqug.org
    http://iqug.org/mailman/listinfo/iqug



More information about the IQUG mailing list