Rows in a DB2 table..

[busywidoutwork]

Hi all ,

I am planning to run a runstats on a DB2 database (mainframe). since Runstats takes very long time to be completed on a empty table, i am planning to prepare a list before starting the Runstat.

Is there any way through which i can know that which tables are empty in the DATABASE ??

I looked into sysibm.systable s but it shows the column count rather than the row count.

Please help me out.

Thanks

[yrayanki]

db2 "select substr(name,1,4 5) table_name,card record_count from sysibm.systable s where creator = 'yourtableschem a' and type = 'T' "


C:\Documents and Settings\Admini strator>db2 "select substr(name,1,4 5) table_name
,card record_count from sysibm.systable s where creator = 'ADMINISTRATOR' and typ
e = 'T' "

TABLE_NAME RECORD_COUNT
--------------------------------------------- --------------------
ACT -1
ADVISE_INDEX 0
ADVISE_INSTANCE 0
ADVISE_MQT 0
ADVISE_PARTITIO N 0
ADVISE_TABLE 0
ADVISE_WORKLOAD 0
CDEMPLOYEE -1
CL_SCHED -1
CONNHEADER_MYSE LECT -1
CONTROL_MYSELEC T -1
DEPARTMENT -1
DFP -1
EMP_PHOTO -1
EMP_RESUME -1
EMPLOYEE 42
EMPMDC 10000
EMPPROJACT -1
EXPLAIN_ARGUMEN T 8
EXPLAIN_DIAGNOS TIC 3
EXPLAIN_DIAGNOS TIC_DATA 6
EXPLAIN_INSTANC E 1
EXPLAIN_OBJECT 3
EXPLAIN_OPERATO R 2
EXPLAIN_PREDICA TE 0
EXPLAIN_STATEME NT 2
EXPLAIN_STREAM 2
IN_TRAY -1
ORG -1
PROJACT -1
PROJECT -1
SALES -1
SAMPLE -1
STAFF 72
STAFF1 -1
STAFF2 -1
STMT_MYSELECT -1
SVT -1