Skip to main content

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.

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.