You can check to see if there are any pending (deferred) DBM and DB CFG changes with this SQL Snapshot query:
select dbcfg.name, dbcfg.value as current_value, dbcfg.deferred_value as pending_value
from sysibmadm.dbcfg dbcfg
where dbcfg.value != dbcfg.deferred_value
select dbmcfg.name, dbmcfg.value as current_value, dbmcfg.deferred_value as pending_value
from sysibmadm.dbmcfg dbmcfg
where dbmcfg.value != dbmcfg.deferred_value
order by 1 asc;
It would also be easy to simply count the number of pending changes, if any.
DBI Brother-Eagle® for DB2 LUW Enterprise Edition customers can also add key performance and health indicators to Brother-Eagle plus create their own custom drill down reports. Using the SQL Snapshot example above, it would be easy to create an alert and report for pending DB CFG changes:
Step 1: Create the Custom Metric "DBCFG-Chgs", set the alert high threshold to 1, and enter the supporting query for the "stock ticker" display: select count(*) from sysibmadm.dbcfg
where dbcfg.value != dbcfg.deferred_value and DBPARTITIONNUM = %PARTNUM%
Step 2: For the Custom Metric Parameter Drill Down statement, simply enter the query: select * from sysibmadm.dbcfg where dbcfg.value != dbcfg.deferred_value and DBPARTITIONNUM = %PARTNUM%
Step 3: Try it and have fun!
Post from : http://www.dbisoftware.com/blog/db2_performance.php