We use Redirected Recovery of Recovery Expert to migrate data
from one database to another database (within same sub-system or
As of now, there is no simple way of knowing whether complete data got migrated properly from source to target or not. And, this is a big concern for us.
I came up with a SQL query that compares source TS's COPYPAGESF
(from SYSCOPY) with target TS's NACTIVE (from SYSTABLESPACESTATS)
after data migration is done.
Most of the Tablespaces got same values, except for few (unable to figure out why).
E.g., TS1 got these values.
a. COPYPAGESF=5 and NPAGESF=66 (both from source TS’s SYSCOPY)
b. NACTIVE=35 and NPAGES=1 (both from target TS’s SYSTABLESPACESTATS after data migration is done)
Can anyone please help me in understanding why COPYPAGESF and NACTIVE values are different?
Senior DB2 DBA.