|
Problem IC73288
|
Status: Closed |
INSERT TAKES TOO LONG |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - 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 of DB2 v9.7 FP3 and below. *
****************************************************************
* PROBLEM DESCRIPTION: *
* It was noticed that it takes a long time to complete when *
* doing an INSERT to a table having auto-generated and bit *
* string columns. *
* *
* *
* 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 to DB2 v9.7 FP4. *
**************************************************************** |
| 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.7 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
|
| Solution |
Problem was fixed in DB2 v9.7 FP4. |
| Workaround |
Explicitly specify a value for generated column (if defined with
GENERATE AS DEFAULT). For example:
insert into N (i, c) values (1, x'00'); |
| BUG-Tracking |
forerunner : APAR is sysrouted TO one or more of the following: IC73601
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 15.12.2010
09.05.2011
09.05.2011 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP4
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.4
|
 |
