IDS Forum

Where records the fragment table's partnum ?!

Posted By: MARS CHEN
Date: Wednesday, 27 August 2008, at 11:57 p.m.

Dear All...

I have a non fragment table said table quote in nologtest DB ,
I do : oncheck -pt nologtest:systables and get the extents 2a684e ,
and then I oncheck -pP 2 0xa6852 , I see slot 15 is about quote ,
also I will see the partnum of nologtest:quote will showes in slot 15's
27 ~ 30 bytes .... so far so good !!!

and then , I create a fragment table like following :

create table "informix".stkhis
(

stkday date,

stkid char(6),

stkclose decimal(10,3),

stkpref decimal(10,3),

stklow decimal(10,3),

stkhigh decimal(10,3),

stkvol decimal(14,3),

stkvalue decimal(18,3)
)
fragment by expression

(stkid [1,1] <= '5' ) in dbspace1 ,

(stkid [1,1] >= '6' ) in dbspace2
extent size 160 next size 160 lock mode row;

create unique index "informix".stkhis_ix on "informix".stkhis

(stkid,stkday desc) in dbspace3 ;

and then , oncheck -pt nologtest:stkhis showes 3 part of partition :

Table fragment in DBspace dbspace1
Partition partnum 2097908(0x2002F4)

Table fragment in DBspace dbspace2
Partition partnum 3145730(0x300002)

Index stkhis_ix fragment in DBspace dbspace3
Partition partnum 4194306(0x400002)

and in oncheck -pP 2 0xa6853 slot 6 , I can not find any of these partnum
information :

slot 6:

0: 73 74 6b 68 69 73 20 20 20 20 20 20 20 20 20 20 stkhis

16: 20 20 69 6e 66 6f 72 6d 69 78 0 0 0 0 0 0 informix......

32: 0 79 0 3a 0 8 0 1 0 0 0 0 0 0 9b 7 .y.:............

48: 0 79 0 2 54 52 0 0 0 0 0 0 0 a0 0 0 .y..TR....... ..

64: 0 a0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 . ..............

80: 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 ................

96: 0 0 0 0 0 0 0 0 ................

My question is : in a fragment table , where record the partnum page address ?!

Thanks ~~

Messages In This Thread

• Where records the fragment table's partnum ?!
  MARS CHEN -- Wednesday, 27 August 2008, at 11:57 p.m.
  • Re: Where records the fragment table's partnum ?!
    MIKE MAGIE -- Thursday, 28 August 2008, at 9:24 a.m.
    • Re: Where records the fragment table's partnum ?!
      MARS CHEN -- Thursday, 28 August 2008, at 9:32 p.m.
      • Re: Where records the fragment table's partnum ?!
        John Miller iii -- Thursday, 28 August 2008, at 10:04 p.m.
        • Re: Where records the fragment table's partnum ?!
          MARS CHEN -- Thursday, 28 August 2008, at 11:01 p.m.
      • Re: Where records the fragment table's partnum ?!
        Art Kagel -- Thursday, 28 August 2008, at 11:10 p.m.
        • Re: Where records the fragment table's partnum ?!
          MIKE MAGIE -- Friday, 29 August 2008, at 1:51 p.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.