Neoview Command Interface (NCI) Guide (R2.5)

Considerations
• In the NCI interface, you must enter the SCHEDULE command on one line. The command
does not require an SQL terminator.
• In NCI, you can execute the command in all modes.
• Automated REORG operations are first performed on the list of tables specified for automated
UPDATE STATISTICS (by the CHG_AUTO_LIST() stored procedure) and then performed
on the rest of the database tables.
• Automated UPDATE STATISTICS does not start new UPDATE STATISTICS or REORG
operations beyond the maintenance window. However, some UPDATE STATISTICS and
REORG operations might run beyond the end of the window.
Examples
• This command alters the next run time for the MAINTENANCE task:
SQL>schedule MAINTENANCE at 19:14:15
Next run : 30NOV07 19:14:08
Max runtime : 214 minutes
State : Enabled
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.
108 NCI Commands