In a high availability environment, if you want to remove an event processor (EP), you
must use native SQL commands. Do not remove any EP with monitored servers still assigned to
it.
Before you remove the EP, perform the following tasks:
- Ensure the EP to be removed has no monitored servers assigned to it.
- All EPs must be stopped. (Control Center should be down before making any database
changes.)
- Create a backup the CC_SERVER database table.
To remove an EP name EP1:
-
Reassign any monitored servers from the EP1 to other EPs. Stop the EP's before and back up the
database.
- Ensure that the following query returns zero.
SQL SELECT COUNT(*) FROM CC_SERVER WHERE (ACTIVE_EVENT_PROCESSOR_ID=(SELECT SERVER_ID FROM CC_SERVER WHERE NAME = 'EP1') OR ASSIGNED_EVENT_PROCESSOR_ID = (SELECT SERVER_ID FROM CC_SERVER WHERE NAME = 'EP1')) AND LOGICALLY_DELETED = 0
If it does not return zero then all monitored servers were not reassigned from EP1 to other EPs.
You must fix this before continuing. You'll need to restart the EP and assign the servers to it away
from EP1.
-
Run the following SQLs:
DELETE FROM CC_SERVER_COMPONENT WHERE SERVER_ID IN (SELECT SERVER_ID FROM CC_SERVER WHERE (ACTIVE_EVENT_PROCESSOR_ID=(SELECT SERVER_ID FROM CC_SERVER WHERE NAME = 'EP1') OR ASSIGNED_EVENT_PROCESSOR_ID = (SELECT SERVER_ID FROM CC_SERVER WHERE NAME = 'EP1')) AND LOGICALLY_DELETED = 0)
DELETE FROM CC_SERVER WHERE NAME = 'EP1'
DELETE FROM CC_SERVER WHERE NAME = 'EP1_web_client'
DELETE FROM CC_SERVER WHERE NAME = 'EP1_event_repository'