[IQUG] SQLtrace

Baker, Chris c.baker at sap.com
Mon Jul 9 07:38:38 MST 2018


This can also be a security risk, so SAP may not allow it any more.

Check the release notes.

Chris

-----Original Message-----
From: iqug-bounces at iqug.org [mailto:iqug-bounces at iqug.org] On Behalf Of Mumy, Mark
Sent: Monday, July 9, 2018 10:38 AM
To: Alexander Blyakher <alexblyakher at yahoo.com>; iqug at iqug.org
Subject: [CAUTION] Re: [IQUG] SQLtrace

 -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

_______________________________________________
IQUG mailing list
IQUG at iqug.org
http://iqug.org/mailman/listinfo/iqug


More information about the IQUG mailing list