Kbase P120316: The ODBC DataServer intermittently returns a record dead-lock error
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
11/9/2006 |
|
Status: Unverified
FACT(s) (Environment):
Windows NT 32 Intel/Windows 2000
ODBC DataServer
SYMPTOM(s):
The ODBC DataServer intermittently returns a record dead-lock error
The table is queried with NO-LOCK option of the 4GL.
The ODBC is connecting to DB2/400
The DataServer log file shows the following error:
S1000: [DataDirect][ODBC DB2 Wire Protocol driver][UDB DB2 for iSeries and AS/400]FAILED EXECUTION DUE TO DEADLOCK/TIMEOUT. REASON <TABLE NAME>.<FIELD NAME> TYPE TABLE
CAUSE:
The Default Isolation Level on the ODBC Driver properties is set to *1-READ COMMITTED*.
FIX:
The ODBC DB2 Wire Protocol driver defaults to *1-READ COMMITTED* on the Default Isolation Level property.
Change the Default Isolation Level to *0-READ UNCOMMITTED* on the Advance tab of the DB2 Wire Protocol Driver on the ODBC Data Source Administrator. Save the change and restart the 4GL client.