RCM: Why does a -0551 occur on a call to Stored Procedure PTI.RMRTPE?.

book

Article ID: 192267

calendar_today

Updated On:

Products

CA RC Compare for DB2 for z/OS CA Database Management for DB2 for z/OS - Administration Suite CA Endevor SCM Interface for DB2 for z/OS CA Endevor SCM Interface for Remote DB2 for z/OS CA RC/Extract for DB2 for z/OS CA RC/Migrator for DB2 for z/OS CA RC/Merger for DB2 for z/OS CA RC/Query for DB2 for z/OS CA RC/Secure for DB2 for z/OS CA RC/Update for DB2 for z/OS

Issue/Introduction

 
When executing a strategy with Sequence objects, the following errors occur, how can this be resolved?

AUTH ZZADMIN                                                           
RETCODE =     0                                                         
                                                                        
.CALL PROCEDURE PTI.RMRTPE                                              
.DATA                                                                   
GETIDCOLS ZZADMIN  TAUSLOESER ISK.TID100                                
.ENDDATA                                                                
 BPA0052E: STORED PROCEDURE CALL ON DB0Z FAILED, SQL ERROR: -0551.      
 BPA0077E: ZZADMIN CALL PTI.RMRTPE                                      
 BPA0012E: DB2 SQL/DDL ERROR HAS OCCURRED - ROLLBACK ISSUED.            
RETCODE =    16                                                         
                                                                        
 

Environment

Release : 20.0

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

Resolution

Information on stored procedures RMRTPE and RMRSSP can be found in hilvl.CDBASAMP(RCMCUST)
 RMRTPE:

The CA RC/Migrator Table Process Exit DB2 Stored Procedure can be installed to support resetting the identity column sequences for tables involved in alter, compare, or in-place migration strategies.     RMRTPE is a REXX procedure in the installation hlq.CLIST library.    RMRTPE is called using the Batch Processor .CALL PROCEDURE function
before and after any table is unloaded, dropped, recreated, and   reloaded as part of one of these strategy types. The procedure sets    the RESTARTWITH value for the identity column of a recreated table    to the original MAXASSIGNED value (+1) after it is loaded.

SQLCODE -0551 is an authority issue, below is from DB2 for z/OS: Codes:

If this error occurs during invocation of a routine, the authorization  ID auth-id does not have the EXECUTE privilege on any candidate routine
       in the SQL path. The variable for object-name is the name of a candidate  routine in the SQL path.