Abstract: The present disclosure relates to computer-implemented methods, software, and systems for controlling the execution of concurrent threads executing tasks in a database management system. A first task is executed at a first thread from a pool of threads for execution of tasks at the database management system. It can be identified that the execution of the first task is paused and that the first task is in a sleep mode. In response to identifying that the first task is in an awake mode after the sleep mode, it can be determined whether a current number of threads in the pool that are currently processing tasks in parallel is below an allowed number of threads. It can be determined that the allowed number of threads has been reached and a waiting status can be assigned to the first task at the first thread.

Abstract: The present disclosure relates to computer-implemented methods, software, and systems for controlling the execution of concurrent threads executing tasks in a database management system. A first task is executed at a first thread from a pool of threads for execution of tasks at the database management system. It can be identified that the execution of the first task is paused and that the first task is in a sleep mode. In response to identifying that the first task is in an awake mode after the sleep mode, it can be determined whether a current number of threads in the pool that are currently processing tasks in parallel is below an allowed number of threads. It can be determined that the allowed number of threads has been reached and a waiting status can be assigned to the first task at the first thread.

Abstract: The present disclosure relates to computer-implemented methods, software, and systems for flexibly managing limits for execution of jobs in parallel threads provided by a system. A request for the execution of a first statement at one or more threads associated with parallel processing at the system is received. A first snapshot object of an initial hierarchy of workload classes is obtained. The first snapshot object includes pointers to limiters defined for the workload classes and statements within the initial hierarchy. Each limiter defines an allowable number of threads for parallel execution of jobs. A modification to the hierarchy of workload classes is performed during runtime of the one or more jobs. A second snapshot object of a modified hierarchy of the workload classes. The execution of one or more created jobs is completed based on complying with limits as aggregately calculated for the first statement.