|
Problem IC64913
|
Status: Closed |
DB2 SERVER MAY TERMINATE ABNORMALLY WHEN CERTAIN KEYWORDS ARE USED IN THE TARGET COLUMN LIST OF AN INSERT STATEMENT |
| product: |
DB2 FOR LUW / DB2FORLUW / 950 - DB2 |
| Problem description: |
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 Summary: |
****************************************************************
* 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. |
| available fix packs: |
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
|
| Solution |
|
| Workaround |
Remove the keyword from the target column list of the INSERT
statement. |
| BUG-Tracking |
forerunner : APAR is sysrouted TO one or more of the following: IC68503
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 01.12.2009
31.05.2010
31.05.2010 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
