DB2 FOR LUW / DB2FORLUW / 970 - DB2

If you created your SQL procedures in DB2 UDB Version 8.1 and 
migrated from a DB2 UDB Version 8 32-bit instance to a DB2 
Version 9.7 64-bit instance, you must drop and re-create those 
SQL procedures as part of the manual migration process. 
 
However, during the migration to V9.7, SQL procedures created in 
V8.1 are changed to FENCED and cannot be identified by the 
following query in InfoCenter. 
 
Migrating SQL procedures 
 
  Procedure 
  2. Run the following query to identify the SQL procedures that 
you need to re-create: 
     SELECT procschema, specificname 
     FROM syscat.procedures 
     WHERE language = 'SQL' AND fenced = 'N' AND 
           substr(IMPLEMENTATION, 10,6) = 'pgsjmp'

**************************************************************** 
* USERS AFFECTED:                                              * 
* DB2 UDB Version 9.7                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error description field for more information.            * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to Version 9.7 FixPack 1.                            * 
****************************************************************

Use the following query instead to identify the SQL procedures 
that you need to re-create. 
 
SELECT procschema, specificname 
FROM syscat.procedures 
WHERE language = 'SQL' AND substr(IMPLEMENTATION, 10,6) = 
'pgsjmp'

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
 

Problem was first fixed in DB2 UDB Version 9.7 FixPack 1.

keiner bekannt / siehe Local-Fix

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

17.07.2009
07.03.2010
07.03.2010

9.7.FP1