SQL in onstat -g ses output
Dumb question time: What is the difference between "Current SQL statement"
and "Last Parsed SQL statement"? Usually the SQL is identical in both but
I've always wondered why sometimes this is not the case. And why might
only Last parsed SQL statement be displayed as in the output below?
Informix Dynamic Server Version 9.30.TC1 -- On-Line -- Up 2 days 00:16:53 --
190208 Kbytes
session #RSAM total used
id user tty pid hostname threads memory memory
2753 informix - 1524 ariz3.re 1 61440 36008
tid name rstcb flags curstk status
5457 sqlexec 11af2b30 Y--P--- 712 cond wait(netnorm)
Memory pools count 1
name class addr totalsize freesize #allocfrag #freefrag
2753 V 13d30020 61440 25432 108 21
name free used name free used
overhead 0 1648 scb 0 96
opentable 0 5200 filetable 0 976
log 0 4200 temprec 0 2400
keys 0 728 gentcb 0 1272
ostcb 0 2536 sqscb 0 13264
sql 0 40 rdahead 0 256
hashfiletab 0 280 osenv 0 464
sqtcb 0 2600 fragman 0 48
Sess SQL Current Iso Lock SQL ISAM F.E.
Id Stmt type Database Lvl Mode ERR ERR Vers
2753 - az21 - Not Wait 0 0 9.03
Last parsed SQL statement :
select * from acct_version