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:tablename
Split 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