Results 1 to 3 of 3

Thread: Overhead ...

  1. #1
    Join Date
    Feb 2004
    Posts
    37

    Unanswered: Overhead ...

    OVERHEAD ...


    hi all,

    how can i get the "search-time" to estaminate OVERHEAD Parameter ?



    OVERHEAD = average search-time in Millisekunden + (0,5 * 6)

    where 6 = "rotation latency" in msec ...


    "average search-time in Millisekunden" ????? how can i get it?

    thanks a lot

    bab

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1

    Re: Overhead ...

    Originally posted by bab
    OVERHEAD ...


    hi all,

    how can i get the "search-time" to estaminate OVERHEAD Parameter ?



    OVERHEAD = average search-time in Millisekunden + (0,5 * 6)

    where 6 = "rotation latency" in msec ...


    "average search-time in Millisekunden" ????? how can i get it?

    thanks a lot

    bab
    Read your hard drive specifications.

  3. #3
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    If you create a tablespace using the Control Center Wizard, it will show the calculations. You can choose the existing categories (Desktop IDE, Server SCSI, etc,) and then customize the specific specifications (like RPM or average seek time) and it will show you the calculated overhead.

    Just get to the part in the Wizard where you describe the hard drive settings and then cancel out of the dialog before the tablespace is actually created.
    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
  •