Missing RTS Update when cloning Data with Source Flashcopy
book
Article ID: 186252
calendar_today
Updated On:
Products
RC/Migrator for DB2 for z/OS
Issue/Introduction
When merging data from flashcopy of a PBG TS - no Indices present -, RC/MERGER generates REBUILD INDEX as expected. However if the TS is very large the rebuild index will terminate in error because RC/Merger-provided Sortworks are totally undersized.
Resolution
RC/Merger only provides support for copying the catalog tables (SQLSTATS). We do not directly support copying of RTS.
The recommendation to resolve the Rebuild Index failure in this scenario is to utilize ACM. To do this the RTS tables need to be included in the daily ACM copy job.