ACM shadow objects generated with ERASE YES

Products

• 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 for Alternate Catalog Mapping (ACM), why are the shadow objects created with ERASE YES?

 

Environment

Release : 20.0

Resolution

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