Hi Guru's
what should be the frequency of reorg and runstat for DB2 DB and advantage and disadvantage running them.
Thanks
Geeth
reorg and runstat
Moderators: Snowy, thx4allthefish
Re: reorg and runstat
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
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
SapFans Moderator
Search: search.php
Notes: http://service.sap.com/notes
Help: http://help.sap.com
Rules: viewtopic.php?t=344127
Search: search.php
Notes: http://service.sap.com/notes
Help: http://help.sap.com
Rules: viewtopic.php?t=344127