IBM United States
Software Announcement 201-157
May 15, 2001
IBM DB2 Warehouse Manager for iSeries Business Intelligence Infrastructure Upgraded to Version 7 Release 2
(Corrected on June 12, 2001)
Changes were made to the following sections: Software Requirements,
changed second bullet; Technical Limitations, added a third bullet on
warehouse function; Ordering Information, deleted one part number and
added others; and changed IBM Operational Support Services Support
Line to "Yes".
At a Glance
DB2 Warehouse Manager for iSeries Version 7 Release 2 introduces the following key enhancements:
For ordering, contact:
Your IBM representative, an IBM Business Partner, or IBM Americas Call Centers at 800-IBM-CALL (Reference: AE001).
DB2® Warehouse Manager for iSeries Version 7 Release 2 gives you flexible, easy-to-use tools and techniques for building, maintaining, managing, and accessing your data warehouse. It provides an infrastructure upon which packaged business intelligence applications and tools can be built. DB2 Warehouse Manager for iSeries simplifies and speeds warehouse prototyping, development, and deployment.
Data warehousing is the foundation for business intelligence and customer relationship management. To leverage your data effectively, DB2 Warehouse Manager can help you:
DB2 Warehouse Manager for iSeries will provide you with better:
The DB2 Warehouse Manager for iSeries also gives you pre-built transformers for statistical functions and warehouse transformations that will relieve your staff from programming these powerful functions, saving valuable time, resource, and development testing.
DB2 Warehouse Manager for iSeries includes:
iSeries V4R4, or later
You Can Start Data Warehousing Today
Data warehousing is the foundation for business intelligence and customer relationship management so it's important to do it correctly. That means:
If you're thinking you don't have the time or resources to handle that, DB2 Warehouse Manager for iSeries Version 7 Release 2 can help. It provides a rich graphical environment for creating and managing high-performance, scalable DB2 data warehouses right from within your DB2 Control Center. Once you have your data warehouse in place, DB2 Warehouse Manager provides flexible, easy-to-use tools to access the data warehouse and to govern and track its usage.
DB2 Warehouse Manager for iSeries includes:
Build and Manage from a Central Point-of-Control
Within the DB2 Control Center of DB2 UDB, you will find the Data Warehouse Center the command console for warehouse management. This integration gives you a common environment to manage your database, your data warehouse, and the processes for building and maintaining your environment. From this common environment, your database administrators (DBAs) can:
A unique graphical environment in the Data Warehouse Center makes it easy
for warehouse designers to specify over 150 built-in transformations and
visualize the flow of the build process. This "flowchart" also gives
designers a clear way to present the data warehouse to end users so they
can verify it meets their business needs.
Transformers for Statistical Functions and Warehouse Management
The DB2 Warehouse Manager for iSeries provides transformers for
statistics for functions such as ANOVA, Calculate statistics, Calculate
Chi-square, Correlation, Moving average, and Regression. In addition,
DB2 Warehouse Manager for iSeries provides transformers for warehouse
transformations such as clean data, generate key table, generate period
table, invert data, and pivot data. These standard transformations
relieve your programming staff from programming these powerful functions,
saving valuable time, resource, and development testing.
Integrate Data in Diverse Distributed Environments
As users realize the advantages of your data warehouse, they will inevitably use it more and expect it to offer increasingly sophisticated levels of information. With DB2 Warehouse Manager, you can build data warehouses that grow and change with your business and leverage more of your available information resources.
DB2 Warehouse Manager enhances the scalability of your data warehouse with a distributed warehouse agent for the iSeries operating environment. This agent executes the transformation and data movement requests, allowing the administrator to select the correct platform for transformation processes and enabling point-to-point, distributed, and parallel data movement.
The AS/400 Agent is a powerful tool, running natively on iSeries, which manages the flow of data between the data sources and target warehouses. It uses the DB2 CLI to communicate with different databases.
The Data Warehouse Center provides access to DB2, Oracle, Sybase, Informix, Microsoft SQL Server, flat file, ODBC, and OLE DB sources. It uses simple movement techniques to help you get started quickly and more advanced functions for incremental data movement.
As your data warehousing needs diversify, DB2 Warehouse Manager makes it
easy to gain access to disparate data sources and populate dependent
datamarts across distributed platforms from a centralized control point.
Simplify User Access
The DB2 Warehouse Manager and QMF for Windows for iSeries enable easy and reliable access to your data warehouse. QMF for Windows provides:
To extend business reporting capabilities to Windows clients or Web browsers, QMF for Windows:
QMF for Windows supplies metadata that populates the Information Catalog with QMF for Windows queries and procedures, enabling these objects to be located and launched from within the Information Catalog.
DB2 Warehouse Manager also includes the Information Catalog that helps users find, understand, and access the data available to them so they can quickly make informed decisions using accurate data.
Enable Controlled Warehouse Growth and Use
In addition to built-in governing in DB2 UDB, DB2 Warehouse Manager gives you complementary tools to govern and track warehouse access. You can take advantage of QMF for Windows governing for DB2 for iSeries databases.
With the growing number of users and varying query requirements, the database administrator has a tough job protecting resources from runaway queries and tuning the database for optimum performance. These tools help data centers:
Leverage Metadata Standards to Deliver Integrated Solutions
A major challenge in data warehouse implementations is the integration of independent products to create a complete solution. One of the obstacles to integration has been the multiplicity of metadata formats. Used in data warehouses and numerous business intelligence tools, metadata informs users and DBAs about the characteristics and applicability of the data they are accessing.
To deliver this information efficiently in an integrated solution, the component tools must use standard metadata formats to communicate common information. Such standards help to:
Data Warehouse Center creates and manages data warehouses by easing the tasks of:
The new graphical user interface is integrated with the DB2 Control Center and offers full replacement, incremental, and replication style data movement options for flexibility in maintaining the data warehouse.
The Information Catalog Manager, previously provided with Visual Warehouse®, is now an integral component of DB2 Warehouse Manager. It helps end users find, understand, and access available information by:
QMF for Windows is included with the DB2 Warehouse Manager for iSeries to provide a multipurpose query tool for business reporting, data sharing, server resource protection, powerful application development, and native connectivity to DB2 for iSeries databases. It allows users to:
Also, the Administrator component controls resource consumption by user group through detailed permissions by group, schedule, or both.
The AS/400 Agent is a powerful tool, running natively on the iSeries,
which manages the flow of data between the data sources and the target
warehouses. It uses the DB2 CLI to communicate with different databases.
New DB2 Warehouse Manager with Version 7 Release 2
Data Warehouse Center: The power of Visual Warehouse and the simplicity of the DB2 Control Center have been merged to provide a single, new user interface for business intelligence customers. You can use the Data Warehouse Center to:
The Warehouse launchpad simplifies the job of populating a warehouse by leading you through the related tasks.
The Data Warehouse Center supports full refresh and incremental update data movement options including leveraging the power of IBM's integrated data replication functions. Integrated SQL Assist capabilities help customers define over 100 transformations using the rich SQL available with DB2.
Star Schema Builder: Within the Data Warehouse Center, the warehouse schema modeler is a specialized tool for generating and storing schema associated with a data warehouse. Any schema resulting from this process can be passed easily as metadata to the OLAP Integration Server, which is part of the OLAP Starter Kit and the DB2 OLAP Server.
Process Modeler: The Process Modeler allows users to graphically link the steps needed to build and maintain data warehouses and dependent datamarts. Dependency relationships, conditional processing, and notifications can all be included in the model. Processes can be scheduled for one-time or repeated execution, or can be triggered by internal or external processes.
Enhanced Support for Creating and Changing Warehouse Target Tables: With DB2 Version 7 Release 2, the Data Warehouse Center provides additional flexibility for creating and changing warehouse target tables. When a change to a warehouse step creates additional columns, you can have the Data Warehouse Center create automatically the new columns in the target table and map the results of the step to these new columns. You can also now choose the name and table space for the target table.
Mandatory Fields: The Data Warehouse Center now displays red borders on required fields. The red borders alert you to information such as database names, user IDs, or passwords necessary to define the Data Warehouse Center objects. When you enter the required information, the borders disappear.
New Warehouse Sources: With DB2 Version 7 Release 2, you can access many new and diverse warehouse sources. New warehouse data sources include Microsoft OLE DB objects and Microsoft Data Transaction Services packages.
Microsoft OLE DB and Data Transaction Services Support: The Data Warehouse Center now enables you to access data from an OLE DB provider as a DB2 database view. A wizard is provided to create a DB2 OLE DB table function and the DB2 view through which you can access the data. Because Data Transaction Services (DTS) packages can be accessed as OLE DB sources, the wizard also allows you to create the view for a DTS package. When you access the view at run time, the DTS package executes and populates the target table of the DTS.
For information on the types and availability of training, visit the Web at:
The appropriate curriculum will include the enhancements described in this announcement.
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:
The following publications can be ordered from IBM after June 8, 2001. To order, contact your IBM representative.
Order Title Number DB2(R) UDB Data Warehouse Center SC26-9993 Administration Guide V7 DB2 UDB Data Warehouse Center SC26-9994 Application Integration Guide V7 DB2 UDB Warehouse Manager Information SC26-9995 Catalog Manager Administration Guide V7 DB2 UDB Warehouse Manager Information SC26-9996 Catalog Manager User's Guide V7 DB2 UDB Warehouse Manager Information SC26-9997 Catalog Manager Programming Guide and Reference V7 DB2 UDB Warehouse Manager Installation SC26-9998 Guide V7
You can also order the above from the Publications Web page at:
The Publication Notification System (PNS) is available by order number/product number. Customers currently subscribing to PNS will automatically receive notifications by e-mail. Customers who want to subscribe, can visit the PNS Web site location at:
The IBM Publications Center Portal:
The Publications Center is a worldwide central repository for IBM product publications and marketing material with a catalog of 70,000 items. Extensive search facilities are provided, as well as payment options via credit card. Furthermore, a large number of publications are available online in various file formats, which can currently be downloaded free of charge.
Note that PNS subscribers most often order their publications via the Publication Center.
Note: QMF for Windows® publications provide multiplatform support, including QMF for iSeries. In addition, a booklet specific to QMF for iSeries is available from the QMF Web site at:
It is recommended that customers download this booklet.
Publications for DB2 UDB are included in softcopy form on the CD-ROM as part of the install image. To assist with the initial installation, a DB2 for Windows Quick Beginnings book is also provided in hardcopy within the product box.
The displayable manuals can be viewed using an HTML browser installed on your system, or by using the Netscape Navigator browser provided.
There is also a separate publications CD-ROM where PDF versions of the library can be viewed or printed.
Server hardware requirements are those required to run DB2 for iSeries (V4R4, or later).
Workstation hardware requirements are those needed to run the Windows software as described in the Software Requirements section.
The following table shows applicable, recommended minimum disk space for a typical installation in megabytes (MB). The actual space required may vary depending on the customers' file system and the components installed. The numbers are for reference only.
Windows NT(R)/ Windows 2000 DB2 Warehouse Manager 175 MB(1) DB2 UDB Enterprise Edition 245 MB(2) DB2 Clients Administrative Client 125 MB Run-time Clients 25 MB Application Development 325 MB(3) Transformers 12 MB
The DB2 Warehouse Manager for iSeries (5724-B08) uses the warehouse server component of DB2 UDB Enterprise Edition Version 7.2, which runs on 32-bit platforms as follows:
The DB2 Warehouse Manager for iSeries (5724-B08) uses the warehouse administrative client component of DB2 UDB Enterprise Edition Version 7.2, which runs on 32-bit platforms as follows:
DB2 UDB Enterprise Edition does not restrict access to local DB2 server data through user counting, although customers are required to obtain user entitlements for host connectivity with these two products.
DB2 Warehouse Manager for AS/400, Version 7 Release 1 customers with AS/400 subscription are entitled to free upgrade to DB2 Warehouse Manager for iSeries, Version 7 Release 2, and will receive their upgrades automatically after product availability.
Customer Responsibilities: Installation and support for these products on all supported platforms is provided for a fee by IBM Global Services under the Personal System Support Family organization at 800-237-5511. For information or prices related to a SupportLine Technical Support contact, call 800-426-4343. To speak to an IBM representative about personal systems software, call 800-426-4968.
Informal support can be found on the Web at:
All support or advice provided through the Web is provided on an as-is basis.
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).
This program when downloaded from a Web site, contains the applicable IBM
license agreement, and License Information (LI), if appropriate and will
be presented for acceptance at the time of installation of the program.
The license and LI will be stored in a directory such as LICENSE.TXT for
Security, Auditability, and Control
DB2 Warehouse Manager uses the security and auditability features of the iSeries operating system.
The customer is responsible for evaluation, selection, and implementation of security features, administrative procedures, and appropriate controls in application systems and communication facilities.
DB2 Warehouse Manager is a client server product that has a single charge unit: processor.
Part Description Number DB2 Warehouse Manager for iSeries, Version 7.2 20P4323 Program Package with 1 Processor English DB2 Warehouse Manager for iSeries, Version 7.2 20P4327 1 Processor PoE DB2 Warehouse Manager for iSeries, Version 7.2 20P5835 Net Delivery Upgrades DB2 Warehouse Manager for iSeries, Version 7.2 20P4325 with 1 Processor Program Package Upgrade English DB2 Warehouse Manager for iSeries, Version 7.2 20P4328 Upgrade from Version 7.1 Processor PoE
Part Description Number DB2 Warehouse Manager for iSeries, BB7R9NA V7.2 Multi (non-AP) Media Pack DB2 Warehouse Manager for iSeries, BB7UVNA V7.2 Doc Pack English Volume Purchase Options VPO Instl DB2 WarehsMgr for D57WULL iSeries Process VPO Instl/SW Sub DB2 WarehsMgr for D57X7LL iSeries Process 1 Anniv VPO Instl/SW Sub DB2 WarehsMgr for D57X8LL iSeries Process 2 Anniv VPO SW Sub Rnwl DB2 WarehsMgr for E17YRLL iSeries Process VPO SW Sub DB2 WarehsMgr for D57YTLL iSeries Process 1 Anniv Part Description Number VPO SW Sub DB2 WarehsMgr for D57YVLL iSeries Process 2 Anniv VPO Upgrade DB2 WarehsMgr for No SKU iSeries Process Needed Contract Options CO Instl DB2 WarehsMgr for No SKU iSeries Process Needed CO Instl/SW Sub DB2 WarehsMgr for D57YWLL iSeries Process 1 Anniv CO Instl/SW Sub DB2 WarehsMgr for D57YZLL iSeries Process 2 Anniv CO SW Sub Rnwl DB2 WarehsMgr for E17Z0LL iSeries Process CO Upgrade DB2 WarehsMgr for No SKU iSeries Process Needed CO SW Sub DB2 WarehsMgr for D57Z9LL iSeries Process 1 Anniv CO SW Sub DB2 WarehsMgr for D57ZFLL iSeries Process 2 Anniv CO Support Options CO Supt DB2 WarehsMgr for iSeries No SKU Process 2 Anniv Needed CO Supt DB2 WarehsMgr for iSeries AT603LL Process 1 Anniv CO Instl/SW Sub/Supt DB2 WarehsMgr for D56LFLL iSeries Process 1 Anniv CO Instl/SW Sub/Supt DB2 WarehsMgr for D56LGLL iSeries Process 2 Anniv CO SW Sub/Supt DB2 WarehsMgr for D56LHLL iSeries Process 1 Anniv CO SW Sub/Supt Rnwl DB2 WarehsMgr for E16LNLL iSeries Process CO Instl/Supt DB2 WarehsMgr for No SKU iSeries Process 1 Anniv Needed
Terms and Conditions
The following license limitations exist within the DB2 UDB Version 7 Release 2 product:
The following technical limitations exist within the DB2 UDB Version 7 Release 2 product:
The prices provided in this announcement are suggested retail prices for the U.S. only and are provided for your information only. Dealer prices may vary, and prices may also vary by country. Prices are subject to change without notice. For additional information and current prices, contact your local IBM representative.
Part Description Number OTC(4) DB2 Warehouse Manager 20P4323 $10,600 for iSeries, Version 7.2 Program Package with 1 Processor English DB2 Warehouse Manager 20P4327 10,500 for iSeries, Version 7.2 1 Processor PoE DB2 Warehouse Manager 20P5835 10,573 for iSeries, Version 7.2 Net Delivery Part Description Number OTC(4) Upgrades DB2 Warehouse Manager 20P4325 $5,300 for iSeries, Version 7.2 with 1 Processor Program Package Upgrade English DB2 Warehouse Manager 20P4328 5,250 for iSeries, Version 7.2 Upgrade from Version 7.1 1 Processor PoE
Contact your sales channel for IBM Operational Support Services Support Line pricing information.
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: AE001 Phone: 800-IBM-CALL Fax: 800-2IBM-FAX Internet: firstname.lastname@example.org Mail: IBM Atlanta Sales Center Dept. AE001 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.