Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2008
    Location
    Toronto,Canada
    Posts
    655

    Unanswered: DB2 Responsiveness - How to ??

    Hello All,

    I am working on a task to find problems in two databases. One belongs to DB2v8 FP 9 while other DB2v9.1 FP3.

    On AIX ver 5.3, can someone help me in fiinding following

    1. DB2 Overall responsiveness
    2. Network Latency
    3. System ( storage ) disk responsiveness

    Thanks

    DBFinder

  2. #2
    Join Date
    Oct 2004
    Location
    DELHI INDIA
    Posts
    338
    You can use the following to get the comparison chart between both the databases.

    1> db2top & db2 snapshots for Database and Instance
    2> netstat - identify latency in transactions due to network data transfer time
    3> iostat -- system disk responsiveness

    Jayanta Datta
    DB2 UDB DBA
    IBM India, Global Delivery
    New Delhi

  3. #3
    Join Date
    Sep 2008
    Location
    Toronto,Canada
    Posts
    655
    Thanks

    This should be good to start investigation

    Regards
    DBFinder

Posting Permissions

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