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