IBM United States
Software Announcement 202-102
April 30, 2002
IBM DB2 for Multiplatforms Extended with New and Enriched Tools
(Corrected on October 14, 2002)
Following the heading New Tools, changed DB2 HPU Version to V2.1, and
following the heading DB2 PE Delivery Staging, removed "simulation."
At a Glance
For ordering, contact:
Your IBM representative, an IBM Business Partner, or IBM Americas Call Centers at 800-IBM-CALL (Reference: YE001).
IBM is again extending customers' DB2® solutions on multiplatforms by offering more tools for Microsoft Windows®, HP-UX, Sun's Solaris operating environment, AIX®, and Linux.
In September 2001, IBM delivered "application" tools designed to expand DB2 Universal Database® (UDB) across multiplatforms with the introduction of DB2 Web Query Tool for Multiplatforms V1.2 and DB2 Table Editor for Multiplatforms V4.2. Enriched releases of these products are now available and IBM is also adding three new significant operational tools to its multiplatform portfolio. The new and enriched capabilities extending the DB2 solution include:
These products will operate on any hardware and software configuration that supports the required version of a DB2 Server.
Planned Availability Dates
Electronic Media Product Delivery Packs High 07/26/2002 09/06/2002 Performance Unload Recovery 09/27/2002 12/06/2002 Expert Performance 07/26/2002 09/27/2002 Expert Table Editor 07/26/2002 09/06/2002 Web Query 07/26/2002 09/06/2002 Tool
DB2 High Performance Unload (DB2 HPU) for Multiplatforms V2.1
DB2 HPU gives customers a fast and efficient tool for unloading and extracting data for movement across the enterprise or for reorganization in-place. The product delivers high levels of parallelism and distribution of data across multiple logical nodes. DB2 HPU supports DB2 Enterprise Edition (EE) and DB2 Extended Enterprise Edition (EEE) thus supporting SMP and massively parallel processing (MPP) hardware configurations. It processes multiple select statements at the same time so that multiple requests of the DB2 UDB will be processed in a single scan of the table.
DB2 HPU also has the capability to:
DB2 HPU can be used as the basis of a very high-speed reorganization, as
well as high-speed data movement. It supports DB2 V7, or later, running
on AIX, Windows, Linux, HP-UX, and Sun's Solaris operating environment.
Support for Linux, HP-UX, and Sun's Solaris operating environment will be
available on September 6, 2002.
DB2 Recovery Expert for Multiplatforms V1.1
Database administrators (DBAs) are constantly being challenged by demands for greater availability and timeliness of larger and larger volumes of data, data being maintained for increasingly complex and critical e-business applications. Margins for error are shrinking, as is the time available to recover from them. These conditions require new techniques and tools to stay operational. DB2 Recovery Expert for Multiplatforms (Microsoft Windows, HP-UX, Sun's Solaris operating environment, AIX, and Linux) is just such a tool, providing targeted, flexible, and automated recovery of database assets, even as systems remain online.
DB2 Recovery Expert provides an easy-to-use environment that even less experienced DBAs can successfully use to complete highly sophisticated and efficient recovery techniques in minimal time. Built-in "Self-Managing and Resource Tuning" (SMART) features provide intelligent analysis of altered, incorrect, or missing database assets including tables, indexes, or data and automate the process of rebuilding those assets to a correct "point-in-time," often without taking the database or business operations offline.
Log mining provides targeted, automated analysis of DB2 log files related to the database assets and activities you specify as most important. This technology provides the foundation for the DB2 Recovery Expert log analysis reports, used to pin-point changes to data. The result is a rapid capability for monitoring and auditing changes to data, a simple way to specify which data changes to roll back, and extremely rapid recovery of data to a desired point-in-time, with or without accompanying disaster recovery procedures.
DB2 Recovery Expert "mini-logs," also generated by the DB2 Recovery Expert log mining technology, introduce a new and efficient asset into the DBA's arsenal of recovery methods, reducing the time, effort, and storage needs required to carry out targeted recovery operations. Tuned to parameters set by the DBA, mini-logs are created from only the log records essential to the situation. In large disaster scenarios that may exceed the scope of the mini-log data, DB2 Recovery Expert intelligently falls back to using DB2 logs where absolutely required. In virtually any scenario, recovery operations are easier, more efficient, and far less obtrusive to administrative and business operations.
The DB2 Recovery Expert object repository adds a new dimension to object recovery by also making possible vastly simplified object version control. Whether restoring an incorrect index, replacing an accidentally dropped table, or simply returning a table structure back to a prior (and since lost) design, the object repository automates management of all elements crucial to database structure. DB2 Recovery Expert can intelligently merge mini-log, DB2 log, and object repository resources to bring back complete object structure and data to a desired prior state, and even recreate database objects to new locations with new object identifiers correctly translated. Recoverable object types include databases, tablespaces, tables, indexes, and data.
SMART Assistance Within a Productive Interface: DB2 Recovery Expert's SMART interface will select automatically appropriate recovery mechanisms based on input criteria. For example, recovering to a specific point-in-time can be accomplished with standard object recovery or with a backout of the database changes.
If the DBA chooses to use a backout method, the log analysis function can be invoked to first locate the data changes that should be backed out. DB2 Recovery Expert provides a simple, menu-driven interface that allows specification of the scope of data changes you want to view by dates, tablespaces, and tables. The format of these surveys enhances the administrator's ability to distinguish between ordinary and questionable data changes.
Users can drill down and drill through from one report level to the next by clicking on hyperlinks. For example, starting at the summary report, you can click on the UPDATE keyword. This will show you a summary of all of the updates within the scope of the analysis. Scope parameters are echoed back to the user as well.
Once the set of changes that must be reversed (all or a subset) are identified, they may be easily undone by the DBA. Tight control over the specifications for any undo operation (down to the unit of recovery ID (URID) and table level) allows recovery from nearly any scope of improper changes, with far more precise results than are possible with a typical restore, and in much less time.
Redo operations are carried out with equal ease and precision. Whether copying changes to another database or adjusting a large scale undo operation, the log analysis function generates the necessary SQL that is sent to a file for execution by any method preferred by the database administrator.
Some of the data change reporting features that are available in this scenario are:
Had the DBA elected to follow an object restore method, objects could be presented in several views: for example, sorted by name or only displaying dropped objects. Then a group of functions is made available (optionally along with data recovery functions), to perform recreation and "housekeeping" operations, including:
Recovering Structure, Maintaining Integrity: A key strategic advantage of DB2 Recovery Expert for the enterprise is its reliability in handling and maintaining logical structures essential to database integrity.
For example, when a database has been deleted, the corresponding tablespaces, tables (files), and indexes are also deleted. Similarly, when tablespaces, tables, and indexes are dropped, whatever structures underlie them in the hierarchy (database, tablespaces, tables, and indexes) are also dropped.
Object restoration not only restores dropped objects, it also restores
related dependencies. It rebuilds automatically the structure of
dependent objects when an object higher in the hierarchy is restored.
For example, restoration of a table also restores that table's indexes.
Similarly, when restoring database objects and data from a backup and
log records, DB2 Recovery Expert appropriately translates the internal
object IDs for the recreated objects. With this technology, data can be
restored to new locations (with the re-mapping of internal identifiers).
DB2 Performance Expert for Multiplatforms V1.1
DB2 Performance Expert for Multiplatforms offers a comprehensive view that consolidates, reports, analyzes, and recommends changes on DB2 performance related information. DB2 Performance Expert (DB2 PE) can selectively employ and integrate the view from all "trace" sources, snapshot, and event outputs. Plus, it provides online snapshot reports, a buffer pool analyzer and reporting facility, and can selectively store performance data in its own managed performance data warehouse intended for further study and evaluation at the detailed and "rolled up" level. With its starter set of SMART capabilities, DB2 PE also gives you recommendations for system tuning to gain optimum throughput.
DB2 PE gives you a state-of-the-art workstation user interface (UI). The UI simplifies DBA tasks by providing a common tool's UI across DB2 server platforms, thus reducing the training requirements for DBAs across these platforms. The UI can be started stand-alone or launched via a plug-in from the DB2 Control Center.
DB2 Performance Expert for Multiplatforms supports DB2 Universal Database on Microsoft Windows, HP-UX, Sun's Solaris operating environment, AIX, and Linux.
The DB2 PE output gives you valuable hints on potential performance problems and useful assistance for corrective and preventive measures. The Online Monitor observes and records selected activities within DB2 and DB2 applications. The user-defined exception processing can recognize significant deviations from the norm and notify the user who is working with the Online Monitor.
The reporting facility presents performance information about details of events in reports, graphs, and data sets. The system-wide performance data shows information about CPU times, buffer pool usage, locking, I/O activity, and more. For a particular application, you can find out, for example, the:
DB2 PE Warehouse: As well as being viewed interactively, the performance data gathered can be saved automatically in a system maintained performance data warehouse. Additional analytical analysis can be performed on the time series data looking for trends, growth or potential problems.
DB2 PE Buffer Pool Analyzer: Buffer pools are considered among the most valuable components of a relational database system. To obtain information on current buffer pool behavior, DB2 PE Buffer Pool Analyzer collects data and provides detailed reports on related event activity. It can provide these reports in the form of tables, pie charts, and diagrams.
Dependencies: The product is supported on any processor capable of operating DB2 UDB V7, or later. The product requires the DB2 UDB for Linux (I32 and z/OS), AIX, Microsoft Windows, HP-UX, Sun's Solaris operating environment, DB2 V7, or later.
DB2 PE Delivery Staging: The delivery of the DB2 PE will be staged. For the customers wanting to "get going early," there is an electronic delivery, starter set. In September, IBM delivers a more complete product. With the first "fixpack," the final increment of Release 1 functionality is delivered.
The initial electronic (only) availability of DB2 Performance Expert for Multiplatforms V1.1 is July 26, 2002. This will deliver the initial starter set of function (stage 1). This will include:
In September 2002, we will deliver the "CD-ROM" of DB2 Performance Expert for Multiplatforms V1.1 (stage 2) available with full media packaging. This will include:
In December 2002, we will deliver fix pack 1 for the DB2 Performance Expert for Multiplatforms V1.1 (stage 3). This will include:
Refer to the
These programs are not impacted by euro currency.
DB2® Table Editor for Multiplatforms V4.3
DB2 Table Editor for Multiplatforms supports AIX®, Linux, Windows®, HP-UX, and Sun's Solaris operating environment platforms. This means that the tool can access DB2 data that resides in databases on all these platforms. DB2 Table Editor lets you easily support your business processes, and empower novice end users, with customized task-specific table editing forms. It gives your database experts a robust set of tools to perform ad hoc table editing tasks across multiple databases and platforms. Since end users only need a browser, the solutions you choose to create with DB2 Table Editor have maximum reach.
DB2 Table Editor makes it possible to provide direct DB2 database access to anyone for creating, reviewing, or updating data. Task-specific forms that are restricted to specific data and actions can be quickly built and rolled out to novice end users, and an expert interface can be used for browsing existing databases and ad hoc actions. A Java-enabled browser is all that is needed on the client machine for using DB2 Table Editor solutions.
Wizards and a drag-and-drop Windows environment let you quickly develop table editing forms, which are like mini-applications suitable for a wide variety of common business tasks. Data filtering, business and data access rules, database connections, command buttons, and dialogs are embedded directly in the forms (which can be optionally placed in existing Web pages) so end users can focus on their work instead of database technicalities.
DB2 Table Editor supports multiple database platforms, mission-critical DB2 features such as existing DB2 security and referential integrity, and advanced DB2 features like large object support. Customers who need to safely provide data editing and data entry capabilities to end users at the front lines of a business or to database administrators will find DB2 Table Editor a valuable offering. IBM also offers DB2 Table Editor for z/OS and DB2 Table Editor for IBM iSeries. To access DB2 data on z/OS, you need DB2 Table Editor for z/OS and to access DB2 data on iSeries, you need the DB2 Table Editor for iSeries. All the DB2 Table Editors are licensed by data platform where the database data exists.
Now with V4.3, customers will also get:
DB2 Web Query Tool for Multiplatforms V1.3
When any part of your business operations require faster, more creative, or more complex data operations, DB2 Web Query Tool is the authoring environment to turn to. The Web Query Tool software's advanced SQL functionality extracts the full performance out of DB2 databases while making it easy for users at all levels to access enterprise-wide data. Wherever data access and data integration can bring value, DB2 Web Query Tool can deliver that value.
DB2 Web Query Tool for Multiplatforms supports AIX, Linux, Windows, HP-UX, and Sun's Solaris operating environment platforms. This means that the tool can access DB2 data that resides in databases on all these platforms. IBM also offers DB2 Web Query Tool for z/OS and DB2 Web Query Tool for iSeries. To access DB2 data on z/OS, you need DB2 Web Query Tool for z/OS and to access DB2 data on iSeries, you need the DB2 Web Query Tool for iSeries. All the DB2 Web Query Tools are licensed by data platform where the database data exists. Each DB2 Web Query Tool includes servlets that run on all specifically supported Web servers. The Web server does not need to be on the same platforms as the database servers supporting the data to be accessed. DB2 Web Query Tool for Multiplatforms also allows you to access Informix data.
DB2 Web Query Tool for Multiplatforms supports DB2 V7, or later, on AIX, Linux, Microsoft Windows, HP-UX, and Sun's Solaris operating environment.
With Web Query Tool, customers can:
Now with V1.3, customers will also get:
Visit Web site:
Call IBM Education and Training at 800-IBM-TEACH (426-8322) for catalogs, schedules, and enrollments.
Product information is available through Offering Information (OITOOL) at:
No publications are shipped with these programs.
Displayable Softcopy Documentation: For DB2 Table Editor for Multiplatforms V4.3: A README.TXT file with information on how to install the product and the DB2 Table Editor Control Center Plug-in. Online HELP is included.
The following publications are not available in hardcopy form. They are available for download in PDF and BookManager® formats on the Web site at:
Order Title Number DB2 High Performance Unload SC27-1623 for Multiplatforms User's Guide DB2 Recovery Expert for SC27-1624 Multiplatforms User's Guide DB2 Performance Expert for SC27-1646 Multiplatforms Installation and Customization DB2 Performance Expert for SC27-1645 Multiplatforms Monitoring Performance from the Workstation DB2 Table Editor User's Guide SC27-1616 DB2 Web Query User's Guide SC27-0971
These products will operate on any hardware configuration that supports DB2 Enterprise Edition or Extended Enterprise Edition V7, or later.
Customer Responsibilities: Charges for each of these programs are based on the total number of processors from which the data being processed by the program originates, including any processors available to the database servers on which the data originally resides, and the processors available to the database servers to which the program is licensed. The total number of processors within database servers on which the data being processed by the program resides and which are attached or available to the program may not exceed the number authorized by the applicable Proofs of Entitlement or authorized by each product authorization acquired under Passport Advantage. If the total number exceeds the quantity in your Proofs of Entitlement or exceeds your product authorizations acquired under Passport Advantage, you must notify IBM or its reseller as stated in the IPLA.
Direct Customer Support: Direct customer support is provided by IBM Operational Support Services Support Line. This fee service enhances customers' productivity by providing voice and electronic access into the IBM support organization. IBM Operational Support Services Support Line will help answer questions pertaining to usage, and suspected software defects for eligible products.
Installation and technical support is provided by Global Services. For more information call 800-IBM-4YOU (426-4968).
Security, Auditability, and Control
The security and auditability features of User Identification and Password Management for these products are developed in concert with DB2 security.
The customer is responsible for evaluation, selection, and implementation of security features, administrative procedures, and appropriate controls in application systems and communication facilities.
Part Program Name Number DB2 High Performance Unload for BB042NA Multiplatforms V2.1 Media Pack DB2 Recovery Expert for BB043NA Multiplatforms V1.1 Media Pack Part Program Name Number DB2 Performance Expert for BB044NA Multiplatforms V1.1 Media Pack DB2 Table Editor for BB041NA Multiplatforms V4.3 Media Pack DB2 Web Query Tool for BB045NA Multiplatforms V1.3 Media Pack
Passport Advantage Program Name Number DB2 High Performance Unload for Multiplatforms DB2 HIGH PERF UNLOAD FOR MLTIPLTFMS D512ALL PROC LIC/SW MAINT 1 ANNIV DB2 HIGH PERF UNLOAD FOR MLTIPLTFMS D512BLL PROC LIC/SW MAINT 2 ANNIV DB2 HIGH PERF UNLOAD FOR MLTIPLTFMS E009HLL PROC SW MAINT RNWL 1 ANNIV DB2 HIGH PERF UNLOAD FOR MLTIPLTFMS D512CLL PROC SW MAINT AFT LIC 1 ANNIV DB2 Recovery Expert for Multiplatforms DB2 Recovery Expert for Mltipltfms Processor D512DLL LIC/SW MAINT 1 ANNIV DB2 Recovery Expert for Mltipltfms Processor D512ELL LIC/SW MAINT 2 ANNIV DB2 Recovery Expert for Mltipltfms Processor E009ILL SW MAINT RNWL 1 ANNIV DB2 Recovery Expert for Mltipltfms Processor D512FLL SW MAINT AFT LIC 1 ANNIV DB2 Performance Expert for Multiplatforms DB2 Prfrmnce Exprt for Mltipltfms Processor D512GLL LIC/SW MAINT 1 ANNIV DB2 Prfrmnce Exprt for Mltipltfms Processor D512HLL LIC/SW MAINT 2 ANNIV DB2 Prfrmnce Exprt for Mltipltfms Processor E009JLL SW MAINT RNWL 1 ANNIV DB2 Prfrmnce Exprt for Mltipltfms Processor D512ILL SW MAINT AFT LIC 1 ANNIV
Passport Advantage Program Name Number DB2 Table Editor for Multiplatforms DB2 Table Editor for Mltipltfms Processor D50R7LL LIC/SW MAINT 1 ANNIV DB2 Table Editor for Mltipltfms Processor D50R8LL LIC/SW MAINT 2 ANNIV DB2 Table Editor for Mltipltfms Processor E006ELL SW MAINT RNWL 1 ANNIV DB2 Table Editor for Mltipltfms Processor D50RBLL SW MAINT AFT LIC 1 ANNIV DB2 Web Query Tool for Multiplatforms DB2 Web Query Tool for Mltipltfrms Processor D50R4LL LIC/SW MAINT 1 ANNIV DB2 Web Query Tool for Mltipltfrms Processor D50R5LL LIC/SW MAINT 2 ANNIV Passport Advantage Program Name Number DB2 Web Query Tool for Mltipltfrms Processor E006DLL SW MAINT RNWL 1 ANNIV DB2 Web Query Tool for Mltipltfrms Processor D50R6LL SW MAINT AFT LIC 1 ANNIV
Entitled Maintenance Offerings Description DB2 HIGH PERF UNLOAD FOR MLTIPLTFMS PROC Part Media Packs Description Number DB2 High Performance Unload for BB042NA Multiplatforms V2.1 Media Pack Entitled Maintenance Offerings Description DB2 RECOVERY EXPERT FOR MP PROC Part Media Packs Description Number DB2 Recovery Expert for BB043NA Multiplatforms V1.1 Media Pack Entitled Maintenance Offerings Description DB2 PERF EXPERT FOR MP PROC Part Media Packs Description Number DB2 Performance Expert for BB044NA Multiplatforms V1.1 Media Pack Entitled Maintenance Offerings Description DB2 TABLE EDTR MLTPLTFRMS PROCESSOR Part Media Packs Description Number DB2 Table Editor for Multiplatforms BB041NA V4.3 Media Pack Entitled Maintenance Offerings Description DB2 WEB QRY TOOL MLTPLTF PROCESSOR Part Media Packs Description Number DB2 Web Query Tool for Multiplatforms BB045NA V1.3 Media Pack
Terms and Conditions
Licensing: IBM International Program License Agreement. Proofs of Entitlement are required for all authorized use. Part number products only, offered outside of Passport Advantage, where applicable, are license only and do not include Software Maintenance.
Charges for each of these programs are based on the total number of processors from which the data being processed by the program originates, including any processors available to the database servers on which the data originally resides, and the processors available to the database servers to which the program is licensed. The total number of processors within database servers on which the data being processed by the program resides and which are attached or available to the program may not exceed the number authorized by the applicable Proof(s) of Entitlement or authorized by each product authorization acquired under Passport Advantage. If the total number exceeds the quantity in your Proof(s) of Entitlement or exceeds your product authorizations acquired under Passport Advantage, you must notify IBM or its reseller as stated in the IPLA.
These five programs are only orderable under Passport Advantage. There are no Program Packages.
Passport Advantage: For Passport Advantage and charges, contact your authorized IBM Lotus® Business Partner. Additional information is also available on the Passport Advantage Web site:
Customer Financing: IBM Global Financing offers attractive financing to credit-qualified commercial and government customers and Business Partners in more than 40 countries. IBM Global Financing is provided by the IBM Credit Corporation in the United States. Offerings, rates, terms, and availability may vary by country. Contact your local IBM Global Financing organization. Country organizations are listed on the Web at:
Use Priority/Reference Code: YE001 Phone: 800-IBM-CALL Fax: 800-2IBM-FAX Internet: firstname.lastname@example.org Mail: IBM Atlanta Sales Center Dept. YE001 P.O. Box 2690 Atlanta, GA 30301-2690
You can also contact your local IBM Business Partner or IBM representative. To identify them, call 800-IBM-4YOU.
Note: Shipments will begin after the planned availability date.