The IN_DB_UPGRADE_SP_UPTIME_STEPS procedure faciltates the execution of schema upgrade steps that qualify for execution in uptime. The steps that are executed depends on the starting schema version and the specified target schema version.
You can schedule or manually execute the IN_DB_UPGRADE_SP_UPTIME_STEPS procedure to incrementally execute the uptime steps at any point after upgrade setup and prior to the execution of the downtime steps.
The following schema upgrades currently include qualifying uptime steps:
IN_DB_UPGRADE_SP_SCHEMA_UPGRADE_7220_7230
- Creation of the PHSOB_IDX10 index on the IN_PHSOB table
IN_DB_UPGRADE_SP_SCHEMA_UPGRADE_7230_7403
- Creation of the filtered indexes on the IN_INSTANCE_PROP table
IN_DB_UPGRADE_SP_SCHEMA_UPGRADE_7403_7500
- Rebuild of the IN_DOC table and its indexes
IN_DB_UPGRADE_SP_SCHEMA_UPGRADE_7700_7900
- Increase MESSAGE_SEQUENCE cache to 2000
- Drop deprecated index DOC_IDX7
- Drop deprecated index PHSOB_IDX02
- Drop deprecated index PHSOB_CACHE_IDX04
- Create new index ACTION_GROUP_IDX_01
- Create new index AUDIT_IDX_01
- Create new index SC_CONNECTION_IDX03
- Create new index SC_SESSION_IDX04
- Create new index WF_QUEUE_IDX_07
- Create new index WF_QUEUE_IDX_08
If you choose not to execute any steps in uptime, you can skip this step and go directly to the IN_DB_UPGRADE_SP_DOWNTIME_STEPS procedure. Doing so does not eliminate any steps since the DOWNTIME_STEPS procedure will call the UPTIME_STEPS procedure to ensure all qualifying steps are completed.
In SSMS or at the command prompt (sqlcmd), execute the following procedure.
EXEC inuser.IN_DB_UPGRADE_SP_UPTIME_STEPS;
The following parameters are available to use.
- @MAX_MINUTES
- @MAX_DOP
- @FILLFACTOR