I want to remove old process instances which are not in use and build several times.
you will have to delete the old instances by using the archiving services in the WmMonitor-package.
See the Monitor Users Guide for details for how to setup archiving.
could you please tell me, what are the inputs required?
do I need to delete “PRA_PROCESS_ACTION” table data?
You don’t have manually navigate to specific tables and clean up (not recommended and not supported); the archiving jobs/services do this for you.
Setup - I assume that you’ve already installed the Archiving database objects; else, use the DB Configurator to install these on the Archive database first.
There may be a DB Link required, if your core and archiving databases are present on different DB servers. I’ve learnt that DB Link approach is no longer recommended.
Once the objects are available, you configure the Operation Parameters via this service (link). Then, you can execute processArchive, documented here (link).
These links explain the input fields, their usage and data types.
Guidelines - In your personal or non-Production setups, you may consider deleting (i.e., purging) the data, whereas for Production, you would typically archive the data for various purposes including. These guidelines/decisions are typically governed by your organizations’ Information Security policy.
Approaches - Archiving is performed by Stored Procedures that reside in your Archive database. However, you can perform archiving via various sources that ultimately invoke the Stored Procedures anyway, such as -
Concepts - You can read up about the concepts here (link). The documentation has a lot more information that will be useful.
Older Versions - The links above are all for 10.11, but you can look up older versions here (link). Search for webMethods Monitor. Note that there are differences in tables across versions - this is also documented.
I prefer having the main database user as well as the archiving database user on the same DB.
The archving user can then be replicated to a second database instance if needed.
In this case you will require some grants between the archiving user and main user which is documented in the appendix of the Monitor Users Guide.
We have scheduled some IS services for regular archiving/deleting every day with configured keep periods, but from time to time we run these services manually for certain process models.
Naming of the tables has been changed between wM 9.5 and wM 9.6, which is also documented in the Monitor Users Guide.