Chapter 2. Overview of InfoSphere Warehouse Advanced Edition 59
In this context, both the Design Studio and the DIS runtime write the required
commands into a temporary file and then execute a call to the DB2 Client with
the request to read and process the commands found within this file.
򐂰 InfoSphere Warehouse wh command
The InfoSphere Warehouse common client product set comes with an
additional command line utility called wh. This utility has been developed to
allow deployment, configuration, and running of SQW flows and resources
within the InfoSphere Administration Console from the command line.
򐂰 DB2 Merge Backup
This is a command-line utility that can merge full or incremental DB2 backups
to build a new full backup. This utility can be executed remotely from the
actual DB2 server machine to free server resources. DB2 Merge Backup
uses the DB2 database history to determine which backups to merge. Then
DB2 Merge Backup accesses these backups and builds a new full backup
that contains relevant information from the source backups.
򐂰 Optim High Performance Unload
This utility performs high-speed, bulk data unloads for DB2 databases. It is a
stand-alone utility program that can be executed while the DB2 database
manager is running, and can access the same physical files as the DB2
database manager. It can also operate in a stand-alone mode and as a DB2
stored procedure.
The benefits of Optim High Performance is that it will allow extraction even if
the DB2 instance is down, and also can perform extractions on a different
system.
2.3 InfoSphere Warehouse implementation scenarios
In this section, we discuss a common set of topologies that can be implemented
to create a complete InfoSphere Warehouse environment. With the large number
of products included within InfoSphere Warehouse Advanced Edition, there can
ultimately be a large number of permutations of how all these products can be
installed.
Here we present the most common scenarios. To simplify the discussion, we
divide the solution into two sections. The first section focuses on components
that make up the core of an InfoSphere Warehouse environment, and that are
shipped with all versions of the product. The second section focuses on the tools
and utilities that only come as part of the Advanced Edition.

Get Solving Operational Business Intelligence with InfoSphere Warehouse Advanced Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.