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

<timothy.a.brown@marconi.com> wrote in message news:bve8i2$hap$1@terabinaries.xmission.com... > > > please post 'onstat -g mgm' $ onstat -g mgm Informix Dynamic Server Version 7.31.FD5 -- On-Line -- Up 07:18:41 -- 2993496 Kbytes Memory Grant Manager (MGM) -------------------------- MAX_PDQPRIORITY: 40 DS_MAX_QUERIES: 10 DS_MAX_SCANS: 1048576 DS_TOTAL_MEMORY: 92160 KB Queries: Active Ready Maximum 10 11 10 Memory: Total Free Quantum (KB) 92160 9216 9216 Scans: Total Free Quantum 1048576 1048566 1 Load Control: (Memory) (Scans) (Priority) (Max Queries) (Reinit) Gate 1 Gate 2 Gate 3 Gate 4 Gate 5 (Queue Length) 0 0 0 11 0 Active Queries: --------------- Session Query Priority Thread Memory Scans Gate 2127 c00000009ed80820 8 c00000009f79a770 0/0 1/1 - 2403 c0000000a9199d88 8 1152/1152 1/1 - 2378 c0000000a7a17d88 8 465/1152 0/1 - 2380 c0000000a7c11d88 8 459/1152 0/1 - 2412 c00000009ed0a5e0 8 460/1152 1/1 - 2409 c00000009f0a05e0 8 466/1152 1/1 - 2382 c0000000a7dd1d88 8 563/1152 1/1 - 2384 c0000000a7f73d88 8 466/1152 1/1 - 2386 c0000000a81025a0 8 460/1152 1/1 - 2397 c0000000a05d5b68 8 586/1152 0/1 - Ready Queries: -------------- Session Query Priority Thread Memory Scans Gate 2421 c00000009eee4410 8 c0000000a7a5e760 0/1152 0/1 4 2367 c00000009ecbf850 8 c0000000a8323818 0/1152 0/1 4 2377 c0000000a0e4b850 8 c0000000a33398b8 0/1152 0/1 4 2402 c0000000a0ef7850 8 c0000000a787bd40 0/1152 0/1 4 2400 c00000009f81d050 8 c0000000a7257e60 0/1152 0/1 4 2393 c0000000a8850f40 8 c0000000a7a5e4a0 0/1152 0/1 4 2401 c00000009ffd1ba0 8 c0000000a08e4450 0/1152 0/1 4 2396 c0000000a4a3f050 8 c0000000a21d15f0 0/1152 0/1 4 2394 c0000000a33416d0 8 c0000000a6a732f0 0/1152 0/1 4 2395 c00000009f3640d8 8 c0000000a06d5550 0/1152 0/1 4 2379 c0000000a0bb18a0 8 c0000000a5994da8 0/1152 0/1 4 Free Resource Average # Minimum # -------------- --------------- --------- Memory 8467.7 +- 1958.6 1152 Scans 1048572.4 +- 0.0 1048559 Queries Average # Maximum # Total # -------------- --------------- --------- ------- Active 4.0 +- 2.3 10 90264 Ready 20.8 +- 8.4 44 631 Resource/Lock Cycle Prevention count: 0