DB2 FOR LUW / DB2FORLUW / A50 - DB2

The SQL routines using dynamic SQL to construct a compiled 
compound statement (a.k.a an anonymous block): 
 
SET V_SQL = 'BEGIN ' || SQL STATEMENTS || ' END'; 
 
causes the SQL compiler to create a package in SYSPLAN for the 
compiled compound statement. As a result, DDL log records is 
written what triggers reply only window on HADR standby enabled 
for ROS. 
 
This APAR is to fix limitation mentioned above. Because 
anonymous block would never drop an existing package and have no 
impact to existing executions, for anonymous block there is no 
need to kick off the readers on standby.

**************************************************************** 
* USERS AFFECTED:                                              * 
* ROS on HADR environment                                      * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 version 10.5 fixpack 3                        * 
****************************************************************

To workaround the issue, you need to use an inline compound 
statement instead of a compiled one i.e.: 
 
SET V_SQL = 'BEGIN ATOMIC ' || SQL STATEMENTS || ' END'; 
 
instead of: 
 
SET V_SQL = 'BEGIN ' || SQL STATEMENTS || ' END';

DB2 Version 10.5 Fix Pack 3 for Linux, UNIX, and Windows
 DB2 Version 10.5 Fix Pack 3a for Linux, UNIX, and Windows
 DB2 Cancun Release 10.5.0.4 (also known as Fix Pack 4) for Linux, UNIX, and Windows
 DB2 Version 10.5 Fix Pack 9 for Linux, UNIX, and Windows
 

Problem was first fixed in DB2 version 10.5 fixpack 3

keiner bekannt / siehe Local-Fix

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

30.09.2013
27.02.2014
27.02.2014