|
Problem IT17876
|
Status: Closed |
DB2 MIGHT INCORRECTLY TRY TO ADD CONTAINER WITH A DUPLICATE NAME |
| product: |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 |
| Problem description: |
The issue results in the following db2diag.log entry:
2016-10-09-21.11.59.258292+120 I1022150E689 LEVEL:
Error
PID : 53073 TID : 140509368542976 PROC :
db2sysc 0
INSTANCE: db2jkl NODE : 000 DB : JKL
APPHDL : 0-36330 APPID:
10.0.0.1.16828.161009134702
AUTHID : SAPJKL HOSTNAME: server
EDUID : 1536 EDUNAME: db2agent (JKL) 0
FUNCTION: DB2 UDB, buffer pool services,
sqlbDMSAddContainerRequest, probe:867
MESSAGE :
ZRC=0x8002003D=-2147352515=SQLB_CONTAINER_ALREADY_ADDED
"Duplicate container"
DATA #1 : <preformatted>
Container
/db2/JKL/sapdata1/db2jkl/NODE0000/JKL/T0000010/C0000004.LRG
already used by tablespace JKL#BTABD
Root cause might be:
In AS when a rebalance occurs via explicit rebalance or implicit
rebalance from ALTER TABLESPACE USING STOGROUP, if a disk error
occurs when allocating containers the ID for the next container
for the tablespace is supposed to be restored to the original
value before the container operations. However the value is
incorrectly restored. If the retry of the container operations
succeeds, the incorrect ID for the next container is written to
disk. If a new container is added and one already exists with
that container name the original db2diag.log message is hit. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to Db2 10.5 Fix Pack 9 or higher *
**************************************************************** |
| Local Fix: |
|
| Solution |
First fixed in Db2 10.5 Fix Pack 9 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 09.11.2016
29.09.2017
29.09.2017 |
| Problem solved at the following versions (IBM BugInfos) |
9.0.
|
| Problem solved according to the fixlist(s) of the following version(s) |
