Make sure your runstats are up to date and query the syscat.tables and grab
the card count ...

-----Original Message-----
From: Thirumaran
[mailto:db2udbdba-ezmlmshield-x65533285.[Email address protected]
Sent: Monday, June 14, 2004 11:26 AM
To: LazyDBA Discussion
Subject: How do I produce a report of all tables in the database with
current number of rows ?


Hi,

How do I produce a report of all tables in the database with current number
of rows ?

regards

thiru




---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
For additional commands, e-mail: db2udbdba-[Email address protected]

*************************************************************
This message, including any attachments, may contain
confidential information intended for a specific individual
and purpose, and may be protected by law. If you are not
the intended recipient, please notify the sender by e-mail
or telephone immediately, and then immediately delete this
message. Any disclosure, copying or distribution of this
message, or the taking of any action based on it, by any
unintended recipient is strictly prohibited.

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