An IDB2 alert keeps appearing every morning

Products

• Database Management for DB2 for z/OS - Administration Suite
• Database Management for DB2 for z/OS - Performance Suite
• Database Management for DB2 for z/OS - Recovery Suite
• Database Management for DB2 for z/OS - SQL Performance Suite
• Database Management for DB2 for z/OS - Utilities Suite

Issue/Introduction

A production issue caused the following alert to be sent:

SYS1_DB2_ALERT_DB3G_units_of_recovery_have_gone_indoubt_DB3G  

The alert reappears every morning. Recycling the task didn't help. How can this be cleared?

 

 

Environment

Release : 20.0

Resolution

This exception(alert) looks for a total cumulative value for a field to be exceeded. Once this exception is detected, it will continuously occur until either the DB2 subsystem is restarted or until threshold value is updated in the exception definition.