Runstats & data in sysibm.syscoldist

Patrick Steurs

Runstats & data in sysibm.syscoldist
Hi,



We use Db2 v7 on z/Os 1.4



Concerning : RUNSTATS

We use the runstats-clause "STATISTICS TABLE (ALL) INDEX (ALL)" in our
reorg-procedures.



We don't get statistical data in SYSIBM.SYSCOLDIST for

1) tables which are empty ( cardf = 0 )

2) indexes having firstkeycardinality = fullkeycardinality



Question :

Is this correct ?

greetings,

Patrick Steurs

DBA at National Bank of Belgium
Nbb - Sydsdb
Tel : 02/2215384




---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Terry Purcell

Re: Runstats & data in sysibm.syscoldist
(in response to Patrick Steurs)
Patrick,

By default you will receive the top 10 most frequently occuring values in
SYSCOLDIST for the leading index column (TYPE='F'), except for single
column unique indexes.

So what you are seeing is correct for empty tables, but you should see data
in there if FIRSTKEYCARDF = FULLKEYCARDF & FIRSTKEYCARDF <> CARDF (but if
FIRSTKEYCARDF = FULLKEYCARDF = CARDF then you wont see data).

As an aside, you should specify KEYCARD for > 2 column indexes, and then
you will also see TYPE='C' data in SYSCOLDIST.

Regards
Terry Purcell

On Wed, 5 Jan 2005 15:04:58 +0100, Steurs Patrick <[login to unmask email]>
wrote:

>Hi,
>
>
>
>We use Db2 v7 on z/Os 1.4
>
>
>
>Concerning : RUNSTATS
>
>We use the runstats-clause "STATISTICS TABLE (ALL) INDEX (ALL)" in our
>reorg-procedures.
>
>
>
>We don't get statistical data in SYSIBM.SYSCOLDIST for
>
>1) tables which are empty ( cardf = 0 )
>
>2) indexes having firstkeycardinality = fullkeycardinality
>
>
>
>Question :
>
>Is this correct ?
>
>greetings,
>
>Patrick Steurs
>
>DBA at National Bank of Belgium
>Nbb - Sydsdb
>Tel : 02/2215384
>
>
>
>
>---------------------------------------------------------------------------
------
>Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and
home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page
select "Join or Leave the list". The IDUG DB2-L FAQ is at
http://www.idugdb2-l.org. The IDUG List Admins can be reached at DB2-L-
[login to unmask email] Find out the latest on IDUG conferences at
http://conferences.idug.org/index.cfm
>

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm