Neoview Database Administrator's Guide (R2.3)

SALES PARTS 0001-01-01 00:00:00 0
SALES ORDERS 0001-01-01 00:00:00 0
--- 2 row(s) selected.
For the syntax of the SELECT statement, see the Neoview SQL Reference Manual.
Stopping Automated UPDATE STATISTICS
HP_USTAT.STOP_AUTOMATED_STATS() Stored Procedure
The STOP_AUTOMATED_STATS() procedure immediately stops the currently running
maintenance window (or schedule) so that you can view and change the maintenance list (that
is, the list of tables for which statistics is automatically updated) and the maintenance window
for running UPDATE STATISTICS.
Syntax
HP_USTAT.STOP_AUTOMATED_STATS()
Considerations
• Use the CALL statement to execute the stored procedure, STOP_AUTOMATED_STATS().
For more information about CALL, see the Neoview SQL Reference Manual and the Neoview
Guide to Stored Procedures in Java.
• To call STOP_AUTOMATED_STATS(), log on to the master segment from NCI as ROLE.DBA
(or super.services or the super ID if you are HP support).
• In NCI, you can execute the CALL statement in SQL mode only.
• If you do not stop the maintenance window, automated UPDATE STATISTICS continues
until it has run UPDATE STATISTICS with the NECESSARY keyword against all tables in
the maintenance list one time.
Example
This CALL statement invokes the STOP_AUTOMATED_STATS() procedure, which stops the
currently running maintenance window:
SQL>call hp_ustat.stop_automated_stats();
--- SQL operation complete.
Scheduling Automated UPDATE STATISTICS and REORG
SCHEDULE Command
The SCHEDULE command enables you to display or modify the time during which the
MAINTENANCE tasks are run by the scheduler. The SCHEDULE command with the
MAINTENANCE task option is used by automated UPDATE STATISTICS to allocate the
maintenance time between the UPDATE STATISTICS and MAINTAIN (REORG) operations.
Syntax
SCHEDULE { LIST MAINTENANCE }
| { MAINTENANCE [AT time] MAXRUNTIME interval [MINUTES | MINS]
[ MAXREORGSLICE {percentage}% ] }
time is: hh:mm:ss
LIST MAINTENANCE
The LIST MAINTENANCE option displays information
about the MAINTENANCE tasks.
Stopping Automated UPDATE STATISTICS 107