List out wM services execution count

, ,
1

Hello,

we are planning to replace the external terracotta cache(BigMemory) with internal terracotta cache.
we are trying to find out most used cache service and need to do the POC on it’s associated flow. I fired the below query to list out the execution count for each service on WMSERVICE table.

select SERVICENAME,COUNT(*) as COUNT1 from WMSERVICE Group by SERVICENAME
ORDER BY COUNT1 DESC;

It’s gives the result only for the top level service. I want to see the execution count for each and every service. Can anyone have any idea?

Thanks in Advance!

Regards,
Amit Makwana

2

Amit,
WMSERVICE table will have run time audit entries only if the dependant service is executed recently. Also, this table will archive entries if you have archiving enabled.

If you want to know the list of ‘flow/java services’, that used ehcache apis (pub.cache:get, pub.cache:put), go to Designer, and find dependants of this service.

From file system, you can also Unix command (grep -R “pub.cache:”)

In these services, you can find the ‘Cache manager’ & ‘Cache’ name that was used. Your changes will be required only in the Cache manager from IS administration page which will redirect the data either to external cache or internal cache.

-Senthil