|
Problem IC72331
|
Status: Geschlossen |
SQL0727N SYSTEM ACTION TYPE "7" AND IMPLICIT SQLCODE -549 CAN OCCUR WHEN A TRIGGER IS REGENERATED FROM WITHIN A PACKAGE |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / 910 - DB2 |
| Problembeschreibung: |
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-Zusammenfassung: |
****************************************************************
* 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: |
|
| verfügbare FixPacks: |
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
|
| Lösung |
This was first fixed in V91 FP10. |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 01.11.2010
16.06.2011
16.06.2011 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
9.1.FP10
|
| Problem behoben lt. FixList in der Version |
| 9.1.0.10
|
 |
