High LRU writes on temporary dbspace

Hi! Let me ask... This is small system on IDS 7.31. It was 190'000 pages writed in temp dbspace less than 1 hour on LRU writes. What can be a type of this pages? Neither permanent tables data pages no temp tables data pages... Indexes? - it is OLTP system with less then 1000 transactions per hour... [informix@bulka informix]$onstat -D [Skipped...] Chunks address chk/dbs offset page Rd page Wr pathname 86c581f8 1 1 0 44 191 /dev/rrootdbs 86c59468 2 2 0 0 1060 /dev/rphys 86c59558 3 3 0 750 713 /dev/rlogic 86c59648 4 4 0 1042 202914 /dev/rtempdbs 86c59738 5 5 0 23 2040 /dev/ramaindbs0 5 active, 2047 maximum [informix@bulka informix]$onstat -F | head Informix Dynamic Server Version 7.31.UC7 -- On-Line (Prim) -- Up 35 days 07:24:29 -- 151552 Kbytes Fg Writes LRU Writes Chunk Writes 0 191642 13696 address flusher state data 86c5a4fc 0 I 0 = 0X0 86c5a9e4 1 L 57 = 0X39 [Skipped...] ----------------------------------------- Best regards, Alex Spirin shuras@vizavibank.ru IBM Certified Solutions Expert Informix Dynamic Server V7 System Administrator

Alex V. Spirin wrote: > Hi! Let me ask... > > This is small system on IDS 7.31. > > It was 190'000 pages writed in temp dbspace less than 1 hour on LRU > writes. > What can be a type of this pages? Neither permanent tables data pages > no temp tables > data pages... Indexes? - it is OLTP system with less then 1000 > transactions per hour... many queries provoke the engine to create secret temporary tables and/or temporary indexes. The size and frequency of these temp objects depends purely on the nature and quality of the SQL's being sent to the database. It's as simple as that.