DB2 FOR LUW / DB2FORLUW / A50 - DB2

Wrong trigger is being dropped from packed descriptor record if 
using longer schema name and same trigger name due to incorrect 
schema comparison. 
This is causing further issues when one is trying to drop tables 
on which triggers were defined. 
 
 
Repro steps: 
create table table1(i int) 
create table table2(i int) 
create table table3(i int) 
 
create trigger MYLONGSCHEMA1.trig after insert on table1 for 
each row insert into table2 values 1 
create trigger MYLONGSCHEMA11.trig after insert on table1 for 
each row insert into table2 values 1 
 
drop trigger MYLONGSCHEMA11.trig  --> this step causes the 
catalog and trigger packed descriptor inconsistency 
 
drop table table1  --> this step fails incorrectly with a 
SQL0204 but should succeed 
 
create trigger MYLONGSCHEMA11.trig after insert on table2 for 
each row insert into table3 values 1 
 
drop table table1   --> this step fails with -901 "Trigger 
Record Not Found" 
drop table table2   --> this step fails with  -901 "Trigger 
Record Not Found"

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to Db2 10.5 Fix Pack 9 or higher                     * 
****************************************************************

First fixed in Db2 10.5 Fix Pack 9

not known / see Local fix

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

27.06.2017
29.09.2017
29.09.2017

9.0.