DB2 FOR LUW / DB2FORLUW / A50 - DB2

After restoring a database in another instance.
Privileges from the original instance owner are transferred to
the new one and then revoked.

The transfer ownership of a trigger from the old instance owner
to the new instance owner does not succeed.

On subsequent operations on the base table which fires the
trigger, the operation will fail and report an error like this
one,
where DB2V105 is the original instance owner.

DB21034E The command was processed as an SQL statement because
it was not a
valid Command Line Processor command. During SQL processing it
returned:
SQL0723N An error occurred in a triggered SQL statement in
trigger
"SCH.TRG1". Information returned for the error includes SQLCODE
"-551",
SQLSTATE "42501" and message tokens
"DB2V105|EXECUTE|SCH.P1337189768".
SQLSTATE=09000

****************************************************************
* USERS AFFECTED:                                              *
* All users who restore into another instance and upgrade.     *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Upgrade to DB2 v10.5 fp 11. Or latest fixpack of v11.1.      *
****************************************************************

keiner bekannt / siehe Local-Fix

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

01.03.2019
17.05.2019
17.05.2019