Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2008
    Posts
    88

    Unanswered: Direct reads elapsed time (ms) is it millisecond or microsecond?

    I have got confused, ms generally means millisecond but in the snapshots I have seen it being used as microsecond. Am I correct or is it millisecond only?

  2. #2
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    How about a bit of RTFM? The second hit when searching for "direct reads elapsed time" is this one:
    http://publib.boulder.ibm.com/infoce.../r0001264.html
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

  3. #3
    Join Date
    Jan 2008
    Posts
    88
    Hi stolze,
    my question was not particular to direct reads elapsed time. sometimes I have seen that while using table functions for snapshot there are elements which are broken into two , one for seconds and another for microsecond.for eg : ELAPSED_EXEC_TIME_S
    ELAPSED_EXEC_TIME_MS where MS is microsecond. So I got confused as at one place its saying its millisecond and at another its microsecond.

  4. #4
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    When you do a snapshot for dynamic SQL, you get the elapsed time in the following format:

    nn.nnnnnn seconds

    So I assume that for the snapshot table function, you should divide ELAPSED_EXEC_TIME_MS by 1000000 to get the right answer.
    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
  •