July 20 2010

How to check content of Informix TEMPSPACE when getting fill up?

Tagged Under : , , ,

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.