Why did RC/Merger create HOLD tablespace?

Document ID : KB000011988
Last Modified Date : 14/02/2018
Show Technical Document Details
Question:

Did you know how why does RC/Merger generate the following messages?

RCM0214I - GROUP ATTACH NAME D0Q1 PROVIDED. MEMBER NAME D3Q1 
WILL BE USED FOR DB2 CONNECTIONS. 

RCM0139I - CREATING CA-DB2 HOLD TABLESPACE &DBNAME..CADB2TS. 
RCM0137I - TABLESPACE CREATED SUCCESSFULLY. SQLCODE = 0. 

RCM0140I - CREATING CA-DB2 HOLD TABLE CADB2ID.#####00017QSYHGM1. 
RCM0137I - TABLE CREATED SUCCESSFULLY. SQLCODE = 0.

Answer:

This is expected behavior as part of RESERVE OBID call in RC/Merger. 
RC/Merger reserve the OBID of the target table space and table to match with the OBIDs of the source table space and table. 
These HOLD table space and table objects will be deleted in RC/Merger TABLE CALL. See the information messages below. 

RCM0134I - DROPPING CA-DB2 HOLD TABLE CADB2ID.#####00003DBCPICP. 
RCM0125I - DROPPING THE CA-DB2 TABLESPACE DBCPICP.CADB2TS. 

RESERVE CALL example: 

.CALL RCMERGER PARM(D12A,RESERVE) 
.DATA 
DATABASE (DBCPICP) 
RESOBID (00003) 
.ENDDATA 

RCM0100I - RC/MERGER BEGINNING. 

RCM0139I - CREATING CA-DB2 HOLD TABLESPACE &DBNAME..CADB2TS. 
RCM0137I - TABLESPACE CREATED SUCCESSFULLY. SQLCODE = 0. 

RCM0140I - CREATING CA-DB2 HOLD TABLE CADB2ID.#####00003DBCPICP. 
RCM0137I - TABLE CREATED SUCCESSFULLY. SQLCODE = 0. 

RCM0101I - RC/MERGER COMPLETED SUCCESSFULLY. 
RETCODE = 0 

TABLE CALL example: 

.CALL RCMERGER PARM(D12A,TABLE) 
.DATA 
.AUTH QARMM 
CREATE TABLE QARMM.TB1TS1CPICP 
( COL1 INTEGER 
, COL2 INTEGER 
.... 
.ENDDATA 

Execution of above TABLE call will delete the HOLD tablespace and table objects before creating the actual target table space and table objects.