Latest versionsfixlist
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

DB2 - Problem description

Problem IC89599 Status: Closed

SQL0083C WHEN QUERYING TABLE SPACE CONTAINERS

product:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problem description:
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.
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* See Error Description                                        * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 9.7 for Linux, UNIX, and Windows Fix Pack 8.  * 
****************************************************************
Local Fix:
Do not query the table space containers
available fix packs:
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
Problem first fixed in DB2 9.7 for Linux, UNIX, and Windows Fix 
Pack 8
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
17.01.2013
02.04.2013
02.04.2013
Problem solved at the following versions (IBM BugInfos)
9.7.
Problem solved according to the fixlist(s) of the following version(s)
9.7.0.8 FixList
This site uses cookies to make it easier for us to provide you with our services. By using our site you agree to the use of cookies.