Results 1 to 5 of 5
  1. #1
    Join Date
    Mar 2012
    Posts
    120

    Unanswered: help on db2batch

    Hi,
    I need to benchmark 10 executions of a query with parameter markers but I don't know how to write the input file for db2batch.
    I searched for an example but I didn't find any.

    I tried with

    --#PARAM[1:10] [1:10]
    --#BGBLK 10
    select count (R.id) FROM ASSETS A JOIN REPORTS R ON R.assetID = A.assetID WHERE R.id = ? AND R.PropertyID = ?;
    --#EOBLK

    but it doesn't work.

  2. #2
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    can this option help ?
    -m parameters_file
    db2batch - Benchmark Tool
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  3. #3
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    but it doesn't work.
    Means?

    Any error message ? or else ?
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  4. #4
    Join Date
    Nov 2011
    Posts
    334
    Maybe you can try this:
    --#BGBLK 10
    --#PARAM 1:10 1:10 <-- remove the '[]'
    select count (R.id) FROM ASSETS A JOIN REPORTS R ON R.assetID = A.assetID WHERE R.id = ? AND R.PropertyID = ?;
    --#EOBLK

  5. #5
    Join Date
    Mar 2012
    Posts
    120
    Thanks fensung2

Posting Permissions

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