In this post, you’ll learn about the error message -619 operation disallowed because the workfile database is not stopped in the IBM DB2 database , the reason why it occurs along with the solution to fix it
IBM DB2 Error Message
-619 operation disallowed because the workfile database is not stopped
Reason for the Error
The statements CREATE, ALTER or DROP for a table space in the workfile database (DSNDB07) cannot be processed unless the workfile database is stopped (use the STOP statement).
Solution
Issue the� DISPLAY DATABASE(DSNDB07) command to verify that the workfile database is stopped before resubmitting the statement.