We get SQL error -551 when RC/Merger attempts to create temporary Tablespace CADB2TS.
DSNT408I SQLCODE = -551, ERROR: UCDPEGA DOES NOT HAVE THE PRIVILEGE TO
PERFORM OPERATION CREATE TABLESPACE ON OBJECT
DSNT418I SQLSTATE = 42501 SQLSTATE RETURN CODE
DSNT415I SQLERRP = DSNXODD2 SQL PROCEDURE DETECTING ERROR
DSNT416I SQLERRD = 50 0 0 -1 0 0 SQL DIAGNOSTIC INFORMATION
DSNT416I SQLERRD = X'00000032' X'00000000' X'00000000' X'FFFFFFFF'
X'00000000' X'00000000' SQL DIAGNOSTIC INFORMATION
------------------------------- SQL TEXT ----------------------------
CREATE TABLESPACE CADB2TS IN dbname
Release : 20.0
Component : RC/Merger Component of CA RC/Migrator for DB2 for z/OS
Within the current design of RC/Merger there is no way to override the authorization ID used to create the Hold table which is created behind the scenes for the Reserve OBID process. The Authorization ID used, is the owner (CREATOR field from SYSDATABASE) of the target database on the target subsystem.
As the hold table is created just for the purpose of the Reserve OBIDs process, if it is not necessary to reserve OBIDs, then this problem can be avoided by setting the Reserve OBID Analysis option to N.