RE: High LRU writes on temporary dbspace
Run this sql against the sysmaster database. It should give you some clue
as to who is creating the temp tables.
SELECT d.name[1,5] dbspace
, trim(n.dbsname) || ":" || trim(n.owner) || ":" || trim(n.tabname)
table
, i.ti_nptotal allocated_pages
FROM systabnames n
, systabinfo i
, sysdbstab d
WHERE bitval(i.ti_flags, "0x0020") = 1
AND i.ti_partnum = n.partnum
AND d.dbsnum = trunc((hex(i.ti_partnum)/1048576))
ORDER BY 3 DESC
;
Regards,
Bill
> -----Original Message-----
> From: spirin_alex@mail.ru [SMTP:spirin_alex@mail.ru]
> Sent: Friday, July 09, 2004 12:44 AM
> To: informix-list@iiug.org
> Subject: 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
sending to informix-list