Accidently deleted a newly created extent and needs to recover OM View
search cancel

Accidently deleted a newly created extent and needs to recover OM View

book

Article ID: 46238

calendar_today

Updated On:

Products

View

Issue/Introduction

If I received a SARDBI23 database (INDEX,DATA) file(s) at nn% utilization message; then ran SARDBASE ADDDS  to added an extent and while not paying attention accidentally deleted that same extent, what is the best way to recover?

Environment

  • View®
  • OM View for z
  • Output Management View® for z/OS

Resolution

Let's say there were 2 extents and a 3rd was newly created and then accidently deleted.

Create a temp database executing the following:

  1. Run SARDBASE ADDDS with extent 1 and 2 with only 1 cylinder.
  2. Run SARDBASE ADDDS for extent 3 with the proper cylinder size you need for production.
  3. With a 3.4,  check that all extents are displayed for the temp database.   
  4. Rename extent #3 to the production database name 
  5. Delete extents 1 & 2
  6. With a 3.4,  check that all extents are displayed for the production database (including #3).
  7.  Also check to see if #3 extent is cataloged; if not then catalog it.
  8. Restart the SARSTC production system.