Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2013
    Posts
    10

    Unanswered: Default value of Statement QueryTimeout in DB2v9.7.7???

    I tried to find out like what is the default value of Statement QueryTimeout in DB2 V9.7.7 using jdbc driver??? I googled alot but did not get this specific information. I found the value is 0 in Db2V9.7.4. I am having hard time to find in verison 9.7.7.

    Please help me out.

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Why do you think the value should be different between the two fix packs? By the way, the actual JDBC property name is commandTimeout I believe.
    ---
    "It does not work" is not a valid problem statement.

  3. #3
    Join Date
    Nov 2013
    Posts
    10
    Yes, there is some requirement that I need to meet.
    As I debugged my code with DB2V9.7.4.0 and I checked statement.getQueryTimeout() value which is 0 that means there is no limit of time for query execution.
    So I need to check whether the same value is there in 9.7.7. As I guess the value will be same for fixpacks of Db2V9.
    Am I right????

  4. #4
    Join Date
    Nov 2013
    Posts
    10
    I tried to find out commandTimeout in my application. The value is 60sec that DB2V9.7.7 is setting. Now the question, is the value 60sec is enough for long running queries???

Posting Permissions

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