Reply from kamo00 on May 23 at 10:14 AM Yes, I did figure out the routing stuff but even though they are internal services but we haven't been using them since IB gateway and PUB/SUB are turned off. All of these services have status new in monitoring so obviously they don't get processed. So we are going to leave them turn off anyway.
In case if anyone interested in SQL that I used to see active services with same sender and receiver node:
select distinct a.servname from
(SELECT D.IB_SERVICENAME servname
, B.IB_OPERATIONNAME
, B.VERSIONNAME
, A.RTNGTYPE
, B.DESCR
, B.ACTIVE_FLAG
, C.PARAMETERNAME
, C.MSGNAME
, C.IB_MSGVERSION
FROM PSSERVICEOPR D
, PSOPERATION A
, PSOPRVERDFN B
, PSOPRVERDFNPARM C
WHERE D.IB_OPERATIONNAME = A.IB_OPERATIONNAME
AND A.IB_OPERATIONNAME = B.IB_OPERATIONNAME
AND A.DEFAULTVER = B.VERSIONNAME
AND B.IB_OPERATIONNAME = C.IB_OPERATIONNAME
AND B.IB_OPERATIONNAME in ( SELECT distinct G.IB_OPERATIONNAME
FROM PSIBRTNGDEFN G
where G.SENDERNODENAME = 'NODE_NAME'
and G.RECEIVERNODENAME = 'NODE_NAME')
AND B.VERSIONNAME = C.VERSIONNAME
and B.ACTIVE_FLAG='A'
order by 1,2) a
| | | ---------------Original Message---------------
From: PSDeveloper
Sent: Wednesday, May 23, 2012 10:05 AM
Subject: Peoplesoft Integration Broker in Production
You can query for getting the service operations which uses the routings with same sender and receiver nodes |
| Reply to this email to post your response. __.____._ |   _.____.__ |
No comments:
Post a Comment