Symptoms

Stop 9000 workflow instances in K2 database
 

Diagnoses

This can be accomplish via the database for relevant process instances (but is usually not recommended as the same can also be done so via the K2 Management API or via K2 Workspace).  I
 

Resolution

If you need assistance with this aspect, please contact K2 support regarding how to perform this action.

If you wish to use a different method to batch/mass delete process instances that had been previously stopped (instead of using K2 Workspace) we recommend perhaps using the 'SourceCode.Workflow.Management' API to iterate through and delete these process instances and its reporting/logging entries as per:

http://help.k2.com/onlinehelp/k2blackpearl/DevRef/4.6.11/default.htm_../Subsystems/RuntimeAPI/Content/topic12897.html?Highlight=DeleteProcessInstances

Perhaps this Community project can also serve as a starting point:

http://community.k2.com/t5/K2-blackpearl/K2-administrators-console-app-tool/ba-p/897

Please note that these projects were not developed by K2 and as such is not supported. Please thoroughly test before implementation in a Production environment.