July 20 2010
How to check content of Informix TEMPSPACE when getting fill up?
Tagged Under : Informix, TEMP, TEMP TABLE, TEMPSPACE
Scenario:
TEMPSPACE “npts_tmpdbs3” is getting fill up.
We would like to check what is kept in this TEMPSPACE.
$ onstat -d | grep tmpdbs
8426c198 4 2001 4 1 N T informix npts_tmpdbs1
8426c258 5 2001 5 1 N T informix npts_tmpdbs2
8426c318 6 2001 6 1 N T informix npts_tmpdbs3
8426c3d8 7 2001 7 1 N T informix npts_tmpdbs4
83764f30 4 4 0 512000 509333 PO- /dev/infdev/npts_tmpdbs1.1
83765038 5 5 0 512000 312458 PO- /dev/infdev/npts_tmpdbs2.1
83765140 6 6 0 512000 9675 PO- /dev/infdev/npts_tmpdbs3.1
83765248 7 7 0 512000 509421 PO- /dev/infdev/npts_tmpdbs4.1
Steps:
(1) Get TBLspace partnum using DBspace number.