Obviously, the doc is a little behind. Instead of being in hex format, you are now seeing output in chunk#age#. Just plug those values into oncheck:
oncheck -pP 3 606

There used to be a formula in the Performance Guide to calculate maximum extents based on page size and column types. We even had spreadsheets for our tables, because this was an issue for our customers. According to Informix Support, it is no longer possible to calculate the maximum number of extents for a table in IDS 9.4 and following. You have to look at the oncheck output.

Sincerely,

Christopher Coleman

Steering Committee President
Kansas City Informix Users Group
www.iiug.org/kciug

Database Analyst
Pharmacy Division
Mediware Information Systems, Inc.
913/307-1073


-----Original Message-----
From: cristizaharioiu [mailto:cristizaharioiu@gmail.com]
Sent: Wednesday, August 31, 2005 8:15 AM
To: informix-list@iiug.org
Subject: how can split Physical Address into the chunk and page on IDS
10 ?


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
sending to informix-list