3366086 - DB6 - Temporary Tablespaces placed offline with error "Duplicate container" and RHEL 7 and later versions.

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).

Db2 LUW IBM
BC-OP-LNX

HA, Mount Point, ADM12512W, Clash, SQL0299N, unmounted, Linux, HADR, node, , KBA , BC-DB-DB6 , DB2 Universal Database for Unix / NT , Known Error