CA Fast Recover for DB2 for z/OSCA Log Analyzer for DB2 for z/OSCA Quick Copy for DB2 for z/OSCA Database Management for DB2 for z/OS - Recovery SuiteCA Merge/Modify for DB2 for z/OSCA Recovery Analyzer for DB2 for z/OSCA Log Analyzer SMF Audit Trace OptionCA MM Backup and Recovery for DB2
Working with the Recover a Dropped Object feature and attempted to recover data for several tablespaces after a DROP TABLESPACE, Log Analyzer was unable to create the SQL statements for one of the tablespaces. On other tablespaces, the process was good and SQL statements were generated without problem. What was wrong with this tablespace?.
Release : 20.0
Component : CA Log Analyzer for DB2 for z/OS
The problem was the PSID of the tablespace recreated was different from the original PSID, this situation can be fixed with the MAPID keyword.
Whenever you need to use an image copy map and there has been a change of PSID or DBID then you need to specify the MAPID keyword. The reason for the MAPID keyword is to connect an image copy map with proper table space internal structure.