Andres Gomez Casanova
Andres Gomez Casanova
db2diag -g EDUNAME="db2logmgr (PDBPM)" /db2dump/pdibpm/db2diag.log | awk '/ADM1848W/ {print $9}' | sort | uniq
La memoria se puede monitorear por medio del comando db2pd -dbptnmem Como se describe aqui: http://www.dbatodba.com/db2/how-to-do/how-to-view-memory-statistics-for-a-database-partition/
Monitor how old is the last full backup db2 "with a (diff) as (select current timestamp - timestamp(max(START_TIME)) as diff FROM SYSIBMADM.DB_HISTORY where OPERATION = 'B' and (OPERATIONTYPE = 'F'...
elements to monitor DB2 by Ember Crooks http://db2commerce.com/2017/06/22/embers-take-on-monitoring-db2-luw/
Due to space or other reasons, an event monitor can be in a state off when wanting to be on. This check will respond the state of the event monitor.
This file should be checked from changes. The same for db2nodes.cfg
Check that both machines have the same configuration
Sometimes, the online directory becomes full because it cannot externalize the files, and the file system is full. In this condition, the message should not show a handle
Tener una sonda que monitoree los estados del comando ADMIN_MOVE_TABLE Con esto permite determinar procesos que se trabaron pero nunca se cancelaron Procesos demorados Se podría hacer un query en...
https://www.ibm.com/developerworks/community/blogs/IMSupport/entry/weekly_tips_from_db2_experts_maintaining_mon_get_pkg_cache_stmt_result_into_a_table?lang=en