[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 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/
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

More information about the IQUG mailing list