|
Problem IC64892
|
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 / 970 - 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: *
* All users on V9.7 fix pack 2 and earlier *
****************************************************************
* 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_
* 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_compileModeT3P14
* lrr_cmpl_enviT7PP9sqlnq_qur *
* *
* + 0x42D0 *
****************************************************************
* RECOMMENDATION: *
* Upgrade to fix pack 3 *
**************************************************************** |
| Local Fix: |
Remove the keyword from the target column list of the INSERT
statement. |
| available fix packs: |
DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
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 |
|
| 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: IC64913
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 30.11.2009
24.09.2010
24.09.2010 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.3
|
 |
| 9.7.0.3
|
|
