• [Info-ingres] set server_trace units of mintime, maxtime

    From Martin Bowes@21:1/5 to All on Wed Apr 21 09:35:34 2021
    Hi All,

    Am I right in assuming that the mintime=N, [maxtime=M] parts of set server_trace use units of seconds?

    Ie.mintime=600 means 600seconds.

    Martin Bowes

    <html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
    <head>
    <meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
    <meta name="Generator" content="Microsoft Word 15 (filtered medium)"> <style><!--
    /* Font Definitions */
    @font-face
    {font-family:"Cambria Math";
    panose-1:2 4 5 3 5 4 6 3 2 4;}
    @font-face
    {font-family:Calibri;
    panose-1:2 15 5 2 2 2 4 3 2 4;}
    /* Style Definitions */
    p.MsoNormal, li.MsoNormal, div.MsoNormal
    {margin:0cm;
    margin-bottom:.0001pt;
    font-size:11.0pt;
    font-family:"Calibri",sans-serif;
    mso-fareast-language:EN-US;}
    a:link, span.MsoHyperlink
    {mso-style-priority:99;
    color:#0563C1;
    text-decoration:underline;}
    a:visited, span.MsoHyperlinkFollowed
    {mso-style-priority:99;
    color:#954F72;
    text-decoration:underline;}
    span.EmailStyle17
    {mso-style-type:personal-compose;
    font-family:"Calibri",sans-serif;
    color:windowtext;}
    .MsoChpDefault
    {mso-style-type:export-only;
    font-family:"Calibri",sans-serif;
    mso-fareast-language:EN-US;}
    @page WordSection1
    {size:612.0pt 792.0pt;
    margin:72.0pt 72.0pt 72.0pt 72.0pt;}
    div.WordSection1
    {page:WordSection1;}
    </style><!--[if gte mso 9]><xml>
    <o:shapedefaults v:ext="edit" spidmax="1026" />
    </xml><![endif]--><!--[if gte mso 9]><xml>
    <o:shapelayout v:ext="edit">
    <o:idmap v:ext="edit" data="1" />
    </o:shapelayout></xml><![endif]-->
    </head>
    <body lang="EN-GB" link="#0563C1" vlink="#954F72">
    <div class="WordSection1">
    <p class="MsoNormal">Hi All,<o:p></o:p></p>
    <p class="MsoNormal"><o:p>&nbsp;</o:p></p>
    <p class="MsoNormal">Am I right in assuming that the mintime=N, [maxtime=M] parts of set server_trace use units of seconds?<o:p></o:p></p>
    <p class="MsoNormal"><o:p>&nbsp;</o:p></p>
    <p class="MsoNormal">Ie.mintime=600 means 600seconds.<o:p></o:p></p>
    <p class="MsoNormal"><o:p>&nbsp;</o:p></p>
    <p class="MsoNormal">Martin Bowes<o:p></o:p></p>
    </div>
    </body>
    </html>

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Karl Schendel@21:1/5 to Martin Bowes on Sun Apr 25 10:52:45 2021
    Copy: info-ingres@lists.planetingres.org (info-ingres@lists.planetingres.org)

    On Apr 21, 2021, at 5:35 AM, Martin Bowes <martin.bowes@ndph.ox.ac.uk> wrote:

    Hi All,

    Am I right in assuming that the mintime=N, [maxtime=M] parts of set server_trace use units of seconds?

    Ie.mintime=600 means 600seconds.


    Correct.

    As to your other question, the X100 disabled flag is in the dbstatus field of the DB config file. I don't know of any user available way to get at it, unless infodb displays it.

    Karl

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Martin Bowes@21:1/5 to Karl Schendel on Mon Apr 26 08:38:10 2021
    Copy: info-ingres@lists.planetingres.org (info-ingres@lists.planetingres.org)

    Hi Karl,

    Thanks for the clarification.

    I can get the X100 stuff via the infodb listing, but I was hoping for something in the iidatabase dbservice field.

    Marty

    -----Original Message-----
    From: Karl Schendel <schendel@kbcomputer.com>
    Sent: 25 April 2021 15:53
    To: Martin Bowes <martin.bowes@ndph.ox.ac.uk>
    Cc: info-ingres@lists.planetingres.org
    Subject: Re: [Info-ingres] set server_trace units of mintime, maxtime


    On Apr 21, 2021, at 5:35 AM, Martin Bowes <martin.bowes@ndph.ox.ac.uk> wrote:

    Hi All,

    Am I right in assuming that the mintime=N, [maxtime=M] parts of set server_trace use units of seconds?

    Ie.mintime=600 means 600seconds.


    Correct.

    As to your other question, the X100 disabled flag is in the dbstatus field of the DB config file. I don't know of any user available way to get at it, unless infodb displays it.

    Karl

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)