XPS V8.51 shows in the output of the onstat -g
ses <sessionid> which temporary tables of the currently active
session <sessionid> have statistics and which don't.
The following example shows this. In the highlighted part at the end, you can see that two temporary tables have been created in session 30. The table temp1 has statistics, but the table temp2 doesn't have statistics.
$ onstat -g ses 30
IBM Informix Extended Parallel Server Version 8.51.FN567 -- On-Line -- Up 22:03:43 -- 39608 Kbytes
local #RSAM total used Start Accum
sessid sessid user tty pid hostname threads memory memory Time Time
1.30 30 andreasw pts/0 28144 rat-03 1 151552 90136 10:32:07 00:23:08
tid tcb rstcb flags curstk status name
132 70000003015a250 70000000077d728 Y--P--- 2536 cond wait(netnorm) sqlexec_1.30
Memory pools count 1
name class addr totalsize freesize #allocfrag #freefrag
30 V 7000000304c4028 151552 61416 292 16
name free used name free used
overhead 0 192 scb 0 168
opentable 0 7336 filetable 0 1448
log 0 4240 temprec 0 2424
blob 0 88 keys 0 608
ralloc 0 4096 gentcb 0 14736
ostcb 0 3840 sqscb 0 21664
rdahead 0 200 hashfiletab 0 552
osenv 0 2312 sqtcb 0 960
fragman 0 1456
|--Session ID--| SQL Current Iso Lock SQL ISAM F.E. Submit Admit Current
Global Local Stmt type Database Lvl Mode ERR ERR Vers Time Time Role
1.30 30 - testdb1 CR Not Wait 0 0 8.51 - - -
PDQ priority : 0
Scheduling level : 50
Resource class (DS_CLASS): DEFAULT
Client time zone: OFF
No current SQL statement.
User-created Temp tables :
ddtabp partnum tabname rowsize ref lock use UpdStat
700000030581050 30003 temp2 4 0 0 0 N
7000000304fa850 ffff temp1 13 0 0 0 Y
|