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?

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

My guess is that you hit a locking issue in your application (SQL script). What's your lock timeout set to?

Stolze, my lock timeout is set to -1. Is that a bad thing?

Yes -1 suggest infinite waiting
you shld set some time value for that say 60 or 120 seconds