Converting databases offline

You can convert full-function databases offline by using the CONVERT command.

About this task

Databases must be offline to use this method. You must manually /DBR your databases before running the conversion job.

When the IMS management of ACBs is enabled:

New database definitions must exist in the IMS catalog staging data sets before running the IMS HALDB Toolkit job.
The shadow database is unloaded by using the active database definition obtained from the IMS catalog directory data sets, then reloaded by using the pending database definition obtained from the IMS catalog staging data sets.

Restriction: Databases with logical relationships (except for indexes) are not supported.

Procedure

When the IMS management of ACBs is enabled, prepare the IMS catalog staging data sets. You can refer to the examples in CONVERT example: Preparing a staging data set before converting a database when the IMS management of ACBs is enabled.
Locate the sample JCL for this task in the SIHCSAMP file, member IHCECVTN.
Specify the JCL DD statements.
For a list of DD statements, see CONVERT DD statements.
Specify the CONVERT command parameters.
For a list of CONVERT command parameters, see CONVERT command parameters.
Specify the ONLINE parameter as ONLINE(N). ONLINE(N) is the default if you do not specify this parameter. The following parameters are required to perform offline conversion:
```
//IHCSYSIN DD *
  CONVERT DBD(xxx) ONLINE(N)...
```
You can also refer to the following examples to code CONVERT JCL statements and command parameters:
Manually /DBR your databases before running the conversion job.
After the conversion process is complete and you are certain that you will not need to revert the database to its non-HALDB state:
- You can delete any DFSMDA members for the old database.
- If the Integrity Checker utility of IMS Library Integrity Utilities is active in your environment, you can delete the RDE for the old database by using the LICON utility.

Example

The following example shows the sample JCL for batch offline conversion:

Figure 1. Sample JCL (IHCECVTN) for batch conversions (Online(N))

//JOBNAME   JOB NAME,000,CLASS=A,MSGCLASS=X                            
//******************************************************************** 
//*     SAMPLE JCL FOR CONVERT ONLINE(N) - "OFFLINE BATCH MODE"        
//*                                                                    
//*  Your databases must be registered to DBRC                         
//*  Your databases must be dbr'd/stopped prior to executing this job  
//******************************************************************** 
//S2     EXEC PGM=IHCHALDB,DYNAMNBR=999,REGION=80M                     
//STEPLIB  DD DISP=SHR,DSN=your.SIHCLOAD   <=== your hcma loadlib      
//         DD DISP=SHR,DSN=your.SDFSRESL     <=== ims reslib           
//         DD DISP=SHR,DSN=your.SHPSLMD0     <=== ims tools loadlib    
//DFSRESLB DD DISP=SHR,DSN=your.SDFSRESL     <=== ims reslib           
//MACLIB   DD DISP=SHR,DSN=your.SDFSMAC      <=== ims maclib           
//IMS      DD DISP=SHR,DSN=your.dbdlib       <=== ims dbdlib           
//IMSDALIB DD DISP=SHR,DSN=your.mdalib       <=== ims mdalib           
//SYSPRINT DD SYSOUT=*                                                 
//MSGPRINT DD SYSOUT=*                                                 
//DBDPRINT DD SYSOUT=*                                                 
//LNKPRINT DD SYSOUT=*                                                 
//AMSPRINT DD SYSOUT=*                                                 
//SYSUDUMP DD SYSOUT=*                                                 
//IHCLIST  DD SYSOUT=*                                                 
//IHCSYSIN DD *                                                        
  CONVERT  ONLINE(N) -                                                 
           DBDPATT(*****...) DSNPREF(DBSMS.DB) -                       
           DBD(xxxx) -                                                 
           PARTNUM(2) -                                                
           ICMID(3) -                                                  
           ICHLQ(DBSMS.DB.IC) -                                        
           ICTRLR(2) -                                                 
           IC.COMP(Y) -                                                
           IC.COMPRTN(FABJCMP2) -                                      
           PTRCHECK(Y)