craig Site Admin
Joined: 19 Feb 2006 Posts: 40
|
Posted: Wed Aug 02, 2006 7:17 am Post subject: select table statistics |
|
|
select * from (select RTRIM(TABSCHEMA) TABSCHEMA, RTRIM(TABNAME) TABNAME, TYPE, RTRIM(TBSPACE) TBSPACE, case STATUS when 'N' then 'No' when 'C' then 'Yes' end STATUS, CARD, NPAGES, COLCOUNT, ROWTYPESCHEMA, ROWTYPENAME, RTRIM(property) PROPERTY, CHAR(DATE(CREATE_TIME), ISO) CONCAT ' ' CONCAT CHAR(TIME(CREATE_TIME), ISO) CREATE_DATETIME, CHAR(DATE(STATS_TIME), ISO) CONCAT ' ' CONCAT CHAR(TIME(STATS_TIME), ISO) STATS_DATETIME from SYSCAT.TABLES order by TABSCHEMA, TABNAME) TABLES where TYPE in ('S', 'T', 'H', 'U') for read only |
|