Latest versionsfixlist
11.1.0.6 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26
Question in the chat LiveZilla Live Help

DB2 - Problem description

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)
This site uses cookies to make it easier for us to provide you with our services. By using our site you agree to the use of cookies.