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.

db2 connect to JCR51db2 reorgchk update statistics on table all db2 terminate

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.

There are currently no attachments on this page.

Labels:

db2 db2 Delete
jcr jcr Delete
Enter labels to add to this page:
Wait Image 
Tip: Looking for a label? Just start typing.