reorg and runstat

Basis (Basis Technology Modules: Basis Component/System Administration, GUIs)

Moderators: Snowy, thx4allthefish

Post Reply
Geeth
Posts: 80
Joined: Sun Mar 14, 2010 8:10 pm

reorg and runstat

Post by Geeth » Thu Nov 07, 2019 9:44 pm

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

Thanks
Geeth

Snowy
Posts: 28797
Joined: Mon Oct 21, 2002 2:33 pm
Location: 3.1415926535

Re: reorg and runstat

Post by Snowy » Thu Nov 14, 2019 10:35 am

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

Post Reply