This SQL will generate a set of RUNSTATS commands for the tables in your database that have no RUNSTATS values recorded. select ‘CALL SYSPROC.ADMIN_CMD(”RUNSTATS ON TABLE ‘|| trim(tabschema) || ‘.’ || tabname || ‘ ON ALL COLUMNS AND INDEXES ALL ALLOW READ ACCESS”);’ from syscat.tables where stats_time is null and tabschema not like ‘SYS%’ order …

Continue reading »

— — List DB2 base tables which don’t have Primary Keys — SELECT sit.TABLE_NAME, ‘No Primary Key’ FROM SYSIBM.TABLES sit LEFT OUTER JOIN SYSIBM.SYSCOLUMNS sic ON sic.TBNAME = sit.TABLE_NAME AND sic.KEYSEQ > 0 WHERE sit.TABLE_SCHEMA = ‘@MVPADM’ AND sit.TABLE_TYPE = ‘BASE TABLE’ AND sic.NAME IS NULL;