Hello,
I need advice,
I need to know if all is well there to prevent problems, which snapshots should I check? or what should I check?, need runstats?


What should I check to make sure everything is okay?

Thanks

For that you'll need to check everything, I presume.

Thanks but, how to?

Here is what I do, the simplest and basic thing :

Keep a job open on each database server , watch for

1) Connections executing, lockwait

and

2) Long running queries

I check above every 20 mins, and based on some logic, dump snapshots for database, applications and locks , if certain situation arises. The job will send me an email when it takes snapshot, so that I can review them.

Long Running SQL may help identify bad access paths due to changes in some database objects.

So in brief, database, application,lock snapsots are very useful.

Regards

what I'm monitoring:

runstats
reorgchk
tablespaces
file systems
OS performance
db2diag.log
db2notify file
db2set/dbm/db cfg
history file
backups info
log files
reorg
database objects info

Thanks, but what I need to check in tablespaces, history file, backups info and how???

OK, thank you. How to get a lock and dump snapshots? thanks

db2 get snapshot for locks on <mydb>
db2 get snapshot for applications on <mydb>
db2 get snapshot for database on <mydb>
:
:
db2 get snapshot for all on <mydb>

Check here GET SNAPSHOT command

HTH

PS : all this info is available via SQL commands querying snapshot views and/or snapshot functions. So you can use programming ( a strong plus of DB2) to simplify and customize for your need.

Thank you very much!!!!!!!!!!!!!!!!

what:
tablespaces type,auto resize,auto storage,pagesize,status,utilization,etc.
how many backups avilable,archiving the expiring backups,check if availbel for restoration,...
archive and truncate history,list history file content...

how:
shell programming

I use DB2MON tool to do all this kind of snapshots, monitoring etc. It is a GUI freeware tool, very easy to use: IBM DB2 UDB Performance monitor

To prevent problems :
1. Performance releted problem: need to check stats_time, reorgchk, applications are in lock wait or not, number of connections, bufferpool hit ratio. ( as of now I can figure out only this )
2. Log : need to check log utilization percentage, db2diag.log, to avoid disk full error check mount points of arachive logs.
3. Bottleneck : best option use db2top,its having bottleneck option (B).
4. Tablespace : tablespace state, free pages available, high water mark, space available in mount points.

So many things are there, as of now I am able to figure out only above things.

Thanks at all!!!! I will try.