Code Place

Runstats information for range-partitioned tables & their indexes and statistical views 

Oct 28, 2011 05:45 AM

Script enclosed to aid in reporting on runstats information for range-partitioned tables & their indexes and statistical views. 

Attachment(s)
txt file
db2-script-for-runstats-on-range-partitioned-tables-index...txt   2 KB   1 version
Uploaded - Jun 05, 2020

Comments

Nov 01, 2011 12:09 AM

stat_time

dear,  I have checked SELECT TABSCHEMA, TABNAME
    FROM SYSCAT.DATAPARTITIONS
    WHERE STATS_TIME IS NULL
    ORDER BY 1, 2
    WITH UR; ,   SYSCAT.DATAPARTITIONS dont have a could named STATS_TIME   :) , could you send me a mail and give me some explian. 

Related Entries and Links

No Related Resource entered.