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:
Run SARDBASE ADDDS with extent 1 and 2 with only 1 cylinder.
Run SARDBASE ADDDS for extent 3 with the proper cylinder size you need for production.
With a 3.4, check that all extents are displayed for the temp database.
Rename extent #3 to the production database name
Delete extents 1 & 2
With a 3.4, check that all extents are displayed for the production database (including #3).
Also check to see if #3 extent is cataloged; if not then catalog it.