15.00 - Chapter 18 Priority Scheduler (schmon)(SLES 10 only) - Teradata Database

Teradata Database Utilities

Teradata Database
Release Number
Content Type
Publication ID
English (United States)
Last Update

Priority Scheduler is a workload-management facility that controls access to system resources by the different active jobs in Teradata Database. It allows administrators to define different priorities for different categories of work, and comes with a number of flexible options.

Note: The information in this chapter applies only to Teradata Database systems running on SUSE Linux Enterprise Server (SLES) 10. On SLES 11 systems, Priority Scheduler is managed by Teradata Active System Management (TASM), and is configured and monitored using the Teradata Viewpoint workload management portlets. For more information on those portlets, see Teradata Viewpoint User Guide.

Priority Scheduler does the following:

  • Allows you to define a prioritized weighting system based on user logon characteristics, and on Workload Definition (Category 3) rules set in the Teradata Viewpoint Workload Designer portlet.
  • Prioritizes the workload in your data warehouse based on this weighting system.
  • Offers utilities to define scheduling parameters and to monitor your current system activity.
  • Priority Scheduler includes default parameters that provide four priority levels with all users assigned to one level. To take advantage of Priority Scheduler capabilities, do the following:

  • Assign users to more than one of the default priority levels based on your work priority strategy.
  • Define additional priority levels and assign users to them to provide a more sophisticated priority strategy.
  • Assign very high priority users to a very high priority level to support Active Data Warehouse applications.
  • The first part of this chapter generally describes the structure and relationships of the scheduling components and parameters. The second part describes schmon, a command-line interface to Priority Scheduler. For detailed information, see “Schmon Utility (schmon) (SLES 10 only)” on page 725.

    Note: If Workload Definitions have been set in the Teradata Viewpoint Workload Designer portlet, schmon cannot be used to make changes to Priority Scheduler.