Home

Neueste Versionen	FixList
11.1.0.7
10.5.0.9
10.1.0.6
9.8.0.5
9.7.0.11
9.5.0.10
9.1.0.12

Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren
Kontaktformular

DB2 - Problembeschreibung

Problem IC73243	Status: Geschlossen
A TRAP CAN HAPPEN WHEN SQL PL PROCEDURE USES ARRAYS INTERNALLY.
Produkt:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problembeschreibung:
If SQL Procedural Language is using associative array data type defined as in example below, then this issue can occur while running SQL PL procedure. CREATE type testTypeRow as ROW ANCHOR ROW OF test.test_table @ CREATE type testType as testTypeRow array[varchar(6)] @ If this trap happens, the stack traceback file in the db2dump directory may contain these stacks: cloneHelper cloneAssocArrayHdr cloneDyn copy sqlrxArrayCopy sqlrxArrayCopy sqlriInitSpecialRegisters sqlriSectInitializeComplex sqlrr_process_execute_request sqlrr_execute OR allocateDyn setElement sqlraERTSetValue sqlriGlobalVarAssignComponentOf sqlriExecThread sqlriSectInvoke sqlrr_process_execute_request sqlrr_execute OR assocArrayCompare redBlackTree associativeArrayHeader associativeArrayHeader associativeArrayHeader sqlriArrayDescriptor setArrayElement PVM15setArrayElement PVM3runEv
Problem-Zusammenfassung:
**************************************************************** * USERS AFFECTED: * * PSM PROCEDURE USING ARRAYS * **************************************************************** * PROBLEM DESCRIPTION: * * a trap can happen when PSM procedure uses Arrays internally. * * * * * * * * Possible stacks: * * * * cloneHelper * * * * cloneAssocArrayHdr * * * * cloneDyn * * * * copy * * * * sqlrxArrayCopy * * * * sqlrxArrayCopy * * * * sqlriInitSpecialRegisters * * * * sqlriSectInitializeComplex * * * * sqlrr_process_execute_request * * * * sqlrr_execute * * * * * * * * OR * * * * allocateDyn * * * * setElement * * * * sqlraERTSetValue * * * * sqlriGlobalVarAssignComponentOf * * * * sqlriExecThread * * * * sqlriSectInvoke * * * * sqlrr_process_execute_request * * * * sqlrr_execute * **************************************************************** * RECOMMENDATION: * * install this APAR * ****************************************************************
Local-Fix:

verfügbare FixPacks:
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows 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
Lösung
a trap can happen when PSM procedure uses Arrays internally. Possible stacks: cloneHelper cloneAssocArrayHdr cloneDyn copy sqlrxArrayCopy sqlrxArrayCopy sqlriInitSpecialRegisters sqlriSectInitializeComplex sqlrr_process_execute_request sqlrr_execute OR allocateDyn setElement sqlraERTSetValue sqlriGlobalVarAssignComponentOf sqlriExecThread sqlriSectInvoke sqlrr_process_execute_request sqlrr_execute
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung:	13.12.2010 28.04.2011 28.04.2011
Problem behoben ab folgender Versionen (IBM BugInfos)

Problem behoben lt. FixList in der Version
9.7.0.4