The decision whether to use software mirroring for a product database is typically taken during the installation procedure of the product. Following is a sample job that shows how you can deactivate software mirroring for an existing product database.
Important: All database access must be stopped during the entire procedure.
The example refers to the _beta check|z MAIN database.
Step 1:
BST05UPF updates the definitions of MAINDATA (data of MAIN) and MAINKEY (key of MAIN) in the _beta check|z database definition file.
Step 2:
BST05UPF deletes the definitions for MAINDATM (mirrored data of MAIN) and MAINKEYM (mirrored key of MAIN) in the _beta check|z database definition file.
Step 3:
IDCAMS deletes the physical mirror database components.
+-----------------------------------------------------------------------+
|jobcard |
|//* |
|//* STEP 1: UPDATE MAINKEY AND MAINDATA DEFINITION IN B91DEF |
|//UPDDEF1 EXEC PGM=BST01RFF,REGION=0M, |
|// PARM=('S=91,B01LST=00,B91LST=00', |
|// 'PGM=BST05UPF,SIGNON=NO') |
|//* |
|//STEPLIB DD DISP=SHR,DSN=BETA.APFLOAD |
|// DD DISP=SHR,DSN=BSA.LOAD |
|// DD DISP=SHR,DSN=BETA91.LOAD |
|//* |
|//SFFPARM DD DISP=SHR,DSN=BETA.PARMLIB |
|//* |
|//B91DEF DD DISP=SHR,DSN=BETA91.BQL.DEF |
|//* |
|//BQLIN DD * |
| DEFINE UPDATE FILE MAINDATA - |
| MIRROR (NO) |
| DEFINE UPDATE FILE MAINKEY - |
| MIRROR (NO) |
|/* |
|//BQLPRINT DD SYSOUT=* |
|//SYSPRINT DD SYSOUT=* |
|//* |
|//SFFFDUMP DD SYSOUT=* |
|//SYSUDUMP DD SYSOUT=* |
|//SYSABEND DD SYSOUT=* |
|//* |
|//* STEP 2: DELETE MAINKEYM AND MAINDATM DEFINITION IN B91DEF |
|//UPDDEF2 EXEC PGM=BST01RFF,REGION=0M, |
|// PARM=('S=91,B01LST=00,B91LST=00', |
|// 'PGM=BST05UPF,SIGNON=NO') |
|//* |
|//STEPLIB DD DISP=SHR,DSN=BETA.APFLOAD |
|// DD DISP=SHR,DSN=BSA.LOAD |
|// DD DISP=SHR,DSN=BETA91.LOAD |
|//* |
|//SFFPARM DD DISP=SHR,DSN=BETA.PARMLIB |
|//* |
|//B91DEF DD DISP=SHR,DSN=BETA91.BQL.DEF |
|//* |
|//BQLIN DD * |
| DEFINE DELETE FILE MAINDATM |
| DEFINE DELETE FILE MAINKEYM |
|/* |
|//BQLPRINT DD SYSOUT=* |
|//SYSPRINT DD SYSOUT=* |
|//* |
|//SFFFDUMP DD SYSOUT=* |
|//SYSUDUMP DD SYSOUT=* |
|//SYSABEND DD SYSOUT=* |
|//* |
|//* STEP 3: DELETE THE PHYSICAL MIRROR DATABASE |
|//DELETE EXEC PGM=IDCAMS |
|//SYSPRINT DD SYSOUT=* |
|//SYSIN DD * |
| DELETE BETA91.BQL.MIRRMAIN.DATA |
| DELETE BETA91.BQL.MIRRMAIN.KEY |
|/* |
+-----------------------------------------------------------------------+