Admin Tools Forum

Re: Oat 2.24 SQL Explorer w/HDR

Posted By: Tim
Date: Friday, 22 May 2009, at 8:10 p.m.

In Response To: Re: Oat 2.24 SQL Explorer w/HDR (IAN ILSLEY)

Just some additional Info, I do not have the ER plugin and I am running
11.10. I just wonder if I was on 11.50 with HDR (soon to be done) will
this still not work? There was nothing mentioned in the release notes
about IDS 11.10 not being compatable with OAT 2.24. Is is supposed to
be? If not I will just be quiet about this problem...

Many thanks for all your responses.

,,,,Tim

IAN ILSLEY wrote:
> Hi Tim ,
>
> A new feature in OAT 2.24 for SQLTrace is the ability to 'store' SQL Trace
> info in permanent tables within the sysadmin database. This is done via the DB
> Scheduler which will 'capture' the SQLTrace buffer.
> I will log a defect for the scenario of using a HDR Primary.
>
> Thanks for the report.
>
> Regards
>
> Ian Ilsley
> IBM
>
> ----------
> I just upgraded my OAT to the new 2.24 and to my dismay my favorite OAT tool
> has a new problem. SQL Explorer complains that it wants to create a raw table
> on my HDR instance. I have been running HDR since Informix 7.2 and OAT has
> worked at least for my last release (I forget the number).
>
> Q- did I do the install wrong?
>
> Q- is this because OAT now requires a RAW table?
>
> If so I will go back to the old OAT.
>
> Q- does anyone know a way around this problem/requirement?
> ,,,Thanks Tim
>
> Error message when I attempt to start SQL Explorer:"
> Query:
> create raw table mon_syssqltrace_info ( serial_id serial, ID integer, task_id
> integer, orig_sql_id int8, starttime integer )
> Error: -19844
> [Informix][Informix ODBC Driver][Informix]Tables of type raw are not allowed
> in a logged database on an HDR primary server. (SQLPrepare[-19844] at
> /work/lwchan/workspace/OATPHPcompile/pdo_informix/pdo_informix/informix_driver.c:131)
> "
>
>
> *******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
>

Messages In This Thread

• Oat 2.24 SQL Explorer w/HDR
  TIMOTHY ERTL -- Thursday, 21 May 2009, at 1:15 p.m.
  • Re: Oat 2.24 SQL Explorer w/HDR IDS 11.10
    TIMOTHY ERTL -- Thursday, 21 May 2009, at 1:43 p.m.
    • Re: Oat 2.24 SQL Explorer w/HDR IDS 11.10
      IAN ILSLEY -- Thursday, 21 May 2009, at 5:32 p.m.
      • Re: Oat 2.24 SQL Explorer w/HDR IDS 11.10
        LEO CHAN -- Friday, 29 May 2009, at 6:48 p.m.
    • Re: Oat 2.24 SQL Explorer w/HDR IDS 11.10
      Claus Samuelsen -- Friday, 22 May 2009, at 3:30 a.m.
      • Re: Oat 2.24 SQL Explorer w/HDR IDS 11.10
        John Miller iii -- Friday, 22 May 2009, at 12:18 p.m.
        • Re: Oat 2.24 SQL Explorer w/HDR IDS 11.10
          Claus Samuelsen -- Friday, 22 May 2009, at 5:09 p.m.
        • Re: Oat 2.24 SQL Explorer w/HDR IDS 11.10
          Tim -- Friday, 22 May 2009, at 8:08 p.m.
          • Re: Oat 2.24 SQL Explorer w/HDR IDS 11.10
            John Miller iii -- Saturday, 23 May 2009, at 2:46 a.m.
            • RE: Oat 2.24 SQL Explorer w/HDR IDS 11.10
              Tim Ertl -- Tuesday, 26 May 2009, at 10:22 a.m.
  • Re: Oat 2.24 SQL Explorer w/HDR
    IAN ILSLEY -- Thursday, 21 May 2009, at 4:58 p.m.
    • Re: Oat 2.24 SQL Explorer w/HDR
      Tim -- Friday, 22 May 2009, at 8:10 p.m.

Admin Tools Forum is maintained by Administrator with WebBBS 5.12.