Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2003
    Posts
    47

    Unanswered: High CPU on DB2 production servers

    We are having db2 server in production. Most of the times it is showing the CPU is 100%. How can I find who is cause for this high cpu Is it related to application or db2 instance or space.

    Are there any monitors or utilites avialble for db2 to find out the culprit of the high cpu.


    Shri
    p.srinivasarao

  2. #2
    Join Date
    Oct 2004
    Location
    DELHI INDIA
    Posts
    338
    Quote Originally Posted by palchuri
    We are having db2 server in production. Most of the times it is showing the CPU is 100%. How can I find who is cause for this high cpu Is it related to application or db2 instance or space.

    Are there any monitors or utilites avialble for db2 to find out the culprit of the high cpu.


    Shri
    Hi Dear,

    TO know the CPU usage by different processes: please run the following..

    prstat -a

    But make it sure first that prstat is installed and given proper privilege to the user by the System Admin.

    Thanks,
    Jay (Delhi NCR), India

  3. #3
    Join Date
    Mar 2004
    Location
    Toronto, ON, Canada
    Posts
    513
    Quote Originally Posted by palchuri
    We are having db2 server in production. Most of the times it is showing the CPU is 100%. How can I find who is cause for this high cpu Is it related to application or db2 instance or space.

    Are there any monitors or utilites avialble for db2 to find out the culprit of the high cpu.


    Shri
    What OS? What version of DB2?
    --
    Jonathan Petruk
    DB2 Database Consultant

  4. #4
    Join Date
    Jan 2004
    Posts
    49

    use topas command

    Quote Originally Posted by palchuri
    We are having db2 server in production. Most of the times it is showing the CPU is 100%. How can I find who is cause for this high cpu Is it related to application or db2 instance or space.

    Are there any monitors or utilites avialble for db2 to find out the culprit of the high cpu.


    Shri

    Use 'topas' it will give full details.

Posting Permissions

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