RE: onstat -g sql in 9.4
SYSSQEXPLAIN still exists in 9.40
sqx_sessionid 40
sqx_sdbno 0
sqx_iscurrent N
sqx_executions 0
sqx_cumtime 0.00
sqx_bufreads 0
sqx_pagereads 0
sqx_bufwrites 0
sqx_pagewrites 0
sqx_totsorts 0
sqx_dsksorts 0
sqx_sortspmax 0
sqx_conbno 0
sqx_ismain Y
sqx_selflag SQ_SELECT
sqx_estcost 9
sqx_estrows 11
sqx_seqscan 0
sqx_srtscan 0
sqx_autoindex 0
sqx_index 0
sqx_remsql 3
sqx_mrgjoin 0
sqx_dynhashjoin 0
sqx_keyonly 0
sqx_tempfile 2
sqx_tempview 0
sqx_secthreads 0
sqx_sqlstatement select colno, colname, coltype, collength,
informix.syscolumn
s.extended_id, name from informix.syscolumns,
informix.systab
les, outer informix.sysxtdtypes where
informix.syscolumns.ta
bid = informix.systables.tabid and
informix.syscolumns.extend
ed_id = informix.sysxtdtypes.extended_id and tabname = ?
and informix.systables.owner = ? order by
informix.syscolumns.colno;
-----Original Message-----
From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org] On Behalf Of malcolm weallans
Sent: Thursday, June 03, 2004 8:38 AM
To: 'scottishpoet'; informix-list@iiug.org
Subject: 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 7
days
> > 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
________________________________
<< ella for Spam Control >> has removed 1439 Spam messages and set aside 642 Newsletters for me
You can use it too - and it's FREE! www.ellaforspam.com
sending to informix-list