InfoSphere Optim for z/OS Common Elements reference
A reference guide for InfoSphere® Optim™ for z/OS®.
Introduction
IBM® Optim for z/OS manages enterprise data throughout every stage of the information life cycle. Optim enables you to assess, classify, subset, archive, store, and access enterprise application data.
Access Definitions
An Access Definition defines a set of related data to be processed by Optim.
Primary Keys
A primary key is the column or columns that contain values that uniquely identify each row in a table.
Relationships
A relationship is a defined connection between the rows of two tables. To support a relationship, DB2® requires a parent table primary key of 1 to 64 columns that guarantees uniqueness. DB2® also requires that each child table have a corresponding foreign key made up of the same number of columns. In addition, corresponding primary and foreign key columns must have identical data types and attributes.
Column Maps
A Column Map provides specifications needed to direct data from source columns to destination columns, match pairs of columns from separate tables for a Compare Process, or exclude columns from processing. You can use a Column Map for a pair of tables regardless of Creator ID or table name.
Data privacy providers
The data privacy providers are a code base of masking functions common across multiple platforms and interfaces. You can call the data privacy providers directly from a column map.
Table Maps
A Table Map provides specifications needed to direct data from source tables to destination tables, match pairs of tables for a Compare Process, or exclude tables from processing. A Table Map may also reference a Column Map for a pair of tables in the Table Map to pair columns with different names or attributes, generate column data, or eliminate individual columns from processing.
Convert Archive and Extract Files
The Convert Process transforms data in an Extract or Archive File. This converted file can be used as input to most Optim processes. However, since a converted file does not include object definitions needed to recreate the database, it cannot be used to create objects, and your ability to browse a converted Extract or Archive File in Table Mode is limited.
Retry/Restart a Process
If Insert, Delete, or Restore processing fails for some reason, you can retry or restart a process. You can retry a process when one or more rows are discarded during the process (for example, when you attempt to insert or restore child rows and the parent rows are not in the database). You can restart a process that does not execute to completion (for example, a process can terminate abnormally when the allocated time or space resources are insufficient, or the user ends the process prematurely).
Browse Related Data
While using the Browse and Point-and-Shoot facilities, you can join data in related tables and use various techniques to manage the display while viewing the data. Then you can join related rows from multiple tables and manage the display of data according to your needs. While browsing Extract or Archive Files or using the Point-and-Shoot facility, you can also create a report about the contents of the display.
Options
Several types of options are available to manage the functions performed while using Optim.
Performance
You can configure Archive as well as your database so that Archive, Restore, and Delete Processing are as efficient as possible. The configuration strategy you choose depends on your needs and the constraints of your database processing. This chapter provides some general strategies that you can employ to meet your specific performance needs.
Sample Database Tables and Structure
The sample database, created during installation of Optim, is described in this Appendix. As a group, the database tables include information on customers, orders, shipping instructions, and so on.
Allocating External Files
Optim requires several types of files, depending on the component you are using and the process you are performing.
Create a Row List File
The Point-and-Shoot facility is used with Archive, Compare, or Move to select the primary key values for rows in the Start Table when you want to extract data from a database or restore it to a database. These values are automatically stored in a Row List file.
Compatibility Rules
When you define an Optim relationship or a Column Map, corresponding columns must be compatible.
Optim Exit Parameter Lists
Before compiling each Security Exit, Column Map Exit, Archive Exit, or API, locate and edit the corresponding parameter list, indicated by the DSect name.