|
Problem IC88316
|
Status: Closed |
SOMETIMES A CALL TO AN AUTONOMOUS PROCEDURE MAY FAIL WITH : SQL0083C A MEMORY ALLOCATION ERROR HAS OCCURRED |
| product: |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 |
| Problem description: |
Sometimes a call to an Autonomous procedure may fail with :
SQL0083C A memory allocation error has occurred.
Db2diag.log will show error like :
--------------------------------------
2012-06-01-09.30.56.257000+330 I1900F1880 LEVEL: Warning
PID : 10664 TID : 5956 PROC :
db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : SAMPLE
APPHDL : 0-1556 APPID: *LOCAL.DB2.120601040056
AUTHID : ADMINISTRATOR
EDUID : 5956 EDUNAME: db2agent (SAMPLE) 0
FUNCTION: DB2 UDB, SQO Memory Management, sqlogmblkEx,
probe:1000
MESSAGE : ZRC=0x820F0004=-2112946172=SQLO_MEM_SIZE "Mem Mgt
invalid size"
DIA8563C An invalid memory size was requested.
DATA #1 : String, 43 bytes
Memory management block allocation failure.
DATA #2 : Codepath, 8 bytes
2
DATA #3 : Memory pool handle pointer,
PD_TYPE_MEM_POOL_HANDLE_PTR, 8 bytes
0x000007fffcf30af8
DATA #4 : Requested size, PD_TYPE_MEM_REQUESTED_SIZE, 8 bytes
0
DATA #5 : Adjusted block size, PD_TYPE_MEM_ADJUSTED_SIZE, 8
bytes
0
DATA #6 : Options for requested block, PD_TYPE_GET_MEM_OPTIONS,
4 bytes
0x00000000
DATA #7 : Pointer to address that will be set by new allocation,
PD_TYPE_PTR_TO_ADDRESS_OUT, 8 bytes
0x000007fffe076be0
DATA #8 : File name, PD_TYPE_OSS_MEM_FILE_NAME, 10 bytes
sqleseti.C
DATA #9 : Line of code, PD_TYPE_OSS_MEM_LINE_NUM, 8 bytes
904
DATA #10: Resource binding pointer,
PD_TYPE_RESOURCE_BINDING_PTR, 8 bytes
0x0000000000000000
CALLSTCK:
[0] 0x0000000180108F93 pdLog + 0x355
[1] 0x000000018004C732 sqlogmblkEx + 0x102E
[2] 0x000000000426F331 sqleCopySQLSetInfo + 0x6D
[3] 0x00000000020B221C
sqlerAutonomousRoutine::InitializeAutonomousSession + 0x1DE
[4] 0x00000000020B1F3D sqlerAutonomousSession + 0x49
[5] 0x0000000002079C2C sqleIndCoordProcessRequest + 0x78E
[6] 0x0000000001FF9591 sqeAgent::RunEDU + 0x2E5
[7] 0x0000000003A7AFCF sqlzRunEDU + 0x111
[8] 0x00000001800E4363 sqloInitEDUServices + 0x42B
[9] 0x000000007742652D BaseThreadInitThunk + 0xD
2012-06-01-09.30.56.494000+330 I3782F578 LEVEL: Error
PID : 10664 TID : 5956 PROC :
db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : SAMPLE
APPHDL : 0-1556 APPID: *LOCAL.DB2.120601040056
AUTHID : ADMINISTRATOR
EDUID : 5956 EDUNAME: db2agent (SAMPLE) 0
FUNCTION: DB2 UDB, routine_infrastructure,
sqlerAutonomousRoutine::InitializeAutono, probe:997
MESSAGE : ZRC=0x820F0004=-2112946172=SQLO_MEM_SIZE "Mem Mgt
invalid size"
DIA8563C An invalid memory size was requested.
DB2 trace will show :
--------------------------
11610 | | | | | | | | | | | | | | | | |
sqlerAutonomousInvoker exit [rc = 0x820F0004 = -2112946172 =
SQLO_MEM_SIZE]
11611 | | | | | | | | | | | | | | | | | sqlzeMapZrc entry
[eduid 19 eduname db2agent]
11612 | | | | | | | | | | | | | | | | | | sqlzGetZRCInfo
entry [eduid 19 eduname db2agent]
11613 | | | | | | | | | | | | | | | | | | sqlzGetZRCInfo
exit [rc = 0xFFFFFFAD = -83]
11614 | | | | | | | | | | | | | | | | | |
sqlzeStoreFuncName entry [eduid 19 eduname db2agent]
11615 | | | | | | | | | | | | | | | | | |
sqlzeStoreFuncName data [probe 1]
11616 | | | | | | | | | | | | | | | | | |
sqlzeStoreFuncName exit
11617 | | | | | | | | | | | | | | | | | | sqlzelsc entry
[eduid 19 eduname db2agent]
11618 | | | | | | | | | | | | | | | | | | sqlzelsc data
[probe 1]
11619 | | | | | | | | | | | | | | | | | | sqlzelsc exit
11620 | | | | | | | | | | | | | | | | | | sqlrr_dump_ffdc
entry [eduid 19 eduname db2agent]
11621 | | | | | | | | | | | | | | | | | | sqlrr_dump_ffdc
exit
11622 | | | | | | | | | | | | | | | | | |
pdInvokeCatchInterface entry [eduid 19 eduname db2agent]
11623 | | | | | | | | | | | | | | | | | |
pdInvokeCatchInterface data [probe 10]
11624 | | | | | | | | | | | | | | | | | |
pdInvokeCatchInterface exit
11625 | | | | | | | | | | | | | | | | | sqlzeMapZrc
errtrans [probe 40] [ ZRC = 0x820F0004 = -2112946172 =
SQLO_MEM_SIZE --> SQL0083 ]
11626 | | | | | | | | | | | | | | | | | sqlzeMapZrc error
[probe 50] [ ZRC = 0x820F0004 = -2112946172 = SQLO_MEM_SIZE] |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* All users on DB2 V10 FixPack 1 or below. *
****************************************************************
* PROBLEM DESCRIPTION: *
* Sometimes a call to an Autonomous procedure may fail with : *
* SQL0083C A memory allocation error has occurred. *
* *
* Db2diag.log will show error like : *
* -------------------------------------- *
* *
* 2012-06-01-09.30.56.257000+330 I1900F1880 LEVEL: *
* Warning *
* PID : 10664 TID : 5956 PROC : *
* db2syscs.exe *
* INSTANCE: DB2 NODE : 000 DB : *
* SAMPLE *
* APPHDL : 0-1556 APPID: *
* *LOCAL.DB2.120601040056 *
* AUTHID : ADMINISTRATOR *
* EDUID : 5956 EDUNAME: db2agent (SAMPLE) 0 *
* FUNCTION: DB2 UDB, SQO Memory Management, sqlogmblkEx, *
* probe:1000 *
* MESSAGE : ZRC=0x820F0004=-2112946172=SQLO_MEM_SIZE "Mem Mgt *
* invalid size" *
* DIA8563C An invalid memory size was requested. *
* DATA #1 : String, 43 bytes *
* Memory management block allocation failure. *
* DATA #2 : Codepath, 8 bytes *
* 2 *
* DATA #3 : Memory pool handle pointer, *
* PD_TYPE_MEM_POOL_HANDLE_PTR, 8 bytes *
* 0x000007fffcf30af8 *
* DATA #4 : Requested size, PD_TYPE_MEM_REQUESTED_SIZE, 8 *
* bytes *
* 0 *
* DATA #5 : Adjusted block size, PD_TYPE_MEM_ADJUSTED_SIZE, 8 *
* bytes *
* 0 *
* DATA #6 : Options for requested block, *
* PD_TYPE_GET_MEM_OPTIONS, *
* 4 bytes *
* 0x00000000 *
* DATA #7 : Pointer to address that will be set by new *
* allocation, *
* PD_TYPE_PTR_TO_ADDRESS_OUT, 8 bytes *
* 0x000007fffe076be0 *
* DATA #8 : File name, PD_TYPE_OSS_MEM_FILE_NAME, 10 bytes *
* sqleseti.C *
* DATA #9 : Line of code, PD_TYPE_OSS_MEM_LINE_NUM, 8 bytes *
* 904 *
* DATA #10: Resource binding pointer, *
* PD_TYPE_RESOURCE_BINDING_PTR, 8 bytes *
* 0x0000000000000000 *
* CALLSTCK: *
* [0] 0x0000000180108F93 pdLog + 0x355 *
* [1] 0x000000018004C732 sqlogmblkEx + 0x102E *
* [2] 0x000000000426F331 sqleCopySQLSetInfo + 0x6D *
* [3] 0x00000000020B221C *
* sqlerAutonomousRoutine::InitializeAutonomousSession + 0x1DE *
* [4] 0x00000000020B1F3D sqlerAutonomousSession + 0x49 *
* [5] 0x0000000002079C2C sqleIndCoordProcessRequest + 0x78E *
* [6] 0x0000000001FF9591 sqeAgent::RunEDU + 0x2E5 *
* [7] 0x0000000003A7AFCF sqlzRunEDU + 0x111 *
* [8] 0x00000001800E4363 sqloInitEDUServices + 0x42B *
* [9] 0x000000007742652D BaseThreadInitThunk + 0xD *
* *
* 2012-06-01-09.30.56.494000+330 I3782F578 LEVEL: *
* Error *
* PID : 10664 TID : 5956 PROC : *
* db2syscs.exe *
* INSTANCE: DB2 NODE : 000 DB : *
* SAMPLE *
* APPHDL : 0-1556 APPID: *
* *LOCAL.DB2.120601040056 *
* AUTHID : ADMINISTRATOR *
* EDUID : 5956 EDUNAME: db2agent (SAMPLE) 0 *
* FUNCTION: DB2 UDB, routine_infrastructure, *
* sqlerAutonomousRoutine::InitializeAutono, probe:997 *
* MESSAGE : ZRC=0x820F0004=-2112946172=SQLO_MEM_SIZE "Mem Mgt *
* invalid size" *
* DIA8563C An invalid memory size was requested. *
* *
* *
* *
* DB2 trace will show : *
* -------------------------- *
* *
* 11610 | | | | | | | | | | | | | | | | | *
* sqlerAutonomousInvoker exit [rc = 0x820F0004 = -2112946172 = *
* SQLO_MEM_SIZE] *
* 11611 | | | | | | | | | | | | | | | | | sqlzeMapZrc *
* entry *
* [eduid 19 eduname db2agent] *
* 11612 | | | | | | | | | | | | | | | | | | *
* sqlzGetZRCInfo *
* entry [eduid 19 eduname db2agent] *
* 11613 | | | | | | | | | | | | | | | | | | *
* sqlzGetZRCInfo *
* exit [rc = 0xFFFFFFAD = -83] *
* 11614 | | | | | | | | | | | | | | | | | | *
* sqlzeStoreFuncName entry [eduid 19 eduname db2agent] *
* 11615 | | | | | | | | | | | | | | | | | | *
* sqlzeStoreFuncName data [probe 1] *
* 11616 | | | | | | | | | | | | | | | | | | *
* sqlzeStoreFuncName exit *
* 11617 | | | | | | | | | | | | | | | | | | sqlzelsc *
* entry *
* [eduid 19 eduname db2agent] *
* 11618 | | | | | | | | | | | | | | | | | | sqlzelsc *
* data *
* [probe 1] *
* 11619 | | | | | | | | | | | | | | | | | | sqlzelsc *
* exit *
* 11620 | | | | | | | | | | | | | | | | | | *
* sqlrr_dump_ffdc *
* entry [eduid 19 eduname db2agent] *
* 11621 | | | | | | | | | | | | | | | | | | *
* sqlrr_dump_ffdc *
* exit *
* 11622 | | | | | | | | | | | | | | | | | | *
* pdInvokeCatchInterface entry [eduid 19 eduname db2agent] *
* 11623 | | | | | | | | | | | | | | | | | | *
* pdInvokeCatchInterface data [probe 10] *
* 11624 | | | | | | | | | | | | | | | | | | *
* pdInvokeCatchInterface exit *
* 11625 | | | | | | | | | | | | | | | | | sqlzeMapZrc *
* errtrans [probe 40] [ ZRC = 0x820F0004 = -2112946172 = *
* SQLO_MEM_SIZE --> SQL0083 ] *
* 11626 | | | | | | | | | | | | | | | | | sqlzeMapZrc *
* error *
* [probe 50] [ ZRC = 0x820F0004 = -2112946172 = SQLO_MEM_SIZE] *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 V10 FixPack 2 or above. *
**************************************************************** |
| Local Fix: |
This can be avoided by executing a "db2 connect reset" after
defining the procedure, and then re-establishing the connection
before calling the procedure. |
| available fix packs: |
DB2 Version 10.1 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows
|
| Solution |
Problem first fixed in DB2 V10 FixPack 2. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 17.11.2012
19.12.2012
19.12.2012 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.1.0.2
|
 |
| 10.5.0.2
|
|
