It means that either the table was empty, or there was an error the last
time you ran stats. You need to run runstats again.

David Baker
UDB World Site Admin
www.udbworld.com
[Email address protected]

-----Original Message-----
From: pavan [mailto:db2udbdba-ezmlmshield-x60010886.[Email address protected]

Sent: Friday, October 27, 2006 11:26 AM
To: LazyDBA Discussion
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