Optimizing JCR database performance

From time to time, it may be necessary to optimize the JCR database. Following is an example command that can be used against DB2. We have seen notable performance increases after optimizing the DB with this method in a site that leverages a lot of Personalization Rules and content from WCM.

In a production environment, you may consider having this command automatically run on a periodic basis. This can be done by updating the AUTO_REORG database configuration parameter to ON. This parameter is part of the automatic maintenance configuration parameter hierarchy.