Which AREAs have to be included in an unload/reload of an SQL defined database

Products

• IDMS
• IDMS - Database
• IDMS - ADS

Issue/Introduction

When running an unload/reload of an SQL-defined database, particular care must be taken regarding the required AREAs.

Failure to do this could result in an 0966 abend.

 

Environment

Release:
Component: IDMS

Resolution

When running an unload/reload of an SQL-defined database, you specify the areas you want to unload/reload in the input syntax (SYSIPT) in just the same way as you would for a non-SQL-defined database.

That is, you include the AREAs to be unloaded in the UNLOAD statement. E.g.:-

UNLOAD SEGMENT PROJSEG   AREA PROJAREA   RELOAD INTO PROJSEG      DMCL RELDDMCL; 

However, regardless of which areas are being unloaded, *all* of the areas in the segment must be made available to the reload job. They must be offline to any CV in which they are included, or in RETRIEVAL mode if they are not actually being updated by the RELOAD.