|
Problem IT34381
|
Status: Closed |
A DEADLOCK MAY RESULT WHEN MULTIPLE APPLICATIONS CONCURRENTLY INSERT INTO A COLUMN-ORGANIZED TABLE WITH AN IDENTITY COLUMN
|
| product: |
DB2 FOR LUW / DB2FORLUW / B50 - DB2 |
| Problem description: |
When multiple applications insert large amounts of data into a
column-organized table that includes an identity column,
deadlocks may be encountered involving the DMS sequence lock. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* When multiple applications insert large amounts of data into *
* a column-organized table that includes an identity column, *
* deadlocks may be encountered involving the DMS sequence *
* lock. *
****************************************************************
* PROBLEM DESCRIPTION: *
* Deadlocks may be encountered when multiple applications *
* insert data into a column-organized table with an identity *
* column concurrently. *
****************************************************************
* RECOMMENDATION: *
* Increasing the value for the database configuration *
* parameter dlchktime may help reduce the chances of a *
* deadlock. Avoid running applications concurrently if they *
* insert large amounts of data into a column-organized table *
* with an identity column. *
* *
* Upgrade to Db2 11.5.6 *
**************************************************************** |
| Local Fix: |
Increasing the value for the database configuration parameter
dlchktime may help reduce the chances of a deadlock. Avoid
running applications concurrently if they insert large amounts
of data into a column-organized table with an identity column. |
| Solution |
|
| Workaround |
****************************************************************
* USERS AFFECTED: *
* When multiple applications insert large amounts of data into *
* a column-organized table that includes an identity column, *
* deadlocks may be encountered involving the DMS sequence *
* lock. *
****************************************************************
* PROBLEM DESCRIPTION: *
* Deadlocks may be encountered when multiple applications *
* insert data into a column-organized table with an identity *
* column concurrently. *
****************************************************************
* RECOMMENDATION: *
* Increasing the value for the database configuration *
* parameter dlchktime may help reduce the chances of a *
* deadlock. Avoid running applications concurrently if they *
* insert large amounts of data into a column-organized table *
* with an identity column. *
* *
* Upgrade to Db2 11.5.6 *
**************************************************************** |
| Comment |
When multiple applications insert large amounts of data into a
column-organized table that includes an identity column,
deadlocks may be encountered involving the DMS sequence lock. |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 28.09.2020
14.06.2021
14.06.2021 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
