|
Problem IC73288
|
Status: Geschlossen |
INSERT TAKES TOO LONG |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problembeschreibung: |
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-Zusammenfassung: |
****************************************************************
* 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'); |
| verfügbare FixPacks: |
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
|
| Lösung |
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-Verfolgung |
Vorgänger : APAR is sysrouted TO one or more of the following: IC73601
Nachfolger : |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 15.12.2010
09.05.2011
09.05.2011 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
9.7.FP4
|
| Problem behoben lt. FixList in der Version |
| 9.7.0.4
|
 |
