Integration Broker

 

 PeopleTools> Integration Broker> Integration Setup> Service Operations

Menu:	IB_PROFILE
Component:	IB_SERVICE
Page:	IB_SERVICE   Record:PSOPRVERDFN

Which ones are active?

select * from PSIBRTNGDEFN_VW where  EFF_STATUS = 'A';

select * from PSOPRVERDFN where ACTIVE_FLAG = 'A';  -- this is parent of above

select * from PSSERVICEOPR_VW where ACTIVE_FLAG= 'A' and IB_OPERATIONNAME like '%SYNC%' and RTNGTYPE; -- synch and asynch

 PeopleTools> Integration Broker> Service Operations> Monitor Monitoring> Asynchronous Services

select distinct SUBNODE, -- SUBQUEUE,  18 dist

IB_OPERATIONNAME, VERSIONNAME,PUBNODE, --PUBSTATUS, PUBCONSTATUS,  

QUEUENAME,EXTOPERATIONNAME,  ROUTINGDEFNNAME--,NRID,ACTIONNAME, CONVERSATIONID 

from PSIBPUBCON_VW where  SUBNODE <> 'PSFT_LM'; -- or pubnode = 'PSFT_HR';

select distinct  PUBNODE,IB_OPERATIONNAME, VERSIONNAME, ACTIONNAME, QUEUENAME, EXTOPERATIONNAME

--IB_SEGMENTINDEX, IB_OPERATIONNAME, VERSIONNAME, ACTIONNAME, --SUBQUEUE,

--PUBNODE, PUBSTATUS, SUBCONSTATUS, QUEUENAME,EXTOPERATIONNAME, PROCESS_INSTANCE, CONVERSATIONID

from PSIBSUBCON_VW where  pUBNODE<> 'PSFT_LM';

select distinct PUBNODE, PUBSTATUS, QUEUENAME, EXTOPERATIONNAME, IB_OPERATIONNAME ,ORIGPUBNODE, CONVERSATIONID

from PSIBPUBHDR_VW order by  ORIGPUBNODE ,PUBNODE;

 PeopleTools> Integration Broker> Service Operations> Monitor Monitoring> Synchronous Services

PeopleTools>Integration Broker>Integration Setup>Service Operations c/IB_PROFILE.IB_SERVICE.GBL

select LASTUPDDTTM, DESCR, DESCRLONG,a.* from PSOPERATION  a where IB_OPERATIONNAME='XX_PUNCH_TIME' ;;

select IB_OPERATIONNAME, QUEUENAME, MSGNAME, IB_MSGVERSION,a.* from PSOPRVERDFNPARM a where IB_OPERATIONNAME='XX_PUNCH_TIME' ;

  select LASTUPDDTTM, DESCR, DESCRLONG,a.* from PSOPERATION  a where IB_OPERATIONNAME='XX_PUNCH_TIME' ;;

select IB_OPERATIONNAME, QUEUENAME, MSGNAME, IB_MSGVERSION,a.* from PSOPRVERDFNPARM a where IB_OPERATIONNAME='XX_PUNCH_TIME' ;

2nd field on page: Operation Type : RTNGTYPE

 

select IB_OPERATIONNAME, HANDLERNAME, HANDLERID, HANDLEROWNER, HANDLERTYPE, ACTIVE_FLAG,

LASTUPDDTTM, LASTUPDOPRID, DESCR, DESCRLONG,

a.* from PSOPRHDLR a where IB_OPERATIONNAME like 'XX_%' and ACTIVE_FLAG <> 'I' order by a.LASTUPDDTTM desc;

 

select IB_OPERATIONNAME, --HANDLERNAME, HANDLERID, HANDLEROWNER, HANDLERTYPE, ACTIVE_FLAG,

   VERSIONNAME, SENDERNODENAME, RECEIVERNODENAME, RTNGTYPE, ROUTINGDEFNNAME, EFFDT, EFF_STATUS

 from PSIBRTNGDEFN_VW a where IB_OPERATIONNAME like 'xx%';

select a1.IB_OPERATIONNAME,a1.LASTUPDDTTM, a1.DESCR, a1.DESCRLONG,

 a2.QUEUENAME, a2.MSGNAME, a2.IB_MSGVERSION  -- empty a1.MSGNAME, a1.IB_MSGVERSION

 ,HANDLERNAME, HANDLERID, HANDLEROWNER, HANDLERTYPE, ACTIVE_FLAG,h1.LASTUPDDTTM, h1.LASTUPDOPRID, h1.DESCR, h1.DESCRLONG

 ,r1.VERSIONNAME, SENDERNODENAME, RECEIVERNODENAME, r1.RTNGTYPE, ROUTINGDEFNNAME, r1.EFFDT, EFF_STATUS

 ,'~~',q1.LASTUPDDTTM, q1.DESCR, q1.DESCRLONG,q1.QUEUESTATUS,'~~',m1.*

from PSOPERATION  a1, ((PSOPRVERDFNPARM a2 left outer join PSOPRHDLR h1 on a2.IB_OPERATIONNAME=h1.IB_OPERATIONNAME ) 

left outer join PSIBRTNGDEFN_VW r1 on a2.IB_OPERATIONNAME=r1.IB_OPERATIONNAME ), PSQUEUEDEFN q1,PSMSGVER m1  

where a1.IB_OPERATIONNAME=a2.IB_OPERATIONNAME and  

a1.IB_OPERATIONNAME='xxx' and

a2.QUEUENAME = q1.QUEUENAME and

a2.MSGNAME = m1.MSGNAME

;;

select ROUTINGDEFNNAME, EFFDT, VERSION, EFF_STATUS, SENDERNODENAME, RECEIVERNODENAME, RTNGTYPE, IB_DELAYPROCESSING, IB_RESTMETHOD, IB_SYNCHNONBLOCK, IB_ACCEPT_COMP, IB_SCHEMA_DETAILS, IB_UNORDER_SEGMENT, IB_OPERATIONNAME, VERSIONNAME, CONNOVERRIDE, CONNGATEWAYID, CONNID, LOGMSGDTLFLG, IB_DELIVERYMODE, ONSNDHDLRNAME, ONRCVHDLRNAME, ONPREHDLRNAME, ONPOSTHDLRNAME, GENERATED, IB_ARR_SECURE_EP, IB_LOCALIDFLG, LASTUPDDTTM, LASTUPDOPRID, OBJECTOWNERID, DESCR, DESCRLONG

from PSIBRTNGDEFN;

select ROUTINGDEFNNAME, EFFDT, PARAMETERNAME, SENDERNODENAME, RECEIVERNODENAME, XFRMNAME, XFRMNAME_SECOND, INMSGNAME, INMSGVERSION, OUTMSGNAME, OUTMSGVERSION, ALIASNAME, VERSIONNAME, IB_SECURITYOVRD, IBEXTERNALUSERID, IBEXTERNALPWD, TOKENTYPE, TOKEN_ENCRYPTED, IB_ENCRYPTLEVEL, TOKEN_SIGNED

from PSRTNGDFNPARM;

select ROUTINGDEFNNAME, EFFDT, NAMETYPE, PROPNAME, PROPVALUE, COMMENTS

from PSRTNGDFNPROP;

PeopleTools>Integration Broker>Integration Setup>Queues /c/IB_PROFILE.IB_OPERATION.GBL

select LASTUPDDTTM, DESCR, DESCRLONG,q.* from PSQUEUEDEFN q where QUEUENAME ='XX_PUNCH_TIME_OUT';

 

PeopleTools > Integration Broker > Integration Setup > Messages c/IB_PROFILE.IB_MESSAGE_BUILDER.GBL

select * from PSMSGVER where MSGNAME='XX_PUNCH_TIME';

 

 

IB Used recently and additional details:

 

-- Publication Contracts

select distinct a1.*, i1.LASTUPDDTTM, i1.DESCR, dbms_lob.substr (i1.DESCRLONG,3000,1  ),i1.IB_SERVICENAME,i1.LASTUPDOPRID,q.LASTUPDDTTM, q.DESCR, dbms_lob.substr (q.DESCRLONG,3000,1  ),q.LASTUPDOPRID

,m1.MSGNAME,m1.DESCR, m1.LASTUPDDTTM, m1.LASTUPDOPRID, dbms_lob.substr (m1.DESCRLONG,3000,1  )

from

(select distinct SUBNODE, -- SUBQUEUE,  18 dist

IB_OPERATIONNAME, VERSIONNAME,PUBNODE, --PUBSTATUS, PUBCONSTATUS, 

QUEUENAME,EXTOPERATIONNAME,  ROUTINGDEFNNAME--,NRID,ACTIONNAME, CONVERSATIONID

 ,min(LASTUPDDTTM),max(LASTUPDDTTM)

 from PSIBPUBCON_VW

 group by SUBNODE, IB_OPERATIONNAME, VERSIONNAME, PUBNODE, QUEUENAME, EXTOPERATIONNAME, ROUTINGDEFNNAME

 ) a1

 

 , PSOPERATION i1, PSQUEUEDEFN q, PSOPRVERDFNPARM i2 left outer join PSMSGDEFN m1  on i2.MSGNAME = m1.MSGNAME

 where i1.IB_OPERATIONNAME = a1.IB_OPERATIONNAME and q.QUEUENAME = a1.QUEUENAME and i1.IB_OPERATIONNAME = i2.IB_OPERATIONNAME

 

 ; -- or pubnode = 'PSFT_HR';

 

-- Subscription Contracts

select distinct  a1.*, i1.LASTUPDDTTM, i1.DESCR, dbms_lob.substr (i1.DESCRLONG,3000,1  ),i1.IB_SERVICENAME,i1.LASTUPDOPRID,q.LASTUPDDTTM, q.DESCR, dbms_lob.substr (q.DESCRLONG,3000,1  ),q.LASTUPDOPRID

,m1.MSGNAME,m1.DESCR, m1.LASTUPDDTTM, m1.LASTUPDOPRID, dbms_lob.substr (m1.DESCRLONG,3000,1  )

from

(select distinct  PUBNODE,IB_OPERATIONNAME, VERSIONNAME, ACTIONNAME, QUEUENAME

--IB_SEGMENTINDEX, IB_OPERATIONNAME, VERSIONNAME, ACTIONNAME, --SUBQUEUE,

--PUBNODE, PUBSTATUS, SUBCONSTATUS, QUEUENAME,EXTOPERATIONNAME, PROCESS_INSTANCE, CONVERSATIONID

,min(LASTUPDDTTM),max(LASTUPDDTTM)

from  PSIBSUBCON_VW -- where  pUBNODE<> 'PSFT_LM'

group by PUBNODE,IB_OPERATIONNAME, VERSIONNAME, ACTIONNAME, QUEUENAME) a1

 

, PSOPERATION i1, PSQUEUEDEFN q, PSOPRVERDFNPARM i2 left outer join PSMSGDEFN m1  on i2.MSGNAME = m1.MSGNAME

where i1.IB_OPERATIONNAME = a1.IB_OPERATIONNAME and q.QUEUENAME = a1.QUEUENAME and i1.IB_OPERATIONNAME = i2.IB_OPERATIONNAME

 

;

 

-- Operation Instances

select distinct  a1.*, i1.LASTUPDDTTM, i1.DESCR,dbms_lob.substr ( i1.DESCRLONG,3000,1  ),i1.IB_SERVICENAME,i1.LASTUPDOPRID,q.LASTUPDDTTM, q.DESCR, dbms_lob.substr (q.DESCRLONG,3000,1  ),q.LASTUPDOPRID

,m1.MSGNAME,m1.DESCR, m1.LASTUPDDTTM, m1.LASTUPDOPRID, dbms_lob.substr (m1.DESCRLONG,3000,1  )

from

(select distinct PUBNODE, PUBSTATUS, QUEUENAME, EXTOPERATIONNAME, IB_OPERATIONNAME ,ORIGPUBNODE, CONVERSATIONID

,min(LASTUPDDTTM),max(LASTUPDDTTM)

from PSIBPUBHDR_VW group by PUBNODE, PUBSTATUS, QUEUENAME, EXTOPERATIONNAME, IB_OPERATIONNAME ,ORIGPUBNODE, CONVERSATIONID)

a1, PSOPERATION i1, PSQUEUEDEFN q, PSOPRVERDFNPARM i2 left outer join PSMSGDEFN m1  on i2.MSGNAME = m1.MSGNAME

where i1.IB_OPERATIONNAME = a1.IB_OPERATIONNAME and q.QUEUENAME = a1.QUEUENAME and i1.IB_OPERATIONNAME = i2.IB_OPERATIONNAME

order by  ORIGPUBNODE ,PUBNODE;

 

--asynch

select  distinct

a1.*, i1.LASTUPDDTTM, i1.DESCR, dbms_lob.substr (i1.DESCRLONG,3000,1  ),i1.IB_SERVICENAME,i1.LASTUPDOPRID

-- ,q.LASTUPDDTTM, q.DESCR,dbms_lob.substr ( q.DESCRLONG,3000,1  ),q.LASTUPDOPRID ,i2.IB_OPERATIONNAME,q.QUEUENAME

,m1.MSGNAME,m1.DESCR, m1.LASTUPDDTTM, m1.LASTUPDOPRID, dbms_lob.substr (m1.DESCRLONG,3000,1  )

from

(

select distinct -- 'ps_amm_synclis'                         ,PUBLISHTIMESTAMP, LASTUPDDTTM

IB_OPERATIONNAME,VERSIONNAME, TRXTYPE, PUBNODE,--PUBLISHER,STATUSSTRING,

DESTPUBNODE, FINALDESTNODE,  PUBROUTINGTRAIL,max(PUBLISHTIMESTAMP),min(PUBLISHTIMESTAMP), max(LASTUPDDTTM), min(LASTUPDDTTM)

from ps_amm_synclist                 a

group by IB_OPERATIONNAME, VERSIONNAME, TRXTYPE, PUBNODE, DESTPUBNODE, FINALDESTNODE, PUBROUTINGTRAIL

)

a1, PSOPERATION i1, PSOPRVERDFNPARM i2 left outer join PSMSGDEFN m1  on i2.MSGNAME = m1.MSGNAME

where i1.IB_OPERATIONNAME = a1.IB_OPERATIONNAME and i1.IB_OPERATIONNAME = i2.IB_OPERATIONNAME

order by  1 ,PUBNODE;