Results 1 to 5 of 5
  1. #1
    Join Date
    Feb 2007
    Posts
    10

    Unanswered: batch file delay

    Hi guys , I have been running a db2 update code in a batch file in dos for the past 24 hours.There is no error message, but the execution takes forever yet the code is only 23-line ;intended to update 590 rows of a column.what could be the problem?

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    We need more specific information to help you. The update statements with the problem would be a good place to start along with the ddl for the tables involved. Also include your DB2 version and OS.

    Andy

  3. #3
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    My guess is that you hit a locking issue in your application (SQL script). What's your lock timeout set to?
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

  4. #4
    Join Date
    Feb 2007
    Posts
    10
    Stolze, my lock timeout is set to -1. Is that a bad thing?

  5. #5
    Join Date
    Jul 2006
    Location
    Pune , India
    Posts
    433
    Yes -1 suggest infinite waiting
    you shld set some time value for that say 60 or 120 seconds
    Rahul Singh
    Certified DB2 9 DBA / Application Developer

Posting Permissions

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