A reference guide for archiving and restoring data.
Introduction to archiving
The IBM® InfoSphere® Optim™ Data
Growth Solution helps 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 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 prepare the contents of source
file (an archive or extract file) for a particular DBMS loader. If
wanted, you can also start the corresponding database load utility.
Report
Using the report process, you can 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. Together, archive directory entries and indexes
support your ability to search or restore archive files. You can also
use directory entries to create archive file collections, which allow
you to logically union entries as a single data source for access
with open data manager (ODM).
Manage archive media
You can automatically manage archive files using a storage
profile to create duplicate copies, save secondary copies to a backup
device, and provide a date when the primary archive file is automatically
deleted. Generally, an archive process generates a single file that
is saved to fixed media (for example, a local hard drive or network
drive) where it resides indefinitely. Absent a storage profile, you
must manually perform all management of the file (for example, copying,
deleting, saving to a backup device).
Performance Tuning Strategies
Use the following strategies to configure your Optim solution and your database so that archive,
delete, and extract, insert, and load 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, File, and Index 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.