DB2 FOR LUW / DB2FORLUW / 970 - 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 9.7 fixpack 9                         * 
****************************************************************

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 9.7 Fix Pack 9 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
 

Problem was first fixed in DB2 version 9.7 fixpack 9

not known / see Local fix

forerunner  : APAR is sysrouted TO one or more of the following: IC96450 IC96475 
follow-up : 

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

25.03.2013
02.10.2013
02.10.2013

9.7.FP9