Reorg DB2 catalog

Lynette Roberts

Reorg DB2 catalog

January 1, 2000 08:41 AM

The "DB2 for OS/390 V5 Utility Guide and Reference" specifically
talks about
how reorgs on the system catalog are performed. We only had a few
gotcha's
when implementing this:
1. almost nothing else can be running in DB2 while the reorg was
going.
2. a "repair set nocopypend" will not work on the system catalog --
you
have to take an imagecopy to reset a copy pending flag
3. when doing the imagecopy after the reorg, SYSCOPY has to be
copied
first, followed by everthing else, followed by a backup of SYSCOPY
once
again (since SYSCOPY is updated during the copy process)

Other than these minor things, it was pretty painless to get this
going.