Missing RTS Update when cloning Data with Source Flashcopy
search cancel

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.