DB2 FOR LUW / DB2FORLUW / A50 - DB2

DB2 fails to do reinitialization of the package after 
recompilation of the PL/SQL package body in an Oracle compatible 
database 
 
Package header / specification 
======================= 
CREATE OR REPLACE PACKAGE TEST_PKG 
 IS 
  PROCEDURE sp_test; 
 END TEST_PKG; 
/ 
 
Package body 
====================================== 
CREATE OR REPLACE PACKAGE BODY TEST_PKG 
IS 
  -- Package variables 
  g_category VARCHAR2(20); 
  g_subcategory NUMBER; 
  PROCEDURE sp_test 
    IS 
 
  BEGIN 
    dbms_output.put_line('TEST_PKG sp_test g_category:  '|| 
g_category); 
    dbms_output.put_line('TEST_PKG sp_test g_subcategory:  '|| 
g_subcategory); 
  END sp_test; 
 
  -- Initialization block 
  BEGIN 
    g_category := 'TEST_PKG'; 
    g_subcategory := 1; 
    dbms_output.put_line('TEST_PKG INIT BLOCK'); 
  EXCEPTION 
   WHEN OTHERS THEN 
     dbms_output.put_line('error - '|| sqlerrm); 
END TEST_PKG; 
/ 
 
db2 -td/ -f initblockrecompiletest.pks 
DB20000I  The SQL command completed successfully. 
 
db2 -td/ -f initblockrecompiletest.pkb 
DB20000I  The SQL command completed successfully. 
 
db2 call TEST_PKG.sp_test 
 
  Return Status = 0 
 
TEST_PKG INIT BLOCK 
TEST_PKG sp_test g_category:  TEST_PKG 
TEST_PKG sp_test g_subcategory:  1 
 
db2 -td/ -f initblockrecompiletest.pkb 
DB20000I  The SQL command completed successfully. 
 
db2 call TEST_PKG.sp_test 
 
  Return Status = 0 
 
TEST_PKG sp_test g_category: 
TEST_PKG sp_test g_subcategory:

**************************************************************** 
* USERS AFFECTED:                                              * 
* All DB2 V10.5 users                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 V10.5 Fix Pack 7 or higher.                   * 
****************************************************************

Disconnecting and reconnecting the current session will reset 
the package state.

Fixed in DB2 V10.5 Fix Pack 7.

keiner bekannt / siehe Local-Fix

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

16.07.2015
22.01.2016
22.01.2016