DB2 REORG for Jazz DB
Hi !
I use Team Concert Enterprise Edition with DB2 Workgroup Server Edition 9.5. Number of users: 100 How often should we execute Reorg and Runstats? -When the performance became not good? -once a month? / week? I know it depends on the case. Could anyone show me the example of the other system and recommendation. |
2 answers
You can do when you notice or feel it became slow.
Please note you cannot reorg xxx_JAZZ_DEADLOCKS. https://jazz.net/jazz/web/projects/Rational%20Team%20Concert#action=com.ibm.team.workitem.viewWorkItem&id=86744 Regards, |
Although an older post, I bumped into this while searching for more info on the REORG command.
About the frequency of usage, it seems that this is more of a DB2 admin activity and not a JazzAdmin activity that we could prescribe the frequency on. However in my search I came across an issue with the REORG command that suggests the this command should be run more periodically than when just needed. See the Resolving this problem section of the technote: 1410155 . Comments Moreover, its a good to know info that the Reorg is to be run with the applications being shutdown, so the frequency could be easily decided by the Frequency with which you would be taking a backup of the databases, as that would would need a Application Shutdown.
|
Your answer
Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.