I want to reorganize(offline) some db2 tables. Also I want to executing runstats command after reorg command.
I have a question.
Do I need to stop db2 database or deactivate or both of them before executing reorg command?
Asked
Active
Viewed 276 times
1 Answers
0
No, the database must be available in order to connect to it and issue the REORG statement(s). For an offline reorg, you may to avoid having other applications connected as an offline reorg will lock the table.
Ian Bjorhovde
- 481
- 2
- 2