Converting databases online

You can convert full-function databases online by using the CONVERT command in batch mode.

About this task

New data set allocations use the same System Managed Storage (SMS) constructs or the same volume serial when running outside of SMS.

Databases can remain online while using this method.

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

Make sure that IMS Online Reorganization Facility is installed.

You use the commands that are part of that product. For more information about IMS Online Reorganization Facility, see the IMS Database Solution Pack IMS Online Reorganization Facility User's Guide.
Ensure that IMS Online Reorganization Facility is available in STEPLIB.

Otherwise, error message IHC01111E Software for ORF not available is issued.
Ensure that the databases are registered in DBRC.
When the IMS management of ACBs is enabled, create 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 IHCECVTY.
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(Y). ONLINE(N) is the default if you do not specify this parameter. The following parameters are required to perform online conversion:
```
//IHCSYSIN DD *
  CONVERT DBD(xxx) ONLINE(Y)...
```
You can also refer to the following examples to code CONVERT JCL statements and command parameters:
Optional: Specify IMS Online Reorganization Facility commands.
For more information, see IMS Online Reorganization Facility commands for CONVERT.
Submit the job.
When the IMS management of ACBs is disabled, perform a standard IMS online change. When the IMS management of ACBs is enabled, issue the IMPORT DEFN SOURCE(CATALOG) command to activate the new database definition.
If the Integrity Checker utility of IMS Library Integrity Utilities is active in your environment, use the LICON utility and create the RDE for the new database.
Turn off the prohibit authorization flag and bring the database back online.
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 online conversion:

Figure 1. Sample JCL (IHCECVTY) for batch conversions (Online(Y))

//JOBNAME   JOB NAME,000,CLASS=A,MSGCLASS=X                                    
//********************************************************************         
//*         SAMPLE JCL FOR CONVERT ONLINE(Y) - "online" batch mode             
//*                                                                            
//*  Your databases must be registered to DBRC                                 
//*  You must have Online Reorganization Facility installed                    
//********************************************************************         
//S2     EXEC PGM=IHCHALDB,DYNAMNBR=999,                                       
//            REGION=80M                                                       
//STEPLIB  DD DISP=SHR,DSN=your.SIHCLOAD   <=== your hcma loadlib              
//         DD DISP=SHR,DSN=your.SHRFLOAD     <=== online reorg 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 
//IMSACB   DD DISP=SHR,DSN=your.acblib       <=== ims acblib
//PSBLIB   DD DISP=SHR,DSN=your.psblib       <=== ims psblib
//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=*                                                         
//IEFRDER  DD DISP=SHR,DSN=your.hrf.iefrder  <=== online-reorg log             
//IHCSYSIN DD *                                                                
  CONVERT  ONLINE(Y) -                                                         
           DBDPATT(*****...) DSNPREF(DBSMS.DB) -                               
           DBD(xxxx) -                                                         
           PARTNUM(2) -                                                        
           ICMID(3) -                                                          
           ICHLQ(DBSMS.DB.IC) -                                                
           ICTRLR(2) - 
           IC.COMP(Y) -              
           IC.COMPRTN(FABJCMP2) - 
           PTRCHECK(Y)