Temp Table Space Gobbled Up
Posted in 1995
How do I find the culprit here? Running Online 5.03 UC1 on HPUX 9.0.
I have 120Mbytes reserved in rootdbs for temp tables and some user
has gobbled up virtually all of it and apparently gone on vacation.
How do I find the owner and blow him off?
Some sample tbstat output follows.
Ken Miles
kenm@vcd.hp.com
----------------
$ tbstat -d
RSAM Version 5.03.UC1 -- On-Line -- Up 89 days 04:52:26 -- 52080 Kbytes
Dbspaces
address number flags fchunk nchunks flags owner name
8011f484 1 1 1 1 N informix rootdbs
8011f4b4 2 1 2 1 N informix dbspace2
8011f4e4 3 1 3 1 N informix dbspace3
[ . . . ]
7 active, 8 total
Chunks
address chk/dbs offset size free bpages flags pathname
8011efc4 1 1 0 60000 7550 PO- /dev/online_root
8011f05c 2 2 60000 988512 142389 PO- /dev/online_dbspace2
8011f0f4 3 3 0 931584 840094 PO- /dev/online_dbspace3
[ . . . ]
tbstat -t (Spaces > 10,000 pages)
Tblspaces
n address flgs ucnt tblnum physaddr npages nused npdata nrows nextns
15 801d79f4 1 1 3000042 300045 17000 16006 4861 213867 10
39 801d9374 1 1 200006f 200072 42000 40144 33675 269398 8
46 801d9ae4 1 1 300007d 300080 23000 22103 9704 718045 8
56 801da584 1 1 3000046 300049 14000 13501 4332 147278 4
57 801da694 3 1 2000044 200047 60000 51529 14233 373603 2
70 801db464 1 1 20000be 2000c1 158000 148622 106233 849860 11
77 801dbbd4 1 1 2000045 200048 10000 9330 5108 95128 4
86 801dc564 3 1 2000020 200023 62000 58584 35764 754282 5
67 active, 2000 total, 512 hash buckets