ACM shadow objects generated with ERASE YES for Database Management tools
search cancel

ACM shadow objects generated with ERASE YES for Database Management tools

book

Article ID: 258848

calendar_today

Updated On:

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.