DB2 Aix Monitoring/alerts tools

http://database.ittoolbox.com/groups/technical-functional/db2-l/db2-aix-monitoringalerts-tools-3239711

 

DB2 Aix Monitoring/alerts tools

Asked by Prashant MJ on 1/16/2010 9:25 AM:

 

Hello,
On one of project the DB2 AIX servers will go live in Prod by this month
end. We need to setup the monitoring and the alerts.
I need your help in understanding what kind of tools can be used..
For Ex : A tablespace has reached its threshold and we get the alerts to our
queue.
So what tool is being used to see this kind of monitoring and setting the
alerts.
Thanks in advance..Please suggest!

 

 

Lekharaju Ennam :

 

what V of DB2 and AIX
use snapshot table functions
if DB2 V9
find all snapshot tables function view
for tablespaces space usage,bufferpool hit ratio, Database Activity , Agent
and momory ,logs space usage , sort activity, lock detail .
db2 " select name from sysibm.systables where creator = 'SYSIBMADM' "
DB2PD ( problem Diagnostic tool)
DB2MTRK ( for instance, DB , agent memory usage)
did STMM ( Self Tuning Memory Management) is turn on
that is DB parameter
for REORG stored procedures ( index,Table ) use REORGCHK_TB_STATS ( for
Table) ,, REORGCHK_IX_STATS ( for Index ) with out reorgchk utility
RUNSTATS for gather stats
DB2DIAG.log file ( find locations db2 get dbm cfg | grep -i diagpath )
*AIX level*
TOPAS
SAR Report
Errpt
lsps ( Page swapping )
iostat
vmstat