EXECUTING
Short Description
The activity is executing.
Detailed Description​
The activity is executing. Usually this will be followed by a work type such as CALL, DDL, LOAD, OTHER, READ_DML, WRITE_DML which will indicate the type of work that is executing.
How to reduce this wait​
Depending on the work type you can decide what action to take.
- CALL
- DDL
- LOAD
- OTHER
- READ_DML
- WRITE_DML
For example if you see EXECUTING READ_DML with significant time against it then improving read speeds by query tuning, indexing or using faster storage will help.
Additional Links​
Db2 docs - Classes States Connections Activities in Service Class
Db2 docs - Work Identification by Type Cost Data Accessed Work Classes
Search online​
If this article doesn't have the information you need you can try searching online. Remember, you can contribute suggestions to this page.