Neoview Database Administrator's Guide (R2.4)

Days : ALL DAYS
Last altered at : 30NOV07 14:25:47
--- NS operation complete.
• This command alters the time and the runtime limit for the MAINTENANCE task:
SQL>schedule maintenance at 22:22:21 maxruntime 214
Next run : 30NOV07 18:23:00
Max runtime : 214 minutes
State : Enabled
Days : ALL DAYS
Last altered at : 30NOV07 14:24:21
--- NS operation complete.
• This command uses the default percentage of 50% to run the MAINTAIN (REORG) operation.
The remaining time is used by the UPDATE STATISTICS operation, which is limited to a
maximum run time of 120 minutes.
SQL>schedule maintenance maxruntime 120
Next run : 18DEC07 19:14:00
Max runtime : 120 minutes
State : Enabled
Days : ALL DAYS
Last altered at : 18DEC07 16:37:54
--- NS operation complete.
• This command uses the REORG percentage of 5% to run the MAINTAIN (REORG) operation.
The remaining time is used by the UPDATE STATISTICS operation:
SQL>schedule maintenance maxruntime 120 maxreorgslice 5%
Next run : 18DEC07 19:14:00
Max runtime : 120 minutes
State : Enabled
Days : ALL DAYS
Last altered at : 18DEC07 16:37:54
--- NS operation complete.
Scheduling Automated UPDATE STATISTICS and REORG 111