shahid.mehmood@aku.edu - Email has different SMTP TO: and MIME TO: fields in the email addresses - Re: Slow reposnse
please post 'onstat -g mgm'
"Neil Truby"
<neil.truby@ardent To: informix-list@iiug.org
a.com> cc:
Sent by: Subject: Slow reposnse
owner-informix-lis
t@iiug.org
01/30/2004 10:29
AM
Please respond to
"Neil Truby"
7.31 FD5 on HP-UX 11.0
Users are complaining that their data loads are getting virtually no
activity.
The logs are not full, there are no untoward messages in online log, and
glance/top shows the UNIX host be gently loaded
Even trying to use dbaccess to get info about the table syssessions on
database sysmaster is freezing. onstat -g ses shows as below. Can anyone
interpret the flags for me?
thanks
Neil
$ onstat -g ses 2259
Informix Dynamic Server Version 7.31.FD5 -- On-Line -- Up 05:15:23 --
2993496 Kbytes
session #RSAM total used
id user tty pid hostname threads memory memory
2259 informix th 538 info01 4 131072 123232
tid name rstcb flags curstk status
189378 sqlexec c0000000a08b55e8 ---P--- 267584 sleeping(secs: 2)
189434 join_1.0 c0000000a08b4f00 Y------ 268416 cond wait(await_MC1)
189435 join_1.1 c00000009dc59e68 Y------ 268416 cond wait(await_MC1)
189436 scan_2.0 c0000000a43f2fb0 Y------ 268416 cond wait(await_MC2)
Memory pools count 1
name class addr totalsize freesize #allocfrag
#freefrag
2259 V c0000000a0975028 131072 7840 438 2
name free used name free used
overhead 0 184 scb 0 144
opentable 0 6856 filetable 0 3512
log 0 8672 temprec 0 4360
keys 0 272 ralloc 0 46200
gentcb 0 15304 ostcb 0 3368
sqscb 0 10880 rdahead 0 864
xchg_desc 0 3624 xchg_port 0 2512
xchg_packet 0 1744 xchg_group 0 208
xchg_priv 0 536 hashfiletab 0 2208
osenv 0 3080 sqtcb 0 7104
fragman 0 584 shmblklist 0 1016
Sess SQL Current Iso Lock SQL ISAM F.E.
Id Stmt type Database Lvl Mode ERR ERR Vers
2259 SELECT sysmaster CR Not Wait 0 0 7.31
Current statement name : colcur
Current SQL statement :
select colno, colname, coltype, collength from informix.syscolumns,
informix.systables where informix.syscolumns.tabid =
informix.systables.tabid and tabname = ? and owner = ? order by
informix.syscolumns.colno;
Last parsed SQL statement :
select colno, colname, coltype, collength from informix.syscolumns,
informix.systables where informix.syscolumns.tabid =
informix.systables.tabid and tabname = ? and owner = ? order by
informix.syscolumns.colno;
$
sending to informix-list
sending to informix-list