DB2 FOR LUW / DB2FORLUW / 970 - DB2

Check database for upgrade command (db2ckupgrade) may return 
orphan row warning message when upgrading a v8.* database 
containing PSM native procedures to v9.7. 
 
The following query can help identify the procedure(s) that may 
be affected: 
 
select r.routineschema, r.specificname from 
sysibm.syscodeproperties cp, sysibm.sysroutines r where 
cp.lib_id = r.lib_id and r.implementation = 'db2pvm!pvm_entry' 
and cp.object_id = 0;

**************************************************************** 
* USERS AFFECTED:                                              * 
* n/a                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* Check database for upgrade command (db2ckupgrade) may        * 
* returnorphan row warning message when upgrading a v8.*       * 
* databasecontaining PSM native procedures to v9.7.The         * 
* following query can help identify the procedure(s) thatmaybe * 
* affected:select r.routineschema, r.specificname              * 
* fromsysibm.syscodeproperties cp, sysibm.sysroutines r        * 
* wherecp.lib_id = r.lib_id and r.implementation               * 
* ='db2pvm!pvm_entry'and cp.object_id = 0;                     * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 9.7 Fixpack 1                         * 
****************************************************************

As a workaround, customer should do the following: 
 
- Request help from IBM support 
- Collect the outputs for db2cleancat <dbname> 0 
- Collect the output of the query "select object_type, 
object_id, cp.lib_id, libversion from sysibm.syscodeproperties 
cp, sysibm.sysroutines r where cp.lib_id = r.lib_id"

DB2 Version 9.7 Fix Pack 1 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 6 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 10 for Linux, UNIX, and Windows
 

First fixed in DB2 Version 9.7 Fixpack 1

keiner bekannt / siehe Local-Fix

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

08.09.2009
24.02.2010
24.02.2010

9.7.FP1