Following are known requirements that can 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. Teradata recommends that users of current software use typical TASM/TIWM workload classification 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 must not materially impact the performance of the request.
- Provide the detailed information necessary to effectively manage the system. The information is 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, remember the following:
- 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.