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.
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 |
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). |
200/15 |
|
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). |
||
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). |
200/15 |
|
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). |
200/NA |
Copyright © 2011, Oracle and/or its affiliates. All rights reserved.