RE: onstat -g sql in 9.4
I will be testing 9.4 in the next few days and I will need this feature.
Does anybody know if the sql_stmt fields have been removed from
sysmaster.
Regards
Malcolm
-----Original Message-----
From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org]
On Behalf Of scottishpoet
Sent: 03 June 2004 00:55
To: informix-list@iiug.org
Subject: Re: onstat -g sql in 9.4
Yes, please log and case and get your case cross referenced against this
bug so R&D can see the impact removing this facility had.
The fix is included in 9.40.UC5
roy_d_mercer_1234@yahoo.com (Roy D. Mercer) wrote in message
news:<8e756880.0406021038.556facfc@posting.google.com>...
> I reported this as a bug about six months ago.
>
> Bug: 165499 DBACCESS - LAST PARSED SQL STATEMENT DOES NOT SHOW UP IN
> ONSTAT -G SQL OR ONSTAT -G SES
>
> They said it should be fixed in 9.40.UC5
>
> Do call an open a case to make sure they get it coded in this release.
> Thanks
>
>
>
>
> bothwellno@spam.duke.edu wrote in message
> news:<c9ifa0$ftd$1@gargoyle.oit.duke.edu>...
> > We use the output from onstat -g sql <sessid> to assist with problem
> > resolution. The value of 'Last parsed SQL statement' is very helpful
> > to find problematic SQLs.
> >
> > We are upgrading from 7.31 (AIX 4.3.2) to 9.40 (AIX 5.2) and have
> > noticed that in version 9.40, the 'Last parsed SQL statement'
> > section does not appear in the output of 'onstat -g sql' after the
> > last SQL statement has been run. Here is an example:
> >
> > Type in:
> >
> > dbaccess stores7
> >
> > The choose 'Query -language', then 'New'. Type in the following
> > query and then run it:
> >
> > close database;
> > database stores7;
> > select count(*) from items;> >
> > On another session, run 'onstat -g sql <sessid>'.
> >
> > Version 7.31.UD4 shows this:
> >
> > Informix Dynamic Server Version 7.31.UD4 -- On-Line -- Up 6 days
> > 22:34:04 --
> > 1212160 Kbytes
> >
> > Sess SQL Current Iso Lock SQL ISAM
F.E.
> > Id Stmt type Database Lvl Mode ERR ERR
Vers
> > 7289 - stores7 CR Not Wait 0 0
7.31
> >
> > Last parsed SQL statement :
> > select count(*) from items> >
> > Version 9.40.UC2 shows this:
> >
> > IBM Informix Dynamic Server Version 9.40.UC2 -- On-Line -- Up 7days
> > 10:59:1
> > 3 -- 1887040 Kbytes
> >
> > Sess SQL Current Iso Lock SQL ISAM
F.E.
> > Id Stmt type Database Lvl Mode ERR ERR
Vers
> > Explain
> >
> > 32571 - stores7 NL Not Wait 0 0
9.03
> > Off
> >
> >
> > Any thoughts or ideas on this? I searched the release notes &
> > documentation and did not find anything related to this. Is there a
> > configuration parameter to enable this?
> >
> > Thanks.
> >
> > Bob
sending to informix-list