|
Problem IC88781
|
Status: Closed |
SQL0083C WHEN QUERYING TABLE SPACE CONTAINERS |
| product: |
DB2 FOR LUW / DB2FORLUW / A10 - 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 for Linux, UNIX, and Windows 10.1 Fix Pack 3 *
**************************************************************** |
| Local Fix: |
Do not query the table space containers |
| available fix packs: |
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 for Linux, UNIX, and Windows 10.1 Fix
Pack 3 |
| Workaround |
not known / see Local fix |
| BUG-Tracking |
forerunner : APAR is sysrouted TO one or more of the following: IC89599
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 01.12.2012
27.09.2013
27.09.2013 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.1.0.3
|
 |
| 10.1.0.3
|
|
