Results 1 to 6 of 6
  1. #1
    Join Date
    Jan 2009
    Posts
    153

    Unanswered: Performance Issue

    Hi Experts,

    All the developers are complaining about performance issue that is the whole server is slow.


    The server is DB2 9.5C Express

    OS:windows XP

    2GB RAM

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Bummer....
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  3. #3
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    Obviously, you are using the wrong type of graphics card in the server...
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

  4. #4
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    Quote Originally Posted by ratheeshknair
    Hi Experts,

    All the developers are complaining about performance issue that is the whole server is slow.


    The server is DB2 9.5C Express

    OS:windows XP

    2GB RAM
    You really need to ask for specific help. Your statement is so vague, that nobody can help you. All you will get are comments like the ones from Marcus and Stolze.

    Andy

  5. #5
    Join Date
    Jan 2009
    Posts
    153
    I am new to DB2 that y asked sch a question...i found the number of applications connected which is less than 50.

    Can anyone please tell how to figure out this type of issues in DB2.

    How can we find the the issue is caused by a particular query?
    How can we identify locks and deadlocks in DB2?
    How to check whether any blocking is there?
    How to know the cpu utilisation of each process?
    How to know the time connection existed?

    Please reply

  6. #6
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    If I were you, I would find someone who has some experience as a DB2 DBA. If you are new, you will need some DB2 education, or start reading all the manuals.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

Posting Permissions

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