Purpose
The DEFAULT PRIORITY command sets the priorities to the default values (that is, REBUILD will be set to MEDIUM and RECOVERY to LOW).
Syntax
DEFAULT PRIORITY ;
Usage Notes
If the PRIORITY command has never been executed, or a system initialization (sysinit) has been performed on the system, the priorities are set to the default values. The priority remains the same until an initial or subsequent PRIORITY command changes it again. When the priority command is entered during a rebuild or recovery operation, several minutes may elapse before the new priorities take effect.
When you type the DEFAULT PRIORITY command, the event is logged in the /var/adm/streams/error.mm-dd file in the Teradata Database system you are working on, and the following messages are displayed.
YY/MM/DD HH:MM:SS RECOVERY priority changed to LOW; it was <old priority> YY/MM/DD HH:MM:SS REBUILD priority changed to MEDIUM; it was <old priority>
When the default priority command is entered, both messages are generated.