|
Problem IC73243
|
Status: Closed |
A TRAP CAN HAPPEN WHEN SQL PL PROCEDURE USES ARRAYS INTERNALLY. |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
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 Summary: |
****************************************************************
* 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: |
|
| available fix packs: |
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
|
| Solution |
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 |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 13.12.2010
28.04.2011
28.04.2011 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.4
|
 |
