UIM Database blocking - maintenance_window_history

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)
• CA Unified Infrastructure Management On-Premise (Nimsoft / UIM)
• CA Unified Infrastructure Management SaaS (Nimsoft / UIM)

Issue/Introduction

We are experiencing issues due to maintenance mode. We are currently using probe version 23.4.6T1 which includes new indexes and have identified blocks in the UIM database caused by MAINTENANCE_WINDOW_HISTORY, which has been running for over half an hour. This is causing application slowness and stalling other jobs.

Environment

• UIM 23.4 CU7

Cause

• Lack of indexes
• purge setting/function

Resolution

1. Deactivate maintenance_mode probe

2. Run-> select * into maintenance_window_history_bkp from maintenance_window_history; --to backup the table

3. Check that the table has rows:  select * from maintenance_window_history_bkp_<date>

4. TRUNCATE TABLE maintenance_window_history

5. select count(*) from maintenance_window_history --it should show 0 rows

6. Activate maintenance_mode

Set the java min/max to 2048 and 4096.

Then be sure to:

1. Deactivate maintenance_mode
2. Wait until the port and PID disappear.
3. Then Activate it.