Release : 20.0
Component : CA RC/Migrator for DB2 for z/OS
Information on stored procedures RMRTPE and RMRSSP can be found in hilvl.CDBASAMP(RCMCUST)
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.