Archive and Purge Processes

The following table lists system background processes used in conjunction with the Archive Engine. Note that the DB process that represents an archive or purge procedure defines the batch control used for the first step of a purge or archive. Although, the CIPYCPRB program (used universally for the first step of any archive or purge procedure) is delivered with the system, there are no system batch controls that reference it. It is included in this list for clarity.

Fastpath:

For information on how to copy sample Archive and Purge DB processes from the demonstration database, refer to How To Copy Samples From The Demonstration Database.

Batch Control ID

Program Name

Description

Multiple Threads

Extra Parameters

Records Between Commits / Minutes Between Cursor Re-Initiation

Special - Each archive or purge procedure defines its first step's batch control.

CIPYCPRB

The first step of any archive or purge process is to create primary archive roots objects.

Note that for Purge DB processes, the environment reference batch parameter is optional.

Refer to Archive Engine for more information.

Yes

ENV-CODE = environment reference of the target archive environment.

TEST-MODE (Y/N) = If Y is specified, the program will write out information about primary roots to a log file.

200/15

AR-CRCHR

CIPYCRCB

The second step of any archive or purge process is to create child archive roots objects.

Note that for Purge DB processes, the environment reference batch parameter is optional.

Refer to Archive Engine for more information.

Yes

ENV-CODE = environment reference of the target archive environment.

DB-PROC-CODE = The archive or purge DB process that specifies the batch control used to create primary archive root objects (step 1 of any archive or purge).

MAX-ERRORS

200/15

AR-PRFK

CIPYRFKB

The third step of any archive or purge process is to check recursive foreign key relationships.

Note that for Purge DB processes, the environment reference batch parameter is optional.

Refer to Archive Engine for more information.

Yes

ENV-CODE = environment reference of the target archive environment.

DB-PROC-CODE = The archive or purge DB process that specifies the batch control used to create primary archive root objects (step 1 of any archive or purge).

MAX-ERRORS

AR-DCDT

CIPYPARB

The fourth step of any archive or purge process is to move data to the target archive environment (in the case of an archive), or simply delete it (in the case of purge).

Note that for Purge DB processes, the environment reference batch parameter is optional.

Refer to Archive Engine for more information.

No

ENV-CODE = environment reference of the target archive environment.

DB-PROC-CODE = The archive or purge DB process that specifies the batch control used to create primary archive root objects (step 1 of any archive or purge).

MAX-ERRORS

200/15

AR-DCDTF

CIPYCARB

If desired, this background process may be run instead of AR-DCDT (above). This process calls the Archive Copy Processing algorithm specified on the DB Process Instruction to copy the data to a flat file instead of an archive environment.

Note that for Purge DB processes, the environment reference batch parameter is optional.

Refer to Archive Engine for more information.

Yes

ENV-CODE = environment reference of the target archive environment.

DB-PROC-CODE = The archive or purge DB process that specifies the batch control used to create primary archive root objects (step 1 of any archive or purge).

MODE = C (Copy data only), D (Delete records only), or B (Both copy and delete). The default is B (Both).

MAX-ERRORS

200/NA