Prev: Running db2updv95 in HADR environment
Next: Constraint problem
From: Sivaswami Jeganathan on 28 Oct 2009 20:21
Hi

How to determine how many records contribute to a page in a table
( provided the structure of the table and pagesize ).
From: spider007 on 29 Oct 2009 06:20
On Oct 29, 5:21 am, Sivaswami Jeganathan <sivaswamim...(a)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.
From: Frederik Engelen on 29 Oct 2009 08:03
On Oct 29, 11:20 am, spider007 <saurabh.saurabhj...(a)gmail.com> wrote:
> On Oct 29, 5:21 am, Sivaswami Jeganathan <sivaswamim...(a)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.

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

--
Frederik
 | 
Pages: 1
Prev: Running db2updv95 in HADR environment
Next: Constraint problem