|
Problem IC72331
|
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 / 910 - 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. *
* *
* 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 *
****************************************************************
* RECOMMENDATION: *
* Apply the DB2 V9.1 Fix Pack 10 to the server. *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
DB2 Version 9.1 Fix Pack 10 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 11 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 12 for Linux, UNIX and Windows
|
| Solution |
This was first fixed in V91 FP10. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 01.11.2010
16.06.2011
16.06.2011 |
| Problem solved at the following versions (IBM BugInfos) |
9.1.FP10
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.1.0.10
|
 |
