Restrictions and Usage Rules - Advanced SQL Engine - Teradata Database

Database Administration

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
17.00
Published
June 2020
Language
English (United States)
Last Update
2021-01-22
dita:mapPath
rgu1556127906220.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1093
lifecycle
previous
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.