I am having issues.....

I have an automated process which connects via an ODBC connection to DB2. This process works fine except on the odd occasion when it stops to request a password.

The thing is the password is hardcoded for the Process and it doesnt happen all the time. This leads me to believe that the connection is timing out. I have done a little research and have come to my own conclusion that it could be down to locking.

If a row\table is locked while trying to insert would this have the same result - timing out and requesting a password?

is there any way around this??

Many thanks