Some common targets of throttles include the following types of work:
- Low-priority requests
- Requests that consume many resources
- Sandbox applications
- Full-table scans of medium-sized or large tables
Examples of throttles include the following TASM actions:
- Limit a specific user (source classification) to having no more than 10 sessions at a time (request session limit).
- Limit the number of application X sessions (source classification) simultaneously executing against a table (target classification).
- Allow no more than 3 concurrent data mining requests (source classification) because data mining uses significant resources and is not a high priority.
- Limit requests based on characteristics, for example, statement type, step row count, or join properties.
- Limit the number of requests that can run during end-of-the-month processing (Limits by State).