There are cases when a table space does not have any containers
defined, for example during a restore into a staging database.
Querying the containers for such a table space will fail with
SQL0083C, e.g.:
$ db2 list tablespace containers for 3
SQL0083C A memory allocation error has occurred.
The DB2 diagnostic log will contain messages similar to:
2012-11-30-15.24.32.880093-300 I1064514E3058 LEVEL:
Warning
PID : 22028 TID : 46913126656320 KTID :
23157
PROC : db2sysc
INSTANCE: db2inst1 NODE : 000 DB :
SAMPLE
APPHDL : 0-20 APPID:
*LOCAL.db2inst1.121130202054
AUTHID : PSUSTR HOSTNAME: hotel59
EDUID : 18 EDUNAME: db2agent (SAMPLE)
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.
<...skipping...>
DATA #4 : Requested size, PD_TYPE_MEM_REQUESTED_SIZE, 8 bytes
0
<...skipping...>
DATA #8 : File name, PD_TYPE_OSS_MEM_FILE_NAME, 11 bytes
sqlbagapi.C
DATA #9 : Line of code, PD_TYPE_OSS_MEM_LINE_NUM, 8 bytes
1665
<...skipping...>
CALLSTCK: (Static functions may not be resolved correctly, as
they are resolved to the nearest symbol)
[0] pdLog + 0x230
[1] sqlogmblkEx + 0x22C6
[2] sqlbQryPoolCont + 0x12EB
[3] sqlbOpenPoolContQry + 0x109
<...skipping...>
2012-11-30-15.24.32.897240-300 I1067573E594 LEVEL:
Error
PID : 22028 TID : 46913126656320 KTID :
23157
PROC : db2sysc
INSTANCE: db2inst1 NODE : 000 DB :
SAMPLE
APPHDL : 0-20 APPID:
*LOCAL.db2inst1.121130202054
AUTHID : PSUSTR HOSTNAME: hotel59
EDUID : 18 EDUNAME: db2agent (SAMPLE)
FUNCTION: DB2 UDB, buffer pool services, sqlbQryPoolCont,
probe:1316
MESSAGE : ZRC=0x820F0004=-2112946172=SQLO_MEM_SIZE "Mem Mgt
invalid size"
DIA8563C An invalid memory size was requested. |
****************************************************************
* USERS AFFECTED: *
* See Error Description *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 9.7 for Linux, UNIX, and Windows Fix Pack 8. *
**************************************************************** |
