Find and Audit Active Service Operations
By Chris Malek | Thu, Sep 5, 2013
It is a good idea to periodically monitor what service operations are active in your production database.
Here is a base query that should return active Service operations that are routed to an active local node.
- Make sure the values returned here are only service operations that you are actually using.
- You should inactivate routings and service operations that you are not using.
- This will ensure you do not have data being posted to the integration broker and updating or extracting data.
- This should be checked after applying bundles and patches
-- Find All Active Service Operations and routings
select O.IB_OPERATIONNAME,
RD.SENDERNODENAME,RD.RECEIVERNODENAME, o.descr
from PSOPERATION o, PSOPRVERDFN OV, PSIBRTNGDEFN RD, PSMSGNODEDEFN MN
where O.IB_OPERATIONNAME = OV.IB_OPERATIONNAME
AND OV.ACTIVE_FLAG = 'A'
AND RD.IB_OPERATIONNAME = OV.IB_OPERATIONNAME
AND RD.VERSIONNAME = OV.VERSIONNAME
AND RD.EFF_STATUS = 'A' -- ROUTING IS ACTIVE
AND RD.RECEIVERNODENAME = mn.msgnodename
AND mn.active_node = 1
AND mn.localnode = 1
ORder by O.ib_operationname, RD.SENDERNODENAME;
Article Categories
Author Info
Chris Malek
Chris Malek is a PeopleTools® Technical Consultant with two decades of experience working on PeopleSoft enterprise software projects. He is available for consulting engagements.
About Chris Work with ChrisProduct
PeopleSoft Simple Web Services (SWS)
Do you need a quick way to create web services?
Introducing a small but powerful PeopleSoft bolt-on that makes web services very easy. If you have a SQL statement, you can turn that into a web service in PeopleSoft in a few minutes.
Book
Integration Broker - The Missing Manual
I am in the process of writing a book called "Integration Broker - The Missing Manual" that you can read online.