Db2 Tools

 View Only

 "CHECK PENDING" monitoring

Felix Medeiros's profile image
Felix Medeiros posted Nov 09, 2023 10:17 AM

 Hello, we are implementing monitoring in our environment and initially, we need to know if we can monitor (generating alerts) all the tables that have the CHECK PENDING status.

Denis Tronin's profile image
Broadcom Employee Denis Tronin

Hi Felix,

I can think only of one partial solution using SYSVIEW for Db2:
1. Set up a "Database exception" to alert on objects in a restricted status. 
2. Customize the DSQALERT request that returns a list of active exceptions so that it only contains the exceptions for objects in a restricted status (you can use the WHERE clause on a customized message text). There are 3 fields you would be interested in EXP-DATABASE, EXP-PAGESET and EXP-RESTRICTED-STATUS. The last field however will contain the complete status (e.g. "STOP,RECP", or "RW,CHKP,ICOP"). 

Unfortunately I don't think there is a way in SYSVIEW for Db2 to only report on CHKP status, so some post-processing would be required. 

Thanks,
Denis

Steen Rasmussen's profile image
Broadcom Employee Steen Rasmussen

Hello Felix, if you have Database Analyzer you can create an ACTION PROCEDURE using a CONDITION where CHKP is specified. Then tie this to an EXTRACT PROCEDURE where you can limit the scope of objects by either using a NAME based extract or ACTION BASED extract with an Object Selection Profile.

Steen