Re: Temp Table Space Gobbled Up
You could also periodically run a 'tbcheck -pe > outfile.out' which will list all tables in each dbspace, ownerships, and sizing. +----------------------------------------------------------------------------+ | | | | . . | | | ... ... | Darin Melin | | ..... ..... | Software Engineer, DBA | | .. ... .. | Business Systems Integration Group | | . . . | Semiconductor Products Sector | | | Mesa, AZ | | Motorola, Inc. | rp29560@email.sps.mot.com Phone:(602)-655-3627 | | | melin@hermes1.sps.mot.com | | | VP - Arizona Informix Users Group | +----------------------------------------------------------------------------+ | 'connectionLESS IS MORE' -- Data Broker | +----------------------------------------------------------------------------+ } It appears to me that there must be something non-temporary in rootdbs. } If the tables are "temporary" they are released when the engine which } creates them closes down. The only time that this would not happen is if } the engine crashes, or is killed with a kill -9. } } Try shutting down your OnLine system, and restarteing it from tbinit. } That should free up all temporary space. } The only other causes are:- } Database created with no IN clause. } Table created witn IN ROOTDBS. } } The first is more likely, but I have actually seen the second in a } third-party development!!! } } } Malcolm Weallans } Online Database Consultancy } 2 Arkley Court } Maidenhead } Berks } SL6 2YR } Phone 0628-72154 } Fax 0628-37463 } CIX - onlinedbc } > 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_root8011f05c 2 2 60000 988512 142389 PO- } > /dev/online_dbspace28011f0f4 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 > } nextns15 801d79f4 1 1 3000042 300045 17000 16006 4861 > } 213867 1039 801d9374 1 1 200006f 200072 42000 40144 33675 > } 269398 846 801d9ae4 1 1 300007d 300080 23000 22103 9704 > } 718045 856 801da584 1 1 3000046 300049 14000 13501 4332 > } 147278 457 801da694 3 1 2000044 200047 60000 51529 14233 > } 373603 270 801db464 1 1 20000be 2000c1 158000 148622 106233 } > 849860 1177 801dbbd4 1 1 2000045 200048 10000 9330 5108 > } 95128 486 801dc564 3 1 2000020 200023 62000 58584 35764 > } 754282 5 67 active, 2000 total, 512 hash buckets } > }