Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2006

    Unanswered: DB2 performance problem on SUN OS

    I am trying to figure out performance issues on a SUN OS. I am currently running V8.1 with two instances.

    I need to know what is the best way to find the CPU, IO and memory performance. I need to figure out where is the bottlenecks. How do I do this?

  2. #2
    Join Date
    Jun 2003
    Toronto, Canada
    Provided Answers: 1
    It's not really related to DB2, is it? You can use sar or dtrace to look at the performance from the OS perspective.
    "It does not work" is not a valid problem statement.

  3. #3
    Join Date
    Dec 2006
    Thank you for your response.
    The reason I posted it here was due to the fact that I am doing some performance tuning for DB2 on Sun.

    I know there are commands like SAR and vmstat, iostat and all. But my problem is that I don't completely know how to interpret them. It will be helpful if some gives me some documentation on how to look for trouble with these commands.

Posting Permissions

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