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.
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,
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 .
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 .
