Re: onstat -g sql in 9.4

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

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

Works fine on 9.40.UC3 on Solaris 7 "Roy D. Mercer" wrote: > > 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 -- Paul Watson # Oninit Ltd # Growing old is mandatory Tel: +44 1436 672201 # Growing up is optional Fax: +44 1436 678693 # Mob: +44 7818 003457 # www.oninit.com #