Chapter 2. Overview of InfoSphere Warehouse Advanced Edition 23
2.1.15 InfoSphere Optim High Performance Unload
InfoSphere Optim High Performance Unload is the ultimate tool for unloading,
extracting, and repartitioning data from DB2 databases. Data migrations can now
be performed with minimal effort, a high degree of accuracy, and within shorter
time frames.
The ability to apply filters to the data source allows precise and targeted unloads,
while allowing the database to remain online and available to applications. This
utility can also extract tables and data from incremental, delta, and full backup
images, allowing rapid data restores in response to accidental table drops and
data deletion.
With the ability to bypass the DB2 engine and work directly on the data stored on
disk, there is minimal impact on database performance. Repartitioning, an
important element of data warehousing, is supported by performing both unloads
and splits within a single operation.
2.1.16 InfoSphere Optim Configuration Manager
Driven by the need to eliminate costly outages caused by human mistakes, and
to bring order to their database environments, many business have developed
costly in-house tools for the management of their database environments.
InfoSphere Optim Configuration Manager provides an improved solution to this
dilemma.
This tool provides a means for gathering information about database and client
configurations and centralizing this information, to create a more manageable
and effective infrastructure. InfoSphere Optim Configuration Manager also tracks
changes to database and client configurations, thereby helping to resolve the
causes of performance degradation, or help in delivering a constant database
structure over multiple database implementations. It can also be used in the
delivery of database migrations to new hardware or from earlier versions of DB2.
Administrators can modify properties of deployed database clients to improve
database transaction performance, enforce security and privacy controls, and
allocate data clients among data servers to balance workloads.
From InfoSphere Optim Configuration Manager’s web interface, database
administrators can enforce common client configurations, while also tracking
underutilized storage resources. When combined with DB2 compression and
Note: Optim High Performance Unload is executed exclusively from the
command line.
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.