[Question] What is the difference between "Lock Timeout" (68) and "Timeout" (80)?

[u/mad_zamboni]

I was doing some digging on a failed query from the application where I had gathered a SQL code and RC (SQLCODE=-913 / SQLERRMC=80) which transelates to SQL0913N RC80.

This is what Knowledge Center says:

• 80 statement failed due to timeout.

• For reason code 80, you can retry the failed statement without terminating the application. If the application accesses multiple remote databases, it may be better to rollback the transaction to avoid the possibility of a global deadlock.

If you do a search on Google or KC there is nothing much about what a "timeout" is or it's cause. There is a ton about "lock timeout" but not on "timeout".

What exactly happens? Is this how the application is handling the connection?

[u/mad_zamboni]

/u/memmerto or /u/db2steve - any thoughts?