[IQUG] [CAUTION] Re: SQLtrace

Mumy, Mark mark.mumy at sap.com
Tue Jul 10 10:06:31 MST 2018


I'm running IQ 16.1, but that's not what I see:

1> select @@version
2> select property('RequestLogging')
3> go
 @@version
 ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 SAP IQ/16.1.020.552/10613/P/sp02.02/Linux/Linux64 - x86_64 - 2.6.18-194/64bit/2017-10-13 11:11:32

(1 row affected)
 property('RequestLogging')
 --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 ALL




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, 11:01 AM, "Alexander Blyakher" <alexblyakher at yahoo.com> wrote:

    Well. When server is started with -zr All on 15.4, query select property(‘RequestLogging’) comes returns “ALL”, on 16 it comes back with “SQL”.
    
    Sent from my iPhone
    
    > On Jul 9, 2018, at 10:40 AM, Mumy, Mark <mark.mumy at sap.com> wrote:
    > 
    > Or are you referring to the shortened SA plans that it can generate?
    > 
    > 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:38 AM, "iqug-bounces at iqug.org on behalf of Mumy, Mark" <iqug-bounces at iqug.org on behalf of mark.mumy at sap.com> wrote:
    > 
    >     -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