worst performing dml

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • yasaswi
    #1

    worst performing dml

    How can I find out the worst performing sql queries or statements in
    DB2 database? Is there a command or script to monitor all the sql
    statements which are consuming huge amounts of CPU cycles and huge
    amounts of memory. Please comment.
    Thanks,
    Yasaswi

    Tags: None
    • Serge Rielau
      #2
      Re: worst performing dml

      yasaswi wrote:[color=blue]
      > How can I find out the worst performing sql queries or statements in
      > DB2 database? Is there a command or script to monitor all the sql
      > statements which are consuming huge amounts of CPU cycles and huge
      > amounts of memory. Please comment.
      > Thanks,
      > Yasaswi
      >[/color]
      Take a look at the activity monitor in DB2 for LUW V8.2.
      It tracks (amongst other things) all cached SQL Statements.

      Cheers
      Serge

        Comment

        • yasaswi
          #3
          Re: worst performing dml

          Hi Serge:
          Is there a link for this as you sent for my other question. Where or
          which manual can I find the information about activity monitor?
          Thanks,
          Yasaswi

          Serge Rielau wrote:[color=blue]
          > yasaswi wrote:[color=green]
          > > How can I find out the worst performing sql queries or statements[/color][/color]
          in[color=blue][color=green]
          > > DB2 database? Is there a command or script to monitor all the sql
          > > statements which are consuming huge amounts of CPU cycles and huge
          > > amounts of memory. Please comment.
          > > Thanks,
          > > Yasaswi
          > >[/color]
          > Take a look at the activity monitor in DB2 for LUW V8.2.
          > It tracks (amongst other things) all cached SQL Statements.
          >
          > Cheers
          > Serge[/color]

            Comment

            • Knut Stolze
              #4
              Re: worst performing dml

              yasaswi wrote:
              [color=blue]
              > Hi Serge:
              > Is there a link for this as you sent for my other question. Where or
              > which manual can I find the information about activity monitor?[/color]

              http://publib.boulder.ibm.com/infocenter/db2help/index.jsp


              --
              Knut Stolze
              Information Integration
              IBM Germany / University of Jena

                Comment

                • Serge Rielau
                  #5
                  Re: worst performing dml

                  yasaswi wrote:[color=blue]
                  > Hi Serge:
                  > Is there a link for this as you sent for my other question. Where or
                  > which manual can I find the information about activity monitor?
                  > Thanks,
                  > Yasaswi
                  >
                  > Serge Rielau wrote:
                  >[color=green]
                  >>yasaswi wrote:
                  >>[color=darkred]
                  >>>How can I find out the worst performing sql queries or statements[/color][/color]
                  >
                  > in
                  >[color=green][color=darkred]
                  >>>DB2 database? Is there a command or script to monitor all the sql
                  >>>statements which are consuming huge amounts of CPU cycles and huge
                  >>>amounts of memory. Please comment.
                  >>>Thanks,
                  >>>Yasaswi
                  >>>[/color]
                  >>
                  >>Take a look at the activity monitor in DB2 for LUW V8.2.
                  >>It tracks (amongst other things) all cached SQL Statements.
                  >>
                  >>Cheers
                  >>Serge[/color][/color]
                  go to www.google.com
                  type:
                  Activity Monitor site:publib.bou lder.ibm.com
                  in the search field.
                  It's the very first link.
                  The DB2 for LUW docs are fully index in google.

                  Cheers
                  Serge

                    Comment

                    Previous template Next
                    Working...