speed test tools

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

    speed test tools

    DB2 gurus, I'm pretty new in DB2, or database field. Now I wanna some tools
    which can measure the speed SQL stmt. be excuted. Is there any one in the
    DB2 software bundle?

    Thanks!


    Tags: None
    • Mark A
      #2
      Re: speed test tools

      "Hardy" <yhang_wang@hot mail.com> wrote in message
      news:caoctp$21d 2$1@mail.cn99.c om...[color=blue]
      > DB2 gurus, I'm pretty new in DB2, or database field. Now I wanna some[/color]
      tools[color=blue]
      > which can measure the speed SQL stmt. be excuted. Is there any one in the
      > DB2 software bundle?
      >
      > Thanks!
      >[/color]
      Look at the db2batch program described in the Command Reference manual. This
      will give information about actual time for an SQL statement to execute.

      If you want a theoretical estimate of the "relative" time, you can use the
      DB2 Explain function. This can be executed as a command or using the Visual
      Explain Tool in the Command Center. The explain show the access path (such
      as using a particular index) that the query will use, in addition to giving
      a timeron estimate. A timeron is not an elapsed time estimate, but a
      relative number useful when comparing different scenarios.


        Comment

        • Hardy
          #3
          Re: speed test tools

          oh,that's good~ thank you, Mark:)

          "Mark A" <nobody@switchb oard.net> дÈëÓʼþ
          news:w_Ozc.125$ 2t2.54524@news. uswest.net...[color=blue]
          > "Hardy" <yhang_wang@hot mail.com> wrote in message
          > news:caoctp$21d 2$1@mail.cn99.c om...[color=green]
          > > DB2 gurus, I'm pretty new in DB2, or database field. Now I wanna some[/color]
          > tools[color=green]
          > > which can measure the speed SQL stmt. be excuted. Is there any one in[/color][/color]
          the[color=blue][color=green]
          > > DB2 software bundle?
          > >
          > > Thanks!
          > >[/color]
          > Look at the db2batch program described in the Command Reference manual.[/color]
          This[color=blue]
          > will give information about actual time for an SQL statement to execute.
          >
          > If you want a theoretical estimate of the "relative" time, you can use the
          > DB2 Explain function. This can be executed as a command or using the[/color]
          Visual[color=blue]
          > Explain Tool in the Command Center. The explain show the access path (such
          > as using a particular index) that the query will use, in addition to[/color]
          giving[color=blue]
          > a timeron estimate. A timeron is not an elapsed time estimate, but a
          > relative number useful when comparing different scenarios.
          >
          >[/color]


            Comment

            Previous template Next
            Working...