Operations › Operational Flow and Considerations › Summary of Procedures for Operating CA IDMS/DB Reorg

Summary of Procedures for Operating CA IDMS/DB Reorg

1. Back up database.
2. Define new subschema.
3. Use IDMSBCF to allocate and format COPY areas in new subschema. (Can be done any time before STORE.)

   Note: If you do not use DSPLYINT=NO, inform your system console operatorof the valid reply options. CA IDMS/DB Reorg operates with an outstanding operator reply. See DSPLYINT Parameter.

4. Allocate Space for CNTRL1/CNTRL2. Analysis step.

      PROCESS,
      OLDSUB=subschema-name,
      NEWSUB=subschema-name,
      OLDDMCL=dmcl-name,
      NEWDMCL=dmcl-name,
      STOPAFTER=ANALYSIS
      COPY,
                 AREA= area-name
   

   1. First PROCESS stops here.
5. Allocate space for work files. OPTALLOC Step.

   If sufficient disk space is not available for any file, it may be assigned to tape (except PAGUTIL). Use information from CA IDMS/DB Reorg Audit Report, from reports by CA IDMS/DB Analyzer. In z/OS or OS/390, use IEFBR14 for deleting and allocating work files.

      PROCESS,
      OLDSUB=subschema-name,
      NEWSUB=subschema-name,
      OLDDMCL=dmcl-name,
      NEWDMCL=dmcl-name,
      STOPAFTER=CURRENT
   

   1. Second Process stops here.
6. If sorted indexes are to be updated, allocate space for three work files. Use information from the OPTALLOC statistics to estimate space for IIXEXOL, IIXSRKY, and IIXEXTR.

      PROCESS,
      OLDSUB=subschema-name,
      NEWSUB=subschema-name,
      OLDDMCL=dmcl-name,
      NEWDMCL=dmcl-name,
      RESTART=NEXT,
      STOPAFTER=UPDLINK
   
    PRIALLOC Step
    SECALLOC Step
    MATCH Step
    IIXSDBK Step
    UPDLINK Step
   

   1. Third PROCESS stops here.
7. If not done previously, use IDMSBCF to allocate and format COPY areas in new subschema. (Can be done anytime before STORE.)

   PROCESS,
       OLDSUB=subschema-name,
       NEWSUB=subschema-name,
       OLDDMCL=dmcl-name,
       NEWDMCL=dmcl-name,
       RESTART=NEXT,
   

   STORE Step

   Note: If you are using CA IDMS/DB Reorg to change page ranges for one or moreareas, and the old and new databases are defined in different DMCL's:

8. Run CA IDMS/DB Reorg in Step mode.
9. All steps prior to the STORE step must specify the 'olddmcl' in the SYSIDMS parameters.
10. The STORE step must specify the 'newdmcl' in the SYSIDMS parameters.