reorg and runstat

[Geeth]

Hi Guru's
what should be the frequency of reorg and runstat for DB2 DB and advantage and disadvantage running them.

Thanks
Geeth

[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