"CHECK PENDING" monitoring

[Felix Medeiros]

 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]

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]

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