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] |
