(Ep. 20) - Db2 REORG

preview_player
Показать описание
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 24x7 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:
  1. DISCOVER.DB2
  2. db2 reorg
  3. db2 reorg table example
  4. db2 reorg reclaim space
  5. db2 tutorial
  6. db2 luw administration
Рекомендации по теме
(Ep. 20) - 0:15:32

(Ep. 20) - Db2 REORG

SQL : What 0:01:31

SQL : What is the use of reorg command in IBM DB2?

(Ep. 21) - 0:16:34

(Ep. 21) - Db2 REDUCE MAX Command

DB2 Tips n 0:02:44

DB2 Tips n Tricks Part 82 - How To Find Recent Reorganization date-time of a Table

Databases: DB2: Reorg 0:01:34

Databases: DB2: Reorg and RunStats

Databases: DB2 Reorg-recommended 0:01:59

Databases: DB2 Reorg-recommended commands (2 Solutions!!)

db2 reorgchk shows 0:02:10

db2 reorgchk shows reorg needed immediately after reorg/runstats

DB2 Tips n 0:04:48

DB2 Tips n Tricks Part 78 - How Classic Offline Reorganization consumes more Transactional Log Space

Db2 for zOS 0:59:25

Db2 for zOS REORG utility - Past, Present, and Future

Databases: Do I 0:02:28

Databases: Do I need to RUNSTATS after a REORG in DB2? (2 Solutions!!)

Databases: db2 tables 0:01:17

Databases: db2 tables altered, reorg

DB2 LUW Limit 0:12:00

DB2 LUW Limit CPU using WLM

DB2 Tips n 0:08:07

DB2 Tips n Tricks Part 50 - How to Monitor Index Reorganization

DB2 Tips n 0:09:03

DB2 Tips n Tricks Part 75 - How To Reorganize Index without using REORG Command

Databases: Why doesn't 0:03:03

Databases: Why doesn't DELETE + REORG free diskspace (DB2)? (2 Solutions!!)

Db2 LUW Offline 0:20:34

Db2 LUW Offline Tablespace Backup & Restore

RUNSTATS vs REORG 0:01:34

RUNSTATS vs REORG

(Ep. 19) - 0:02:59

(Ep. 19) - Db2 Authentication and Authorities

(Ep. 00) - 0:02:07

(Ep. 00) - All About DISCOVER.DB2

Db2 DPF 01 0:16:41

Db2 DPF 01 Add Node db2start DBPARTITIONNUM ADD

DB Reorg Part 0:07:31

DB Reorg Part 1

BMC Next Generation 0:10:57

BMC Next Generation Technology Utility Manager for DB2 for z/OS 12.1 - Utility Manager automation

CATALOG MANAGER for 0:15:21

CATALOG MANAGER for DB2 - Reorg improvements

Db2 LUW Compression 0:40:28

Db2 LUW Compression

Комментарии
Автор

Thank you... it was a very well explained video...
After Online reorg do we need to run reorg index command every-time... ?**

yashtiwari
Автор

Hello Sir,
Very usefull information about reorg.

I have one question : During offline reorg system get down or get crashed what happen will we able to access table ? Or we have to restore from tempspace1 (mostly this will not happend but senario asking in interview question)

shubhamshahane
Автор

Hey Nice explanatory video on reorg, i had one doubt, what if i accidentally perform an offline reorg in Prod environment during working hours, and what if i abort it in between without waiting for it to complete... Will database crash in such scenario?? if yes how do i get back the database running in Prod.

monishpatil
Автор

Many thanks! Very few channels for DB2 are also in good English)
P.S.
Do you answer questions on the channel?

MrVieV
Автор

Good info.Please clarify me at what phase we can interrupt online/offline reorg without impacting to table and db

hanurao
Автор

Good Explanation .. Thank you very much ..

kalpanamanoj
Автор

Awesome content... good explanation... recommended for professionals

myunderstanding