15.00 - schmon -t - Teradata Database

Teradata Database Utilities

Product
Teradata Database
Release Number
15.00
Content Type
Configuration
Publication ID
B035-1102-015K
Language
English (United States)
Last Update
2018-09-25

schmon -t

Purpose  

The schmon -t option sets or displays Age Time, Active Time, and Dispatch Wait Time.

Syntax  

 

Syntax element

Description

 

-t

Sets or displays Age Time, Active Time, and Dispatch Wait Time.

If no additional options are specified, schmon -t displays the current settings. If any options are specified, all three options must be specified, regardless of operating system.

age

Age Time. The time period, in seconds, over which recent Allocation Group resource usage is measured.

The range is 1 to 60 seconds. The default is 60 seconds.

active

Active Time. The time period, in seconds, during which an Allocation Group is considered active if any task assigned to the Allocation Group has been scheduled. Inactive Allocation Groups are not included in resource consumption calculations.

The range is 1 to 1800 seconds. The default is 61 seconds.

disp

Note: This option is meaningful only on Linux. The Dispatcher Wait Timer is also known as the anti-starvation mechanism.

Dispatch Wait Time. The maximum period of time, in seconds, that a task can wait in a ready-for-execution state in a dispatch queue without receiving access to a CPU. After this time, the task priority is increased and its wait period is re-initialized.

The range is -1 through 127. The default is 4 seconds.

The following values apply:

  • 0 specifies that the Dispatch Wait Time be set to the factory default of four seconds.
  • -1 specifies that the Dispatch Wait Timer be disabled.
  • Note: The Dispatch Wait Timer is enabled by default.

    Caution:

    Teradata recommends that you do not use this setting unless absolutely necessary.

  • 1 -127 specifies a wait period in seconds.
  • Example  

    To view the current settings, type:

    schmon -t

    The following appears:

    Age Time(sec):   60  Active Time(sec):   61  Disp Age(sec):   5

    To change the settings, type:

    schmon -t 30 31 5

    The following appears:

     Age Time(sec):   60  Active Time(sec):   61  Disp Age(sec):   0
    >>>>> Changed to:
     Age Time(sec):   30  Active Time(sec):   31  Disp Age(sec):   5