The creator used for the internal Hold table used in the Reserve OBID process does not have authorization.

book

Article ID: 197448

calendar_today

Updated On:

Products

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

Issue/Introduction

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

Environment

Release : 20.0

Component : RC/Merger Component of CA RC/Migrator for DB2 for z/OS

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.