ACM shadow objects generated with ERASE YES for Database Management tools

Products

• Database Management for DB2 for z/OS - Administration Suite
• Database Management for DB2 for z/OS - Performance Suite
• Database Management for DB2 for z/OS - Recovery Suite
• Database Management for DB2 for z/OS - SQL Performance Suite
• Database Management for DB2 for z/OS - Utilities Suite
• DATABASE MANAGEMENT SOLUTIONS FOR DB2 FOR Z/OS

Issue/Introduction

The Db2 catalog tablespaces and indexes are defined with ERASE NO. When generating the script to create the shadow tablespaces and indexes
Database Management for Db2 for z/OS Alternate Catalog Mapping (ACM), why are the shadow objects created with ERASE YES?

Resolution

This is by design to avoid orphaned Db2 datasets. ERASE YES ensures the datasets are erased when the objects are dropped.