DB2 FOR LUW / DB2FORLUW / 950 - DB2

After altering the size of a table, which is used by a trigger, 
SQL0727N error occurs when a trigger is regenerated from within 
a package bound with DYNAMICRULES where the value RUN is not 
used. 
 
Example scenario: 
 
 
1. Create 2 tables TABLE1 and TABLE2. 
 
2. Create a trigger on TABLE1, which inserts a record into 
TABLE2. 
3. Bind the static SQL package which contains the SQL which 
activates the trigger. 
 
 
4. ALTER TABLE2 to increase the size of a the column of TABLE2 - 
 
this invalidates the trigger and the package 
5. Execute the SQL which belongs to the package.  SQL0727N error 
occurs. 
 
6. Rebind the package with dynamicrules bind option.  SQL0727N 
error occurs. 
 
SQL0727N  An error occurred during implicit system action type 
"7".  Information returned for the error includes SQLCODE 
"-549", SQLSTATE "42509" and message tokens "create|package|TEST 
|package".  SQLSTATE=56098

**************************************************************** 
* USERS AFFECTED:                                              * 
* All                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* After altering the size of a table, which is used by a       * 
* trigger,                                                     * 
* SQL0727N error occurs when a trigger is regenerated from     * 
* within                                                       * 
* a package bound with DYNAMICRULES where the value RUN is not * 
*                                                              * 
* used.                                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to version 9.5 FixPack8                              * 
****************************************************************

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
 

The problem was first fixed in Version 9.5 FP8

keiner bekannt / siehe Local-Fix

Vorgänger  : APAR is sysrouted TO one or more of the following: IC72331 
Nachfolger : 

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

25.10.2010
05.07.2011
05.07.2011

9.5.,
9.5.FP8