home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Latest versionsfixlist
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

DB2 - Problem description

Problem IT10344 Status: Closed

TRAP HAPPENS WHEN CALLING A STORE PROCEDURE WITH IUD STATEMENT ON A ROS
ENABLED STANDBY

product:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problem description:
Trap may happen when calling a store procedure with 
IUD(INSERT/UPDATE/DELETE) statement from a ROS 
enabled(DB2_HADR_ROS=ON) standby server. 
 
A sample SP would trigger this problem: 
db2  "DROP TABLE TEST_TABLE" 
db2  "CREATE TABLE TEST_TABLE(C1 INT)" 
db2 "CREATE OR REPLACE PROCEDURE test_bad() 
   SPECIFIC test_bad 
   AUTONOMOUS 
   BEGIN ATOMIC 
   DECLARE S_SQL1 VARCHAR(4096);-- 
   SET S_SQL1='INSERT INTO  test_table values(123)';-- 
   PREPARE S1 FROM S_SQL1;-- 
   EXECUTE S1;-- 
   END" 
 
The trap stack: 
sqlpReservedToBeFreed 
sqldReleaseReservedSpace 
sqldCheckPageForSpace 
sqldCheckPageForInsert 
sqldFindPageForRow 
sqldInsertRow 
sqldRowInsert 
sqlrinsr 
sqlriisr 
sqlriSectInvoke 
sqlrr_process_execute_request 
sqlrr_execute 
pvmPackage::executeSection 
PVM::executeQuery 
PVM::run 
pvm_entry 
sqloInvokeFnArgs 
sqlriInvokerTrusted 
sqlricall 
sqlerAutonomousSession 
sqleIndCoordProcessRequest 
sqeAgent::RunEDU 
sqzEDUObj::EDUDriver 
sqlzRunEDU 
sqloEDUEntry 
start_thread
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* n/a                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 V97 Fixpack 11 or later.                      * 
****************************************************************
Local Fix:
Avoid calling a SP with IUD statement.
Solution
he problem is firstly fixed on DB2 V97 Fixpack 11.
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
26.07.2015
09.10.2015
09.10.2015
Problem solved at the following versions (IBM BugInfos)
9.7.FP11
Problem solved according to the fixlist(s) of the following version(s)
9.7.0.11 FixList