how can split Physical Address into the chunk and page on IDS 10 ?
Posted in 2005
Hello,
how can I calculate maximum number of extents for a table?
The documentation told me :
Run the following oncheck option to obtain the physical address of the
object (table or index fragment) for which you wish to calculate extent
limits.
oncheck -pt databasename:tablenameSplit the physical address of the table or index fragment into the
chunk# (leading digits) and page# (last 5 digits), and then run oncheck
-pP chunk# page#, specifying the arguments as hexadecimal numbers by
prefixing with 0x.
In Figure 29, the Physical Address is 7002c7. Therefore, chunk# is
0x007 (or 0x07) and the page# is 0x0002c (or 0x2c) in the following
oncheck command:
oncheck -pP 0x7 0x2c
I am running $oncheck -pt bd_qbank_ghiseu:curs_valutar and get next
results:
TBLspace Report for bd_qbank_ghiseu:informix.curs_valutar
Physical Address 3:606
Creation date 08/29/2005 08:00:59
TBLspace Flags 801 Page Locking
TBLspace use 4 bit
bit-maps
Maximum row size 55
Physical Address : 3:606
How can split this address into the chunk and page ? It seems that
address is not on hexadecimal format ...
All Physical Address have the same format : 6:503130,6:503158...etc
thank you