Steps:
(1) Get TBLspace partnum using DBspace number.
$ onstat –t
Tblspaces
n address flgs ucnt tblnum physaddr npages nused npdata nrows nextns resident
224 842cc990 0 1 500001 500004 50 50 0 0 1 0
225 84731fb8 800 1 500002 500005 304 293 292 42006 25 0
226 84732f98 800 1 500003 500006 525 499 0 0 25 0
230 842ccce8 0 1 600001 600004 50 50 0 0 1 0
231 845b8438 800 1 600003 600006 112 0 0 0 1 0
232 84628018 800 1 600016 600019 502272 0 0 0 112 0
233 842cd040 0 1 700001 700004 50 50 0 0 1 0
234 84731da8 800 1 700002 700005 296 293 292 42007 25 0
Note: tblnum 600016 is chosen which consume higher npages value.
(2) Dump the page content using “oncheck –pp” with TBLspace partnum.
TBLspace partnum = 0x600016
TBLspace TBLspace = 0x600001
Logical page number = 0x16
$ oncheck -pp 0x600001 0x16
addr stamp nslots flag type frptr frcnt next prev
600019 852031798 5 2 PARTN 1064 960 0 0
slot ptr len flg
1 24 56 0
2 80 80 0
3 160 0 0
4 160 0 0
5 160 904 0
slot 1:
0: 0 60 0 16 48 a0 0 0 0 20 0 0 0 0 0 70 .`..H … …..p
16: 4c 44 bf 6e 0 0 0 1 0 0 0 20 0 0 10 0 LD?n……. ….
32: 0 7 aa 0 0 0 0 0 0 0 0 0 ff ff ff ff ..*………….
48: 0 60 0 16 0 0 0 0 .`…………..
slot 2:
0: 42 45 46 49 4d 41 47 45 0 6e 16 78 0 0 44 98 BEFIMAGE.n.x..D.
16: 84 26 d4 69 6e 66 6f 72 6d 69 78 0 74 68 5f 73 .&Tinformix.th_s
32: 69 73 5f 67 65 6e 69 64 78 31 5f 31 0 0 0 0 is_genidx1_1….
48: 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 …………….
64: 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 …………….
Note: From the page dump slot 2, we found that npts_tmpdbs3 consists of huge content of backup Before Image “BEFIMAGE” for DBspace sis_genidx1.