DB2 - Problem description
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) |