Scheduling the SYSPROC.SYSTS_UPDATE stored procedure

You can use the Db2 administrative task scheduler to call the SYSPROC.SYSTS_UPDATE stored procedure according to a specific schedule.

To call the SYSPROC.SYSTS_UPDATE stored procedure according to a specific schedule:

1. Set the UPDATE FREQUENCY option in the SYSPROC.SYSTS_CREATE stored procedure.
2. To schedule the automatic index update task, call the SYSPROC.ADMIN_TASK_ADD stored procedure.
3. Provide the UPDATEFREQUENCY value from the SYSIBMTS.SYSTEXTINDEXES table directly as input parameter point-in-time.
4. Provide the string SYSTS_UPDATE as input parameter procedure-name.
5. Provide the parameters to the SYSPROC.SYSTS_UPDATE stored procedure as input parameter procedure-input.