dbWorker

Hi, Folks, IDS 12.10 FC4, Linux 6 Any comments on the following job? Seems it take excessive resources ...? Can it be sopped? how to stop? Thanks Frank [informix@ncdopsdba101 info]$ onstat -g ses 4702828 IBM Informix Dynamic Server Version 12.10.FC4W1XU -- On-Line -- Up 9 days 02:55:10 -- 19140800 Kbytessession effective #RSAM total used dynamic id user user tty pid hostname threads memory memory explain 4702828 informix - - 0 - 1 442368 429248 off Program : - tid name rstcb flags curstk status 4938422 dbWorker 98e8b228 ---P--- 13424 running- Memory pools count 2 name class addr totalsize freesize #allocfrag #freefrag 4702828 V a6c74040 438272 12312 453 15 4702828*O0 V a6e9e040 4096 808 1 1 name free used name free used overhead 0 6576 mtmisc 0 200 resident 0 72 scb 0 216 opentable 0 18240 filetable 0 2744 ru 0 600 log 0 16536 temprec 0 36000 partn 0 72 keys 0 384 ralloc 0 279536 gentcb 0 1592 ostcb 0 2944 sqscb 0 22016 sql 0 12680 hashfiletab 0 552 sqtcb 0 11768 fragman 0 5728 shmblklist 0 216 la_append_t 0 2304 la_bufhdr_p 0 72 la_bufhdr_t 0 416 la_bm_buffs 0 2104 sapi 0 216 SAPI callback 0 480 udr 0 2440 sqlj 0 264 rsam_seqscan 0 2136 sqscb info scb sqscb optofc pdqpriority optcompind directives 6e4e90d8 9b180028 0 0 0 1 Sess SQL Current Iso Lock SQL ISAM F.E. Id Stmt type Database Lvl Mode ERR ERR Vers Explain 4702828 INSERT sysadmin DR Wait 5 0 0 - Off Current SQL statement (8) : INSERT INTO mon_page_usage select 254 , trunc(P.partnum / 1048577) as dbsnum, CASE WHEN P.nkeys = 1 AND P.npused > 1 AND P.npdata = 0 AND P.partnum <> P.lockid AND bitand(P.flags,4) = 0 THEN "I" ELSE "T" END as type, P.partnum, P.lockid, P.nextns, P.nrows, P.nptotal, P.npused, P.nptotal - ( BM.partly_used+BM.mostly_used+BM.very_full) AS free ,BM.partly_used ,BM.mostly_used , BM.very_full, CURRENT FROM sysmaster:sysptnhdr P, outer (select b.pb_partnum as partnum, (b.pb_partnum/1048577)::integer as dbsnum ,sum(decode(bitand(b.pb_bitmap, 12),4 ,1,0)) as partly_used ,sum(decode(bitand(b.pb_bitmap, 12),8 ,1,0)) as mostly_used ,sum(decode(bitand(b.pb_bitmap, 12),12,1,0)) as very_full from sysmaster:sysptnbit b where b.pb_bitmap > 0 group by b.pb_partnum ) as BM WHERE P.partnum = BM.partnum and bitand(p.flags,"0xE0") = 0 and sysmaster:partpagenum(P.partnum)>1;UPDATE STATISTICS HIGH FOR TABLE mon_page_usage(ID,dbsnum,partnum,lockid) Last parsed SQL statement : INSERT INTO mon_page_usage select 254 , trunc(P.partnum / 1048577) as dbsnum, CASE WHEN P.nkeys = 1 AND P.npused > 1 AND P.npdata = 0 AND P.partnum <> P.lockid AND bitand(P.flags,4) = 0 THEN "I" ELSE "T" END as type, P.partnum, P.lockid, P.nextns, P.nrows, P.nptotal, P.npused, P.nptotal - ( BM.partly_used+BM.mostly_used+BM.very_full) AS free ,BM.partly_used ,BM.mostly_used , BM.very_full, CURRENT FROM sysmaster:sysptnhdr P, outer (select b.pb_partnum as partnum, (b.pb_partnum/1048577)::integer as dbsnum ,sum(decode(bitand(b.pb_bitmap, 12),4 ,1,0)) as partly_used ,sum(decode(bitand(b.pb_bitmap, 12),8 ,1,0)) as mostly_used ,sum(decode(bitand(b.pb_bitmap, 12),12,1,0)) as very_full from sysmaster:sysptnbit b where b.pb_bitmap > 0 group by b.pb_partnum ) as BM WHERE P.partnum = BM.partnum and bitand(p.flags,"0xE0") = 0 and sysmaster:partpagenum(P.partnum)>1;UPDATE STATISTICS HIGH FOR TABLE mon_page_usage(ID,dbsnum,partnum,lockid) --001a113ac2ae1fa46a052229fdf1