1.3.3.3a Monitoring Patch

This release includes the following:

• A patch to the overall monitoring page for BB so that BB can accurately read the status.
• A fix to provisioning birthdates to HPSM.
• A routine to purge old OIM recon data that is a simplified version of what Oracle provides.
• A process to "fix" missed scheduler tasks so that they don't all "clump" together after a reboot.
• Indexes for key ud_ fields to improve recon performance.

To release this version:

1. (Unix/IDM Staff) Updated Monitoring Pages (On Dev/Test/Patch – Waiting for ear to be deployed on prod):
   1. (IDM Staff) Execute the script $SOFTPATH/changes/monitoring_1333a.sql.  It does the following: (On Dev/Test/Prod/Patch)
      1. Connects to yuidmgr and creates the OIM_ERROR_CLASSIFICATION table, OIM_PROV_MONITORING_V view, and grants rights to idmgr.
      2. Connects to idmgr and creates a synonym for OIM_PROV_MONITORING_V.
   2. (Unix Staff) Delete $JBOSS_HOME/server/default/deploy/idm-oim-monitoring-1.3.3.3.ear
   3. (Unix Staff) Copy the new monitoring pages (idm-oim-monitoring-1.3.3.3a.ear) to $JBOSS_HOME/server/default/deploy/. The file can be found in /tmp/idm1333a/server/default/deploy/
   4. (Unix Staff) Stop the IDM service.
   5. (Unix Staff) Start the IDM service so JBoss will deploy the new war file.
2. (Unix Staff) HPSM Provisioning:
3. (IDM Staff) Recon Data Purge Routine (Complete):
   1. Execute the script $SOFTPATH/changes/purge_utility_1333a.sql.  It does the following:
      1. Connects to IDMGR and grants access to recon tables to YUIDMGR. (Script on prod, but not deployed)
      2. Connects to YUIDMGR:
         1. Creates the purge procedure.
         2. Sets a quiescence period.
         3. Schedules the job.
      3. A log is found in $SOFTPATH/changes/purge_utility_1333a.log.
4. (IDM Staff) Indexes (Complete):
   1. Execute the Oracle turnover script ud_indexes_1333a.sql. It logs into yuidmgr to create the indexes.

Big Brother should be configured to monitor https://identity.yale.edu/monitoring/overall. If it finds "(OK)" anywhere on the page, OIM is OK. Otherwise, there is trouble.

Individuals can see the details behind the Big Brother summary at https://identity.yale.edu/monitoring/details

A home page with IDM links and contact information is at https://identity.yale.edu/monitoring/