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

Examples
• This command clears the contents of an existing file named history.txt in the local directory
(the same directory where you are running NCI) and saves the session history in the file:
SQL>savehist history.txt clear
SQL>
• This command saves the session history in a file named hist.txt in the specified directory on
a Windows workstation:
SQL>savehist c:\log_files\hist.txt
SQL>
• This command saves the session history in a file named hist.txt in the specified directory on
a Linux or UNIX workstation:
CS#savehist ./log_files/hist.txt
CS#
For more information, see “Displaying Executed Commands” (page 52).
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.
MAINTENANCE
The MAINTENANCE option allows you to modify the time at which the task needs to be
run by the scheduler on a daily basis. This option also allows you to specify the maximum
runtime limit and the maximum REORG slice.
AT time
is the time in hh:mm:ss, in 24-hour clock notation, where hh represents the hour, mm represents
minutes, and ss represents seconds at which the scheduler runs automated UPDATE
STATISTICS and REORG tasks on a daily basis. By default, the time is 00:00:00 (midnight).
MAXRUNTIME interval [MINUTES | MINS]
is an interval specified in minutes during which automated UPDATE STATISTICS and
REORG operations occur. By default, the interval is 360 minutes (or six hours).
MAXREORGSLICE {percentage}%
is a value from 0 to 100 expressed as a percentage of the interval time during which the
automated MAINTAIN (REORG) operation runs. If you do not specify MAXREORGSLICE,
the default percentage value for REORG is 50%.
SCHEDULE Command 107