AGGSQLTEMPSPACE threshold
The AGGSQLTEMPSPACE threshold specifies the maximum amount of system temporary table space that can be used in total across all concurrently running DML activities in a service subclass. DML activities often use temporary table space for operations such as sorting and the manipulation of intermediate result sets.
- Class
- Aggregate
- Definition domain
- Service subclass
- Enforcement scope
- Member
- Tracked work
- See the information later in this topic
- Queuing
- No
- Unit
- Kilobytes, megabytes, or gigabytes
- Predictive or reactive
- Reactive
Activities tracked by this threshold are as follows:
- DML activities that are issued at the coordinator member.
- Nested DML activities that are derived from user applications. However, DML activities that are issued by the data server, such as internal SQL statements, are unaffected by this threshold. IMPORT, EXPORT, and other CLP commands are considered to be user logic; therefore, activities that are invoked from within IMPORT, EXPORT, and other CLP commands are subject to thresholds.