|
Problem IC73601
|
Status: Closed |
INSERT TAKES TOO LONG |
| product: |
DB2 FOR LUW / DB2FORLUW / 950 - DB2 |
| Problem description: |
When trying to execute an INSERT statement to a table having
auto-generated and bit string columns, it is noticed that it
takes
a long time to complete.
This happens if both of the conditions below are met:
1. it is up to DB2 to generate a value for generated column
2. client is trying to insert any value to binary column
For example:
create table N (
i int generated by default as identity (starting from 0,
increment by 1),
c char(1) for bit data);
insert into N (c) values (x'00'); |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* All users running DB2 v9.5 FP7 and earlier. *
****************************************************************
* PROBLEM DESCRIPTION: *
* When trying to execute an INSERT statement to a table having *
* *
* auto-generated and bit string columns, it is noticed that it *
* *
* takes *
* *
* a long time to complete. *
* *
* *
* *
* This happens if both of the conditions below are met: *
* *
* *
* *
* 1. it is up to DB2 to generate a value for generated *
* column *
* 2. client is trying to insert any value to binary column *
* *
* *
* *
* For example: *
* *
* *
* *
* create table N ( *
* *
* i int generated by default as identity (starting from 0, *
* *
* increment by 1), *
* *
* c char(1) for bit data); *
* *
* *
* *
* insert into N (c) values (x'00'); *
****************************************************************
* RECOMMENDATION: *
* Upgrade product to DB2 v9.5 FP8 *
**************************************************************** |
| Local Fix: |
Explicitly specify a value for generated column (if defined with
GENERATE AS DEFAULT)
insert into N (i, c) values (1, x'00'); |
| available fix packs: |
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows
|
| Solution |
The problem has been fixed in DB2 v9.5 FP8 |
| Workaround |
Explicitly specify a value for generated column (if defined with
GENERATE AS DEFAULT)
insert into N (i, c) values (1, x'00'); |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 30.12.2010
05.07.2011
05.07.2011 |
| Problem solved at the following versions (IBM BugInfos) |
9.5.FP8
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.5.0.8
|
 |
