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 |