Restrictions and Usage Rules - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ - Database Administration

Teradata Database
Teradata Vantage NewSQL Engine
Release Number
March 2019
English (United States)
Last Update
Product Category
Teradata Vantage

Below are known requirements that could influence the standard formats of ASE:

  • Account strings cannot exceed 128 characters.
  • The character count includes separation characters, such as colons (:) in time fields and slashes (/) in dates. If a string consists of all the ASE variables, the result is 32 characters long. If an account string exceeds the character limit, characters to the right of the limit are truncated.
  • You can intersperse ASE variables with literals, subject to the constraints of length.
  • To the greatest extent that is appropriate, capture request-level usage detail. If DBQL is enabled, however, ASE becomes less important as a mechanism for enabling request-level usage detail because DBQL can capture usage for queries.

    Recommendation for account string setup: $W00MSIR&D&H, where:

    $W00 = Workload performance category. This optional classification is in effect only when TASM or TIWM classification processes cannot match the request to a user-defined workload.

    This default classification capability exists to be backward-compatible with older versions of software and to help users transition easily to SLES 11 Priority Scheduler. For users of current software it is recommended that normal TASM/TIWM workload classification be relied upon, rather than this default approach.
    Possible values include:
    • $R00: Timeshare Top
    • $H00: Timeshare High
    • $M00: Timeshare Medium
    • $L00: Timeshare Low

    MSI = Application identifier, such as FIN for Finance

    R= Workload identifier, such as R (Reporting), B (Batch), T (Tactical), or O (Online)

    &D&H = ASE Variables for date and hour

  • For requests requiring short response time, the account string setup should not materially impact the performance of the request.
  • Provide the detailed information necessary to effectively manage the system. When consistently adhered to, the proper information will be captured to facilitate a wide variety of analyses and produce a set of standard metrics by which to measure the system.
  • When combining ASE variables, keep the following in mind:
    • You can use multiple ASE variables in any order in the account string following the $W00 variable.
    • The account string limit is 128 characters.
    • If you specify &H or &T without &D, statistics collected on one day at one time are combined with statistics collected on other days at that same time.