A reference guide for archiving and restoring data.
Introduction to Archive
The Archive component of the IBM InfoSphere™ Optim solutions allows you to extract sets
of relational data from one or more databases and store the data for
future use.
Processing Flow
An effective archiving strategy can help you streamline
your databases to improve database performance and reduce costs associated
with expensive upgrades. Archive can archive complex relational data
quickly and accurately, while providing access to archived data —
referentially intact and complete.
Archive
Use the Archive Process to select a precisely defined set
of related rows from a database and save the rows to an external Archive
File.
Delete
Use the Delete Process to remove subsets of related data
from a database. The Delete Process uses an Extract or Archive File
to identify the set of rows to be removed. Specifications for the
Delete Process can be stored as a Delete Request.
Insert
Use an Insert Process to insert data from an Archive File
or Extract File into a destination database.
Load
Use the Load Process to transform the contents of an Archive
or Extract File into a format that is appropriate for a particular
DBMS loader and then, if desired, start the corresponding database
load utility.
Report
Using the Report Process, you may create a report on the
contents of an Archive or Compare File or list Archive Directory entries
that meet criteria you supply.
Restore
Use the Restore Process to select data from one or more
Archive Files and restore the data to the original or to a different
database.
Archive Maintenance Utilities
To access archived data, you must be able to find it. By
organizing Archive Files using purposeful conventions and implementing
well-conceived indexing, you lay the groundwork for efficient searches
of archived data.
Manage Archive Media
You can automatically manage Archive Files using a Storage Profile. It allows you to create a duplicate copy of an Archive File, save a secondary copy of the Archive File to a backup device, and provide a date when the primary Archive File is automatically deleted.
Archive Performance
Use the following strategies to configure Archive and your
database so that Archive and Delete Processing are as efficient as
possible.
Command Line Interface — Processing Utilities
The Archive command line interface allows you to perform
Archive tasks without using the graphical user interface for Archive.
You can use the command line interface to archive or restore archived
data programmatically.
Command Line Interface — Maintenance Utilities
The command-line interface allows you to automate Archive
Directory and File Maintenance functions without using the graphical
user interface. You can also use the command line to migrate Archive
Files from one storage device or platform to another, a process that
is unavailable from the graphical user interface.
SQL Grammar for Search and Restore
When you use selection criteria or SQL statements to find
specific data in an Archive File, the syntax and grammar may differ
slightly from SQL syntax and grammar you are accustomed to using with
a particular DBMS.
ODBC Access to Archived Data
Database client technologies such as ODBC (Open Data Base
Connectivity) provide a uniform interface for writing client software
for relational databases.