|
Problem IC72153
|
Status: Closed |
SQL0727N SYSTEM ACTION TYPE "7" AND IMPLICIT SQLCODE -549 CAN OCCUR WHEN A TRIGGER IS REGENERATED FROM WITHIN A PACKAGE |
| product: |
DB2 FOR LUW / DB2FORLUW / 950 - DB2 |
| 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.
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 |
| Problem Summary: |
****************************************************************
* 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 *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
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 |
The problem was first fixed in Version 9.5 FP8 |
| Workaround |
not known / see Local fix |
| BUG-Tracking |
forerunner : APAR is sysrouted TO one or more of the following: IC72331
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 25.10.2010
05.07.2011
05.07.2011 |
| Problem solved at the following versions (IBM BugInfos) |
9.5.,
9.5.FP8
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.5.0.8
|
 |
