17.10 - DEFAULT PRIORITY - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Database Utilities

Advanced SQL Engine
Teradata Database
Release Number
Release Date
July 2021
Content Type
Publication ID
English (United States)

The DEFAULT PRIORITY command sets the priorities to the default values (that is, REBUILD will be set to MEDIUM and RECOVERY to LOW).



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 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.