D Task Archival

You run this utility to archive the task data. When you run this utility, data is transferred from the active task tables to the new archival tables. As a result, extracting active task data takes less time and the performance improves.

This appendix discusses the following topics:

Location and Components
Oracle Identity Manager Task Archival Functionality

D.1 Location and Components

All Oracle Identity Manager Task Archival files are located in the PATCH/db/oracle/Utilities/TaskArchival directory when you are using Oracle Database. Table D-1 provides details of the files that are part of the Oracle Identity Manager Task Archival utility:

Table D-1 Task Archival Files

File	Description
cr_taskarchival_ddl_table.sql	Creates the OIM_TASK_ARCH_DDL table. This table is used by the Task Archival utility, which calls the OIM_SP_TASKS_ARCHIVAL stored procedure to store the DDL statements that are generated when the tool archives or deletes the tasks data.
Create_TasksArch_Tables.sql	Creates the arch_* tables that have the same structure as the active tasks tables. In addition, this script afds a primary key to tables.
OIM_SP_TASKS_ARCHIVAL.sql	Archives task data into the task archival tables and deletes the archived data from the active task tables.

D.2 Oracle Identity Manager Task Archival Functionality

To use the Task Archival utility, run the following script:

For Microsoft Windows: OIM_TasksArch.bat

For UNIX: OIM_TasksArch.sh

After you run the script, a log file is generated with the following name:

For Microsoft Windows:

If the utility runs without error:
```
Arch_Tasks_YYYY_MM_DD_HH_MM.log
```
If running the utility generates an error:
```
Err_Arch_Tasks_YYYY_MM_DD_HH_MM.log
```

For UNIX:

If the utility runs without error:
```
Arch_Tasks_YYYY_MM_DD_HH_MM.log
```
If running the utility generates an error:
```
Err_Arch_Tasks_YYYY_MM_DD_HH_MM.log
```

D.2.1 Authentication

When you run the script, you are prompted to enter the following information:

Name of the Oracle home directory
Database name
User name
Database password

The utility permits only three connection attempts.

D.2.2 Functionality

The following options are present in the Task Archival utility main menu:

Archive all the provisioning tasks on resource instances, which have been revoked for disabled/deleted users
Archive all the provisioning tasks on resource instances, which have been revoked
Archive all the approval tasks in which the request status is Request Complete/Request Cancelled/Object Approval Complete
Exit