(Ep. 20) – Db2 REORG
The Db2 REORG is a fundamental command and a best practice for regular maintenance. On smaller tables, the process can be quick and painless, but what about large tables, or tables that require 24×7 access? Then things get a little tricky.
In this episode we will discuss why you would call a reorg, the different kinds of reorgs, benefits and drawbacks, syntax, and monitoring the process.
Timestamps:
00:58 – Why are REORGs needed?
01:28 – Repercussions of not doing a regular REORG
02:26 – Advantages/Disadvantages of Offline Reorg
03:47 – Phases of an Offline Reorg
05:51 – Advantage/Disadvantage of Online Reorg
07:53 – Phases of an Online Reorg
09:38 – Command Syntax
– Minor Syntax Correction:
REORG TABLE TABLENAME [PAUSE | STOP]
11:00 – Monitoring Reorg Progress
13:56 – Aborted Reorg Recovery
Useful Links:
(KC) Compare/Contrast Types of Reorg – https://tinyurl.com/yadaoeue
(KC) Phases of Offline Reorg – https://tinyurl.com/ya9o8jyc
(KC) Phases of Online Reorg – https://tinyurl.com/yanpxn6s
(Technote) Aborted Reorg Recovery – https://tinyurl.com/y9pr7gjc
(Blog) Best Practices for Reorg/Runstats – https://tinyurl.com/ycnbvf5z
Comments are closed.