Absolutely! It means that on that date runstats were run and 0 rows were
found so CARD=0.
Go runstats.
Regards, Pierre.
Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515
----- Original Message -----
From: "pavan" <db2udbdba-ezmlmshield-x60010886.[Email address protected]
To: "LazyDBA Discussion" <[Email address protected]
Sent: Friday, October 27, 2006 11:25 AM
Subject: does this mean no updated stats ?


> Hello Gurus,
> does this mean we dont have updated stats on this table ?
>
> SELECT STATS_TIME, CARD FROM SYSCAT.TABLES WHERE TABNAME =
> 'T_POL_WRTN_PRMM_FACT' with ur;
>
> 2006-09-18 17:52:26.719471 0
>
> select count(*) from DWADMN.T_POL_WRTN_PRMM_FACT with ur;
> 5126334
>
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> To post a dba job: http://jobs.lazydba.com
> To Subscribe : http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>



DB2 & UDB email list listserv db2-l LazyDBA home page