Optim Directory

The Optim™ Directory is a set of tables in which Optim stores objects needed for processing and tracking processing status. Before using Optim, you must use the Configuration program to create or configure the Optim Directory tables and stored procedures needed to access the Directory.

See the Installation and Configuration Guide for more information.

Note: For Teradata, you cannot create the Optim Directory in a Teradata database, so you must create the Optim Directory in another supported database, such as Oracle or DB2® with a Federation Server instance; and the DB Alias in that database must point to the Teradata database.

Important Optim Directory objects include the following:

DB Aliases
A DB Alias provides parameters needed to connect with a specific database. It is used as a high-order qualifier for an object or table name and tells Optim how to access the appropriate database.
Access Definitions
An Access Definition identifies the set of related data to be processed by Optim. It identifies the database tables and their relationships, and provides criteria to select specific rows within tables.
Table Maps
A Table Map defines the correlation between two tables or sets of tables in an Insert, Update, Restore, or Compare Process and can be used to exclude one or more tables from processing.
Column Maps
A Column Map defines the correlation between columns in two tables. Additionally, a Column Map can be used to transform data, age dates in tables, and exclude one or more columns from processing.
Column Map Procedures
A Column Map Procedure is a custom program that is referenced by a Column Map and is used for special processing and data manipulation that is beyond the scope of native Column Maps.
Primary Keys
Values in primary key columns uniquely identify each row in a database table.
Relationships
A Relationship determines the parent or child rows to be processed and the order in which they are processed.
Processing Definitions
A Processing Definition provides parameters needed to run a process, including the names of generated files, the Access Definition used for the process, and the source of processed data. You can sometimes use parameters in a process definition to override parameters defined for the Access Definition. Process definitions include the following Request types: Archive, Compare, Convert, Delete, Edit, Extract, Insert, Load, Report, and Restore.
Utility Definitions
A Utility Definition is used for some type of specialized processing. Utility definitions include: Calendars, Storage Profiles, and Currency Tables.
Security Definitions
A Security Definition provides parameters needed for Optim Security.
  • Access Control Domains (ACDs) map roles to network accounts.
  • The (Default) ACD provides Functional Security parameters.
  • Access Control Lists (ACLs) provide parameters used with Object Security.
  • File Access Definitions (FADs) provide parameters used with Archive File Security.
Archive File Registrations
Archive File Registrations provide all information needed to locate and process data on archive files.

After one or more Optim Directories are created, you can use the Optim Directory Editor to:

Contents

This section describes the specifications on the Optim Directory Editor.