Split and merge processing (CTTSPL)

The split and merge process is the method by which information is extracted (split) from one Media database and inserted (merged) into another Media database (usually at a different site). This process is especially useful when a decision is made to join two Media databases or to split a large Media database in two or more smaller Media databases.

The split and merge process is performed using the CTTSPL and CTTMER utilities.

• The CTTSPL utility extracts records from the source Media database according to specified selection criteria. This utility can be used with either of two functions.

  Table 379 CTTSPL functions

  Function	Description
  MOVE	Moves selected records to the extract file and deletes them from the source Media database
  COPY	Copies selected records from the source Media database to the extract file. The source Media database is not altered when this function is specified.

  The output of the CTTSPL utility (the extract file) is a predefined sequential file (&OLPREFT.REPDATA) allocated as one of the Control-M/Tape operations libraries at time of Control-M/Tape installation.

• The CTTMER utility merges the extracted Media database records into the Media database in the target system. The CTTMER utility uses the extract file created by CTTSPL, as input.

If the CTTSPL utility is being used to move (not copy) Media database records, the selected records are deleted from the source Media database.

If the target Media database is in a different site, the extract file (REPDATA) produced by the CTTSPL utility must be transferred to the target site.