15.00 - schmon -d - 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 -d

Purpose  

The schmon -d option displays the current Priority Scheduler settings in multi-line format.

Syntax  

Usage Notes  

The following table describes the Priority Scheduler settings.

 

Setting category

Description

Scheduler Times & Attributes

Displays scheduler times and attributes.

  • Age Time specifies the time period over which recent resource usage by a Scheduling Set is measured. The default is 60 seconds.
  • Active Time specifies the time period 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 default is 61 seconds.
  • Limit specifies the Teradata Database system CPU limit or None if not specified. System CPU limits are not enforced on PE-only nodes.
  • Resource Partitions

    Displays Resource Partition parameters.

  • ID specifies the identifier number of the Resource Partition.
  • Partition Name specifies the name of the Resource Partition.
  • Weight specifies the numeric value used to compute the relative weight of this Resource Partition.
  • Limit specifies a number between 1 and 100, inclusive, that specifies a percentage limit on the total CPU usage by sessions assigned to the Performance Groups associated with the Resource Partition or the string none to indicate no limit is present.
  • Performance Groups

    Displays Performance Group parameters.

  • ID specifies the Teradata Database system-wide, unique identifier of the Performance Group.
  • Group Name specifies the name of the Performance Group.
  • RP specifies the Resource Partition to which this Performance Group is to be assigned.
  • Type specifies the single character that specifies the type of units used in these Performance Period definitions:
  • The character Q indicates that milestone limits are seconds (1-86400) of query resource usage.
  • The character S indicates that milestone limits are seconds (1-86400) of session resource usage.
  • The character T indicates that milestone units are time-of-day, in military time (0 to 2359). You must define at least two periods.
  • Milestones & Allocation Groups specifies that each milestone defines a period milestone (in units defined by Type above), and that the corresponding Allocation Group defines the Allocation Group in effect during that period.
  • If you are defining only one Performance Period for the Performance Group, use S or Q as the default milestone type and 0 (zero) as the default milestone limit.

    Allocation Groups

    Displays Allocation Group parameters.

  • ID specifies the Teradata Database system-wide, unique identifier of the Allocation Group.
  • X specifies that an Allocation Group has the Expedite attribute.
  • Wght specifies a numeric value used to compute the relative weight of the Allocation Group.
  • Lim specifies a percentage limit on total CPU usage by all tasks controlled by this Resource Partition or the character string none.
  • The value ranges from 1 through 100.

  • A value of 100 indicates that no limit is to be enforced.
  • The character string none indicates that no limit is to be enforced.
  • If Lim is not present, any previously defined limit is removed.

    Example  

    The following example shows the current Priority Scheduler settings in multi-line format.

    > schmon -d
          Scheduler Times & Attributes
     Age Time(sec):    60   Active Time(sec):   61
     Limit(%):       none 
                            Resource Partitions (0 - 4)
    Id  Partition Name    Weight  Limit
     0  Default             100    none
                            Performance Groups (0 - 249)
    Id Group Name   RP Type  Milestones & Allocation Groups[0-7]
     0 L            0  S          0.00   1
     1 M            0  S          0.00   2
     2 H            0  S          0.00   3
     3 R            0  S          0.00   4
                            Allocation Groups (0 - 199)
    Id Type Wght  Lim  Id Type Wght  Lim  Id Type Wght  Lim  Id Type Wght  Lim
     1  N      5 none   2  N     10 none   3  N     20 none   4  N     40 none
                            AWT Expedited work type limits
    res   max
       0   999