|
Problem IC64913
|
Status: Geschlossen |
DB2 SERVER MAY TERMINATE ABNORMALLY WHEN CERTAIN KEYWORDS ARE USED IN THE TARGET COLUMN LIST OF AN INSERT STATEMENT |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / 950 - DB2 |
| Problembeschreibung: |
When the following keywords are used in the target column list
of an INSERT statement, DB2 server may terminate
abnormally. The keywords are:
- <sequence name>.NEXTVAL
- <sequence name>.CURRVAL
- <sequence name>.PREVVAL
- LEVEL (when Hierarchical Queries compatibility
feature is enabled using DB2_COMPATIBLITY_VECTOR registry
variable)
- ROWNUM (when ROWNUM compatibility feature is enabled
using DB2_COMPATIBLITY_VECTOR registry variable)
Example:
.
create table t1 (i1 int);
create sequence SEQ1;
insert into t1 (SEQ1.currval) values (1);
.
-------Frame------ ------Function + Offset------
0x09000000823FB52C pp__17sqlnq_qclqncchildFv + 0xC
0x09000000823FCFB4
sqlnq_fix_insert_values__FPP9sqlnq_pidP9sqlnq_qcxP3locP9sqlnq_pi
d
+ 0x674
0x09000000825E55E4 sqlnq_sem__FPP8stknode_i10actiontypePUcP3loc
+ 0x97A4
0x0900000077E65748 sqlnp_smactn__FP8sqlnp_cbi + 0xB28
0x0900000077E70974 sqlnp_parser__FP8sqlnp_cb + 0x1994
0x0900000077E6367C sqlnp_main__FP12sqlnq_stringsPP9sqlnq_qur +
0xABC
0x090000006447A230
sqlnn_cmpl__FP8sqeAgentP11sqlrrstrings17sqlnn_compileModeT3P14sq
lrr_cmpl_enviT7PP9sqlnq_qur
+ 0x42D0 |
| Problem-Zusammenfassung: |
****************************************************************
* USERS AFFECTED: *
* V9.5 *
****************************************************************
* PROBLEM DESCRIPTION: *
* When the following keywords are used in the target *
* columnlistof an INSERT statement, DB2 server may *
* terminateabnormally. The keywords are:- <sequence *
* name>.NEXTVAL- <sequence name>.CURRVAL- <sequence *
* name>.PREVVAL- LEVEL (when Hierarchical Queries *
* compatibilityfeature is enabled using *
* DB2_COMPATIBLITY_VECTOR registryvariable)- ROWNUM *
* (when ROWNUM compatibility feature isenabledusing *
* DB2_COMPATIBLITY_VECTOR registry variable)Example:.create *
* table t1 (i1 int);create sequence SEQ1;insert into t1 *
* (SEQ1.currval) values (1);.-------Frame------ ------Function *
* + Offset------0x09000000823FB52C pp__17sqlnq_qclqncchildFv + *
* 0xC0x09000000823FCFB4sqlnq_fix_insert_values__FPP9sqlnq_pidP9s
* 0x6740x09000000825E55E4sqlnq_sem__FPP8stknode_i10actiontypePUc
* 0x97A40x0900000077E65748 sqlnp_smactn__FP8sqlnp_cbi + *
* 0xB280x0900000077E70974 sqlnp_parser__FP8sqlnp_cb + *
* 0x19940x0900000077E6367C *
* sqlnp_main__FP12sqlnq_stringsPP9sqlnq_qur+0xABC0x090000006447A
* 0x42D0 *
****************************************************************
* RECOMMENDATION: *
* Upgrade to Fix Pack 6 *
**************************************************************** |
| Local-Fix: |
Remove the keyword from the target column list of the INSERT
statement. |
| verfügbare FixPacks: |
DB2 Version 9.5 Fix Pack 6a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 7 for Linux, UNIX, and Windows
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
|
| Lösung |
|
| Workaround |
Remove the keyword from the target column list of the INSERT
statement. |
| Bug-Verfolgung |
Vorgänger : APAR is sysrouted TO one or more of the following: IC68503
Nachfolger : |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 01.12.2009
31.05.2010
31.05.2010 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
|
| Problem behoben lt. FixList in der Version |
