how many records contribute to a page.

[Sivaswami Jeganathan]

Hi

How to determine how many records contribute to a page in a table
( provided the structure of the table and pagesize ).

[spider007]

On Oct 29, 5:21 am, Sivaswami Jeganathan <sivaswamim...@gmail.com>
wrote:

> Hi
>
> How to determine how many records contribute to a page in a table
> ( provided the structure of the table and pagesize ).

You can look at avgrowsize in syscat.tables. That gives you average
row size and you have the page size. Now you can do the
mathematics :). That should give you approx number of rows/page. Of
course, it depends on lot of other things and this is just an
approximation.

[Frederik Engelen]

To be able to calculate this in advance, check the "CREATE TABLE"
statement in the Infocenter.

--
Frederik