hi,everyone

OSName: SunOS
NodeName: domain5
Version: Generic_117000-03
Release: 5.8
Machine: sun4u

Instance db2inst1 uses 32 bits and DB2 code release SQL08020
with level identifier 03010106
Informational tokens are DB2 v8.1.0.72, s040914, U498351, FixPak 7.

bash-2.03$ df -k
Filesystem kbytes used avail capacity Mounted on
/dev/md/dsk/d3 26223047 23025026 2935791 89% /
/proc 0 0 0 0% /proc
fd 0 0 0 0% /dev/fd
mnttab 0 0 0 0% /etc/mnttab
swap 10439280 24 10439256 1% /var/run
swap 12892488 2453232 10439256 20% /tmp
/dev/md/dsk/d6 44183490 40661432 3080224 93% /data1

From above ,we can see there is about 3G space left .however once in a while ,when running ,the system temporary tablespace will fill all the left disk space and overflow , no connection will permitted.


i want to know how can i monitor system termporary tablespace occupying disk space all the time?