DB2 FOR LUW / DB2FORLUW / 970 - DB2

admin_copy_schema() completes successfully but fails to transfer 
the ownership of some procedures and/or functions. 
 
Example: 
 
db2 "call sysproc.admin_copy_schema('DB2INST1', 'DB2INST2', 
'COPY', 'DB2INST2', NULL, NULL, 'DB2INST2', 
'COPY_SCHEMA_ERROR')" 
 
  Value of output parameters 
  -------------------------- 
  Parameter Name  : ERRORTABSCHEMA 
  Parameter Value : DB2INST2 
 
  Parameter Name  : ERRORTABNAME 
  Parameter Value : COPY_SCHEMA_ERROR 
 
  Return Status = 0 
 
 
In this example, all objects are copied successfully from source 
schema DB2INST1 to target scheam DB2INST2, but the error table 
DB2INST2.COPY_SCHEMA_ERROR contains sql20342n for some 
procedures and/or functions. 
 
As an example, the STATEMENT column of the error table may show 
 
TRANSFER OWNER SHIP OF SPECIFIC PROCEDURE "DB2INST2 "."CHECK_ID" 
TO USER DB2INST2 PRESERVE PRIVILEGES 
 
and the DIAGTEXT column of the error table may give an error 
such as 
 
[IBM][CLI Driver][DB2/LINUXX8664] SQL20342N  "DB2INST2" does not 
have one or more required privileges "INSERT, SELECT" on object 
"SECURITY_OBJECT"  of type "TABLE" necessary for ownership of 
the object.

ADMIN_COPY_SCHEMA() COMPLETES SUCCESSFULLY BUT FAILS TO 
TRANSFERTHE OWNERSHIP OF SOME PROCEDURES AND/OR FUNCTIONS.

Manually invoke failed TRANSFER OWNERSHIP statements

DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
 

The problem is first fixed in v9.7 Fix Pack 5 (s111017)

keiner bekannt / siehe Local-Fix

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

22.03.2011
16.12.2011
16.12.2011

9.7.FP5