Symptom
DB6 - Temporary Tablespaces are placed offline due to "Duplicate Container" on RHEL 7 and later versions.
The db2diag.log reports the following errors for the temporary tablespaces.
2023-01-01 LEVEL: Error
PID : XXXX TID : XXXXXXXXXXXXXXX PROC : db2sysc 0
INSTANCE: db2XXX NODE : 000 DB : XXX
APPHDL : XXXX APPID: *XXXXXXXXXXXXXXXXXXXXX
AUTHID : DB2XXX HOSTNAME: XXXXXXXXX
EDUID : 00 EDUNAME: db2agent XXXXXXXXXXXX
FUNCTION: DB2 UDB, buffer pool services, sqlbAddOneContainer, probe:XXXX
MESSAGE : ZRC=0x8002003D=-2147352515=SQLB_CONTAINER_ALREADY_ADDED
"Duplicate container"
DATA #1 : <preformatted>
Container /db2/<SID>/sapdata<nr>/db2<SID>/NODE0000/<SID>/XXXXXXXXX/XXXXXXX.TMP already used by tablespace PSAPTEMP16.
Error can be for any of the Temp tablespaces with one or more reporting to be offline, (SYSTOOLSTMPSPACE, PSAPTEMP32).
Read more...
Environment
Db2 LUW IBM
BC-OP-LNX
Keywords
HA, Mount Point, ADM12512W, Clash, SQL0299N, unmounted, Linux, HADR, node, , KBA , BC-DB-DB6 , DB2 Universal Database for Unix / NT , Known Error
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.