Staging data sets and the data set rename process

If you need to preallocate or define the staging data sets, use the original Db2 data set names as a starting point, but replace the DSNDBC and DSNDBD nodes with BMCDBC and BMCDBD. 

After writing the loaded objects to the staging data sets (named as shown in the Naming conventions for staging data sets for the rename process table), LOADPLUS renames the data sets by using the following process. The Data set rename process figure illustrates this process.

1. LOADPLUS prevents all access to the objects and renames the original Db2 VSAM data sets by replacing DSN in the DSNDBC node of the cluster and in the DSNDBD node of the data component with OLD.

   Warning

   Important

   LOADPLUS terminates if the following data sets already exist:

   VCAT.OLDDBC.database.tableSpace

   VCAT.OLDDBD.database.tableSpace

   This part of the process makes the original data sets obsolete.

2. LOADPLUS renames the staging data sets by replacing BMC in the BMCDBC node of the cluster and in the BMCDBD node of the data component with DSN.

   This step gives the staging data sets the same name as the original data sets, even though they are in a new location.

3. After successfully renaming the data sets, LOADPLUS starts the objects with their original statuses.
4. The next step depends on the value for the ORIGDISP or ORIGINALDISP option:
   • If the value for the ORIGDISP or ORIGINALDISP option is DELETE, LOADPLUS deletes the now-obsolete original data sets.

   • If the value for this option is RENAME, LOADPLUS renames the original data sets to the staging data set names by replacing OLD with BMC.

     RENAME preserves the space that was initially allocated for the original data sets. As a result, the staging data sets are ready to be used with the next load job that uses staging data sets.