DB2 FOR LUW / DB2FORLUW / 970 - DB2

admin_copy_schema() completes successfully but the error table 
contains sql20342n for function SYSCAT_COLLATIONNAME 
 
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 function 
SYSCAT_COLLATIONNAME. For example: 
 
IBM][CLI Driver][DB2/NT] SQL20342N  "CMMUSER1" does not have one 
or more required privileges "EXECUTE" on object 
"SYSCAT_COLLATIONNAME" of type "FUNCTION" necessary for 
ownership of the object.

ADMIN_COPY_SCHEMA() COMPLETES SUCCESSFULLY BUT THE ERROR TABLE 
CONTAINS SQL20342N FOR FUNCTION SYSCAT_COLLATIONNAME

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:

25.03.2011
16.12.2011
16.12.2011

9.7.FP5