DB2 FOR LUW / DB2FORLUW / 970 - DB2

DB2 might catalog wrapped text for an internally-generated 
statement, instead of the original PL/SQL statement, like this. 
 
select valid, substr(text, 1, 600) text from sysibm.sysroutines 
where routinename = 'P' 
 
VALID TEXT 
----- -------------------------------------------------------... 
Y     CREATE PROCEDURE P  WRAPPED SQL09074 ablGWmdiWmtqTmdCTm... 
 
  1 record(s) selected. 
 
This can occur when a previously invalidated non-package PL/SQL 
routine is referenced from another routine inside a PL/SQL 
package body. 
This error does not affect the correct operation of the routine, 
and it only affects the value of the TEXT column.

**************************************************************** 
* USERS AFFECTED:                                              * 
* All                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to Version 9.7 Fix Pack 10                           * 
****************************************************************

The original value of the TEXT column can be restored by 
dropping and recreating the routine. However, without the fix, 
it might be incorrectly catalogued again.

Problem was first fixed in DB2 UDB Version 9.7 Fix Pack 10

keiner bekannt / siehe Local-Fix

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

07.07.2014
24.11.2014
24.11.2014

9.7.FP10