Results 1 to 13 of 13
  1. #1
    Join Date
    Sep 2010
    Posts
    34

    Unanswered: what should I monitor?

    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

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Quote Originally Posted by robert_tr View Post

    What should I check to make sure everything is okay?
    For that you'll need to check everything, I presume.

  3. #3
    Join Date
    Sep 2010
    Posts
    34
    Quote Originally Posted by n_i View Post
    For that you'll need to check everything, I presume.
    Thanks but, how to?

  4. #4
    Join Date
    Sep 2008
    Location
    Toronto,Canada
    Posts
    655
    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

  5. #5
    Join Date
    Nov 2011
    Location
    Shen Zhen,China
    Posts
    37
    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

  6. #6
    Join Date
    Sep 2010
    Posts
    34
    Quote Originally Posted by wolaos123 View Post
    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???

  7. #7
    Join Date
    Sep 2010
    Posts
    34
    Quote Originally Posted by DBFinder View Post
    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
    OK, thank you. How to get a lock and dump snapshots? thanks

  8. #8
    Join Date
    Sep 2008
    Location
    Toronto,Canada
    Posts
    655
    Quote Originally Posted by robert_tr View Post
    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.
    Last edited by DBFinder; 12-13-11 at 22:14.

  9. #9
    Join Date
    Sep 2010
    Posts
    34
    Quote Originally Posted by DBFinder View Post
    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!!!!!!!!!!!!!!!!

  10. #10
    Join Date
    Nov 2011
    Location
    Shen Zhen,China
    Posts
    37
    Quote Originally Posted by robert_tr View Post
    Thanks, but what I need to check in tablespaces, history file, backups info and how???

    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

  11. #11
    Join Date
    Jan 2003
    Posts
    1,605
    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

  12. #12
    Join Date
    Jul 2011
    Location
    USA
    Posts
    80
    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.
    Last edited by niteshtheone; 12-14-11 at 03:05.

  13. #13
    Join Date
    Sep 2010
    Posts
    34
    Thanks at all!!!! I will try.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •