Page 1 of 1

reorg and runstat

Posted: Thu Nov 07, 2019 9:44 pm
by Geeth
Hi Guru's
what should be the frequency of reorg and runstat for DB2 DB and advantage and disadvantage running them.

Thanks
Geeth

Re: reorg and runstat

Posted: Thu Nov 14, 2019 10:35 am
by Snowy
Hi,

if you use DB2 10.5 or 11.1, both versions are known for Reorg bugs

I would disable AUTO_REORG to avoid database corruption.

RUNSTATS are automatic by default within the DB. No need to play in DB13 jobs

so, set these DB params:
AUTO_RUNSTATS = ON
AUTO_REORG = OFF