DB2 FOR LUW / DB2FORLUW / A10 - DB2

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 for Linux, UNIX, and Windows 10.1 Fix Pack 3  * 
****************************************************************

Do not query the table space containers

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
 

Problem first fixed in DB2 for Linux, UNIX, and Windows 10.1 Fix 
Pack 3

keiner bekannt / siehe Local-Fix

Vorgänger  : APAR is sysrouted TO one or more of the following: IC89599 
Nachfolger : 

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

01.12.2012
27.09.2013
27.09.2013