A Cookbook for Recovering ADABAS Data Bases

This is a cookbook for recovering ADABAS data bases from a hardware error or from a total machine room disaster.

STEP 1: TAKE A FDR DUMP OF THE PACK(S) IF POSSIBLE

There are two reasons for this step. The first is obviously to save as much data as possible. The second is to determine ALL locations where the pack has been damaged.

STEP 2: DETERMINE THE AFFECTED ADABAS COMPONENT(S)

From STEP 1's output, you can find out which ADABAS components have been affected by comparing these locations with the cylinder and track addresses of the various data sets as shown in "pack maps".

The specific component that has been damaged will determine the recovery path you will soon be following.

STEP 3: REPLACE THE HDA, AND INITIALIZE THE PACKS

This will be done by the hardware maintenance vendor.

STEP 4: RESTORE OR REALLOCATE THE CLOG

After the dataset(s) has been restored from a FDR dump or a new Command Log has been allocated and formatted (ADAFRMCL in SAGESA.DBA.TOOLS), ADABAS will come up through Autorestart normally, with files current and correct. There is no lose since we do not use the Command log.

STEP 4: RESTORE OR REALLOCATE THE PLOG

After the dataset(s) has been restored from a FDR dump or the new Protection Log has been allocated and formatted (ADAFRMPL in SAGESA.DBA.TOOLS), ADABAS will come up through Autorestart normally with files current and correct.

STEP 5: TAKE A FULL BACKUP OF THE DATA BASE IMMEDIATELY

It is extremely important in this case to take a full ADASAV dump as soon as possible.

STEP 6: RESTARTING OF BATCH JOBS

All restartable batch job(s) that were executing when the data base abended will restart fine, but the non-restartable batch job(s) will not. The non-restartable batch jobs will have to be looked at.

STEP 4: RESTORE OR REALLOCATE A TEMP/SORT DATASET

You need to restored the dataset(s) from an FDR dump or rellocate and format a new TEMP/SORT dataset(s) (ADAFRMTS in SAGESA.DBA.TOOLS).

STEP 5: FOLLOW SOFTWARE AG UTILITY ABEND PROCEDURE

The recovery procedures are different for all utilities, and there is not enough room here to enumerate all possibilities. You need to refer to the restart procedures in the Production job and/or to the ADABAS Utilities manuals.

STEP 4: RESTORE OR REALLOCATE A DSIM DATASET

You need to restore the dataset from an FDR dump or rellocate and format a new DSIM dataset (ADAFRMDS in SAGESA.DBA.TOOLS).

STEP 5: FOLLOW SOFTWARE AG UTILITY ABEND PROCEDURE

The recovery procedures are different for all utilities, and there is not enough room here to enumerate all possibilities. You need to refer to the restart procedures in the Production job or to the ADABAS Utilities manuals.

STEP 4: RESTORE OR REALLOCATE THE RECOVERY AID DATASET(S)

You need to restore the dataset(s) from an FDR dump or rellocate and format a new Recovery Aid dataset(s) (ADAFRMRA in SAGESA.DBA.TOOLS).

STEP 5: PREPARE THE RECOVERY AID DATASET(S)

You need to prepare the Recovery Aid datase(s) by running ADARAIPR in SAGESA.DBA.TOOLS.

STEP 6: FOLLOW SOFTWARE AG UTILITY ABEND PROCEDURE

The recovery procedures are different for all utilities, and there is not enough room here to enumerate all possibilities. You need to refer to the restart procedures in the Production job or to the ADABAS Utilities manuals.

STEP 7: TAKE A FULL BACKUP OF THE DATA BASE IMMEDIATLY

It is extremely important in this case to take a full ADASAV dump as soon as possible. This will start the first generation in the Recovery Aid datasets.

STEP 4: RESTORE OR REALLOCATE THE DATASET(S)

You need to restore the dataset(s) from an FDR dump or reallocate and format new dataset(s) (ADAFRMAL in SAGESA.DBA.TOOLS).

STEP 5: RESTORE THE DATA BASE

You should restore the data base now using the sample JCL member ADARESTR in SAGESA.DBA.TOOLS.

STEP 6: REGENERATE TO THE TIME OF THE CRASH

You need now to regenerate from the end of the last save (Full or Delta) to the crash. Sample JCL member REGEN in SAGESA.DBA.TOOLS can help you with this. You can find the PLOG and Block numbers from the last backup job that ran. You can find out if any ADABAS utilities need to be rerun using ADARAI in SAGESA.DBA.TOOLS. You can use ADARAIJL in SAGESA.DBA.TOOLS to recreate the utilities.

STEP 4: RESTORE OR REALLOCATE THE DAMAGED DATASET

You need to restore the dataset(s) from an FDR dump or reallocate and format new dataset(s) (ADAFRMAL in SAGESA.DBA.TOOLS).

STEP 5: RESTORE THE DATA BASE

You should restore the data base now using the sample JCL member ADARESTR in SAGESA.DBA.TOOLS.

[an error occurred while processing this directive]