Results 1 to 8 of 8

Thread: db2batch

  1. #1
    Join Date
    Jun 2007
    Posts
    5

    Unanswered: db2batch

    Hi, I am using db2batch to measure my queries but always the elapsed time is wrong. E. g. the query runs about 10 seconds but db2batch measures about 100 seconds. Does anybody have the same problem or does anybody have a clue?
    I am using DB2 Express 9.1.2 with Windows XP

  2. #2
    Join Date
    Jun 2007
    Posts
    5
    Isn't there anybode who has the same problem or knows what to do?

  3. #3
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    Could you let us know a bit more about your scenario? What's the query, what's the exact output of db2batch, what's the result of the "time" command?
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

  4. #4
    Join Date
    Jun 2007
    Posts
    5
    Hi, here a little bit more:

    My db2batch command looks like:

    db2batch -d CDDB -f test.sql -r ausgabe.txt -o e 2 r 10 p 1 -v on -s on


    -------------------------------------------------------------
    * Zeitmarke: Wed Jun 27 2007 12:19:57 Westeuropäische Normalzeit
    ---------------------------------------------


    * SQL-Anweisung Nummer 1:


    select *

    from artists art1, song, albums alb, artist2album art2, cds, cdtracks cdt

    where art2.artistid=art1.artistid and art2.albumid=alb.albumid and

    art2.artist2albumid=cds.artist2albumid and song.songid=cdt.songid and cdt.cdid=cds.cdid;

    Typ Anzahl Wiederholungen Gesamtzeit (S) Mindestzeit (S) Maximalzeit (S) Arithmetisches Mittel Geometrisches Mittel Abgerufene Zeile(n) Ausgegebene Zeile(n)

    --------- ----------- -------------- -------------- --------------- --------------- --------------------- -------------------- ------------------- --------------------

    Anweisung 1 1 126,334136 126,334136 126,334136 126,334136 126,334136 1163691 100


    * Gesamtanzahl Einträge: 1
    * Gesamtzeit: 126,334136 Sekunden
    * Mindestzeit: 126,334136 Sekunden
    * Maximalzeit: 126,334136 Sekunden
    * Zeit (arithmetisches Mittel): 126,334136 Sekunden
    * Zeit (geometrisches Mittel): 126,334136 Sekunden
    ---------------------------------------------

    * Zeitmarke: Mi Jun 27 2007 12:20:20 Westeuropäische Normalzeit

    -------------------------------------------------

    When I compare the timestamps I think the query takes about 23 seconds.
    But db2batch says that the query takes about 126 seconds.

  5. #5
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    Interesting... I have never seen that before. Still, how long does db2batch run in total, i.e. what's the output of the Unix command "time"?

    As another recommendation you may want to use the switch "-i complete" as well for db2batch.
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

  6. #6
    Join Date
    Jun 2007
    Posts
    5
    Hi, I'm using Windows XP and this is the output for one of my queries. db2batch measures 122 seconds, but as you can see the total elapsed time for executing the command was TotalSeconds : 23,8681251

    * Abgelaufene Zeit: 122,714462 Sekunden

    ---------------------------------------------
    * Zeitmarke: Fr Jun 29 2007 13:05:24 Westeuropäische Normalzeit


    Days : 0
    Hours : 0
    Minutes : 0
    Seconds : 23
    Milliseconds : 868
    Ticks : 238681251
    TotalDays : 0,000276251447916667
    TotalHours : 0,00663003475
    TotalMinutes : 0,397802085
    TotalSeconds : 23,8681251
    TotalMilliseconds : 23868,1251

    With -i complete:

    * Vorbereitungszeit: 1,972228 Sekunden
    * Ausführungszeit: 139,029307 Sekunden
    * Abrufzeit: 0,025864 Sekunden
    * Abgelaufene Zeit: 141,027400 Sekunden (gesamt)

    ---------------------------------------------
    * Zeitmarke: Fr Jun 29 2007 13:08:51 Westeuropäische Normalzeit


    Days : 0
    Hours : 0
    Minutes : 0
    Seconds : 27
    Milliseconds : 23
    Ticks : 270232487
    TotalDays : 0,000312769082175926
    TotalHours : 0,00750645797222222
    TotalMinutes : 0,450387478333333
    TotalSeconds : 27,0232487
    TotalMilliseconds : 27023,2487

    Something is wrong with the execution time, but I have no clue

  7. #7
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    You may want to open a PMR with IBM support to get this resolved. I don't think there is anything we can do here.

    p.s: I'm still not sure if the execution of your script in "db2batch" was completed within 22 seconds real time. Did you use a regular wrist watch or something to double-check that?
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

  8. #8
    Join Date
    Jun 2007
    Posts
    5
    Yes, I checked the execution time with a wrist watch too.

Posting Permissions

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