Hi.
One of our job, which is a DB2 RUNSTATS job, takes a long time to execute.
We have a huge partition table space (150GB) and the job needs 450 minutes to RUNSTATS on the entire table space.
RUNSTATS statements are like this:
RUNSTATS TABLESPACE DATABS.TPSAPST
TABLE(ALL) INDEX(ALL) SHRLEVEL ...
Search found 2 matches
- Mon Jan 25, 2016 2:42 pm
- Forum: IBM DB2 and IMS DB/DC
- Topic: Reducing the time of RUNSTAT job.
- Replies: 1
- Views: 1317
- Mon Jan 25, 2016 2:38 pm
- Forum: Suggestions & Feedback : About the website.
- Topic: Flags
- Replies: 34
- Views: 9263
Re: Flags
These Flags looks really great. Thanks for having them.