Creator used for the internal hold table used in the RC/Merger reserve OBID process does not have authorization

Products

• RC/Migrator for DB2 for z/OS
• RC/Merger for DB2 for z/OS

Issue/Introduction

Encounter SQL error -551 when RC/Merger for Db2 for z/OS (RMM) attempts to create temporary tablespace TS1 for the hold table:

  DSNT408I SQLCODE = -551, ERROR:  xxxxxxx 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 TS1 IN dbname

Resolution

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.