Deferred Upgrade Tasks batch process

Code	`DeferredUpgradeTasks`
Categories	`APIRunnable`
Implementation	Batch process
Stoppable	No (single phase process)
Class	DeferredUpgradeBatchProcess.java

The Deferred Upgrade Tasks batch process creates the nonessential performance indexes and indexes on archived entities.

PolicyCenter runs the Deferred Upgrade Tasks process automatically after an upgrade if you set the following attribute on <upgrade> in database-config.xml to true:

<upgrade defer-create-nonessential-indexes="true" ...

If the DeferredUpgradeTasks process fails, manually run the process again during non-peak hours. To manually run the Deferred Upgrade Tasks process, use the following command:

maintenance_tools -server url -password password -startprocess DeferredUpgradeTasks

Note: To run this command, you must have permission to create indexes until after the DeferredUpgradeTasks batch process completes.

To check the status of the DeferredUpgradeTasks batch process, review the upgrade logs and the PolicyCenter Server Tools Upgrade and Versions screen.

Production mode

Do not go into full production while the Deferred Upgrade Tasks process is still running. The lack of so many performance-related indexes can likely make PolicyCenter unusable.

Until the Deferred Upgrade Tasks process has run to completion, PolicyCenter reports errors during schema validation while starting. These include errors for column-based indexes existing in the data model but not in the physical database and mismatches between the data model and system tables.

Do not use the PolicyCenter archiving feature until the Deferred Upgrade Tasks batch process completes successfully.