In this post, you’ll learn about the error message -666 stmt verb object cannot be executed because function is in progress in the IBM DB2 database , the reason why it occurs along with the solution to fix it
IBM DB2 Error Message
-666 stmt verb object cannot be executed because function is in progress
Reason for the Error
The SQL statement could not be executed because the named function was executing at the time.� In the message, ‘stmt verb’ is the type of data definition language (DDL) statement, ‘object’ is the DB2 object type, and ‘function’ is a utility, the governor, or the distributed data facility (DDF). If the object is part of the communications database, it cannot be dropped while the DDF is active
Solution
If the function is a utility, wait for the function to complete or stop and then resubmit the statement for execution.� If the function is the governor, the statement cannot be executed until the resource limit facility is stopped or switched to a different resource limit control table.� If the function is the DDF, the facility must be stopped before the object can be dropped.
