REN Server - Revision history

WikiSysop: /* PSREN */

2016-05-19T21:05:22Z

‎PSREN

WikiSysop: /* PSREN */

2016-05-19T21:03:50Z

‎PSREN

WikiSysop: Created page with "The PeopleSoft Real-time Event Notification (REN) Server is part of the PeopleTools Application Server. It is a vital part of the MultiChannel Framework (MCF). Someti..."

2016-05-19T20:55:59Z

Created page with "The PeopleSoft Real-time Event Notification (REN) Server is part of the PeopleTools Application Server. It is a vital part of the MultiChannel Framework (MCF). Someti..."

New page

The [[PeopleSoft]] Real-time Event Notification (REN) Server is part of the [[PeopleTools]] Application Server. It is a vital part of the MultiChannel Framework (MCF).

Sometimes the REN Server black box needs some prompting in its set up. To get an overview of the set up, use the following tables:

==PSMCFRENURLID==

Key: MCFREN_URL_ID

Contains one row for each cluster and shows the URLs to use for the cluster.

==PSRENCLUSTER==

Key: MCFREN_URL_ID, REN_ID

Is the link table between PSMCFRENURLID and PSREN

==PSREN==

Key: REN_ID

Contains one row for each server within the cluster.

select * from PSMCFRENURLID where ACTIVE_FLAG='A'
;

select R.*
from PSMCFRENURLID C
Inner join PSRENCLUSTER RC on (RC. MCFREN_URL_ID=C. MCFREN_URL_ID)
Inner join PSREN R on (RC.REN_ID=R.REN_ID)
where
C.ACTIVE_FLAG='A'

@@ Line 25: / Line 25: @@
 <pre>
-select * from PSMCFRENURLID where ACTIVE_FLAG='A'
+select *
+;
 select R.*
 from PSMCFRENURLID C
-Inner join PSRENCLUSTER RC on (RC. MCFREN_URL_ID=C. MCFREN_URL_ID)
+inner join PSRENCLUSTER RC on (RC.MCFREN_URL_ID=C.MCFREN_URL_ID)
-Inner join PSREN R on (RC.REN_ID=R.REN_ID)
+inner join PSREN R on (RC.REN_ID=R.REN_ID)
 where
 C.ACTIVE_FLAG='A'
+;
 </pre>

@@ Line 24: / Line 24: @@
 Contains one row for each server within the cluster.
+<pre>
 select * from PSMCFRENURLID where ACTIVE_FLAG='A'
+;
@@ Line 34: / Line 34: @@
 where
 C.ACTIVE_FLAG='A'