DB2 FOR LUW / DB2FORLUW / 980 - DB2

DB2 may return SQL0901N with reason code "invalid qnc 
assignment" and the following call stack 
 
sqlnn_cmpl[370] 
sqlnr_exe[400] 
sqlnr_rcc[100] 
sqlnr_seq[100] 
sqlnr_comp[110] 
sqlnr_start_action[20] 
sqlnr_rcc[100] 
sqlnr_seq[100] 
sqlnr_comp[110] 
sqlnr_endqtb_action[10] 
sqlnr_rcc[100] 
sqlnr_seq[100] 
sqlnr_comp[110] 
sqlnr_rijel_action[40] 
sqlnq_pid::update_qnc[100] 
sqlnq_pid::replace_qnc[100] 
 
This problem may be found in a SQL statement containing inner 
joins between primary key columns and foreign key columns of two 
or more tables. 
 
<The script below is a reproduction of the problem. I will leave 
it to you to decide whether you want to include in the APAR text 
or not.> 
 
create table t1(pk int not null primary key, c1 varchar(1)); 
create table t2(pk smallint not null primary key, fk1 int not 
null, fk2 int not null, c1 varchar(1)); 
alter table t2 add foreign key (fk1) references t1(pk); 
alter table t2 add foreign key (fk2) references t1(pk); 
create table t3(fk smallint not null, c1 varchar(1)); 
alter table t3 add foreign key (fk) references t2(pk); 
 
select * from t1,t2,t3 where t1.pk=t2.fk1 and t2.pk=t3.fk;

DB2 may return SQL0901N with reason code "invalid qnc 
assignment" and the following call stack 
 
sqlnn_cmpl[370] 
sqlnr_exe[400] 
sqlnr_rcc[100] 
sqlnr_seq[100] 
sqlnr_comp[110] 
sqlnr_start_action[20] 
sqlnr_rcc[100] 
sqlnr_seq[100] 
sqlnr_comp[110] 
sqlnr_endqtb_action[10] 
sqlnr_rcc[100] 
sqlnr_seq[100] 
sqlnr_comp[110] 
sqlnr_rijel_action[40] 
sqlnq_pid::update_qnc[100] 
sqlnq_pid::replace_qnc[100] 
 
This problem may be found in a SQL statement containing inner 
joins between primary key columns and foreign key columns of two 
or more tables. 
 
<The script below is a reproduction of the problem. I will leave 
it to you to decide whether you want to include in the APAR text 
or not.> 
 
create table t1(pk int not null primary key, c1 varchar(1)); 
create table t2(pk smallint not null primary key, fk1 int not 
null, fk2 int not null, c1 varchar(1)); 
alter table t2 add foreign key (fk1) references t1(pk); 
alter table t2 add foreign key (fk2) references t1(pk); 
create table t3(fk smallint not null, c1 varchar(1)); 
alter table t3 add foreign key (fk) references t2(pk); 
 
select * from t1,t2,t3 where t1.pk=t2.fk1 and t2.pk=t3.fk;

DB2 Version 9.8 Fix Pack 3 for Linux, UNIX, and Windows
 DB2 Version 9.8 Fix Pack 4 for AIX and Linux
 DB2 Version 9.8 Fix Pack 5 for AIX and Linux
 

Defect   => wsdbu00624680 
Fixed In => db2 V9.8 + FP3 
Module   => engn_sqnr

not known / see Local fix

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

06.03.2010
21.01.2011
21.01.2011

9.8.