Checklist for implementing the Stored Procedures RMRTPE and RMRSQPE. These include WLM setup, procedure creation, Post Install process, and the location of documentation.
Additional Information on the implementation and use of RMRTPE and RMRSQPE
RMRTPE : This REXX procedure resets identity column numbering after a table reload. When a table involved in an Alter or Compare strategy contains an identity column, this procedure is called prior to a DROP to save the current MAXASSIGNEDVAL of the identity column and add +1 to the value. This is stored as an internal sequence object. Once the table is recreated and loaded the RMRTPE procedure is called again where it retrieves the value saved off from the first call. Behind the scenes an ALTER TABLE, ALTER Column RESTART WITH is used.
RMRSQPE: This REXX procedure prevents duplicates for altered sequences. It is called before and after any sequence object is dropped and recreated. The procedure restarts numbering for the sequence object from the previous MAXASSIGNEDVAL after the sequence object is recreated.
Note: The stored procedure creates Job-temporary DB2 sequences. Verify that the proper authorizations exist to permit your jobs to create sequences.
DB2 TOOLS POST INSTALL
Post Install Tailor RCM (Informational RCMCUST member) for RMRTPE and RMRSQPE creation.
MODEL CHANGES REQUIRED