|
|
IBM United States
Software Announcement 202-048
March 5, 2002
New and Enhanced IBM Data Management Tools for DB2 and IMS Add Function
for Managing Your Database Environment
 ENUS202-048.PDF (91KB)
|
(Corrected on July 9, 2002)
Added an additional requirement to Software Requirements section.
(Corrected on April 12, 2002)
Corrected to add additional information on DB2 Query Tools, added a
publication to publication list, and changed Support Line to Yes.
At a Glance
New database tools, versions, and releases for your DB2 and IMS
installations can help you:
-
Maximize the availability of your systems
-
Keep your operating environment running at peak performance
-
Meet requirements for additional recovery/replication capabilities
-
Effectively create and operate your application subsystem
New capabilities are announced for each category:
-
IBM Tools for Database Administration
-
IBM Tools for Database Recovery and Replication
-
IBM Tools for Database Performance Management
-
IBM Tools for Database Application Management
For ordering, contact:
Your IBM representative, an IBM Business Partner, or IBM Americas
Call Centers at
800-IBM-CALL
(Reference: LE001).
Overview
Building on a strengthened focus on data management tools, IBM now has
new tools and functions that further complement IBM's premier DB2
Universal Database® (UDB) for z/OS™ and IMS™ database engines.
IBM wants to be your preferred supplier of tools, so check out our
affordable, high-performance, and functionally rich products.
New in this Announcement
-
Program Services for DB2® Performance Monitor for z/OS, V7 have been
extended 12 months to November 30, 2004.
-
One service enhancement.
-
Two new licensed programs — one DB2 and one IMS.
-
Five new program versions — four DB2 and one IMS.
-
Six new program releases — four DB2 and two IMS.
For details about these products, refer to the
Description
section.
Clarification
All the data management tools for DB2 and IMS:
-
Have a 30-day money back guarantee.
-
Have only hardcopy publications of the License Agreement and Program
Directory shipped with the products. Other publications, for example,
the User's Guide, are available only in softcopy.
Effective March 8, 2002, user publications, other than license
agreements and program directories, will be available in softcopy only
for previously announced Data Management Tools. Specifically, refer to
the
Publications
section for a list of products for which hardcopy publications will no
longer be available.
Planned Availability Dates
-
March 8, 2002: IMS Queue Control Facility for z/OS, V1.2
-
March 15, 2002: IMS High Performance Prefix Resolution for
z/OS, V2
-
May 10, 2002: IMS High Availability Large Database Conversion
Aid for z/OS, V1
-
June 21, 2002:
-
DB2 Change Accumulation Tool for z/OS, V1.2
-
DB2 Query Monitor for z/OS, V1.2
-
DB2 SQL Performance Analyzer for z/OS, V2
-
June 28, 2002: IMS Index Builder for z/OS, V2.2
-
July 26, 2002:
-
DB2 Administration Tool for z/OS, V4
-
DB2 Object Comparison Tool for z/OS, V2
-
DB2 High Performance Unload for z/OS, V2
-
DB2 Performance Expert for z/OS, V1
-
DB2 Table Editor for z/OS, V4.3
-
DB2 Web Query Tool for z/OS, V1.3
For DB2 Utilities Suite for z/OS, V7.1 Program Temporary Fixes (PTFs),
refer to APARs PQ56293, PQ56295, and PQ56296 for availability.
Description
IBM Tools for Database Administration
DB2 Administration Tool for z/OS, V4
gives you a comprehensive set of functions that help DB2 systems
personnel efficiently and effectively manage their DB2 environments. It
is an interactive, intuitive, and easy-to-use tool that gives you a
cost-effective solution for a full range of database administration
functions for DB2 for z/OS. DB2 Administration Tool also provides
centralized access to any tool with an ISPF interface through the DB2
tools Launchpad.
Enhancements are:
-
Cloning of work statement lists
-
More support for generating work statement lists
-
Restartable execution of utilities, DSN, and DB2 commands in addition to
the support of SQL statements currently provided
-
ALTER of primary key will also change foreign keys
-
DB2 subsystem selection on DB2 Tools Launchpad
-
DROP and REVOKE impact analysis
DB2 High Performance Unload for z/OS, V2
offers sequential reading and the capability to access your DB2 data at
top speed. It can unload data from image copies as well as active tables
and create multiple output files during a single unload with minimal
cost. DB2 High Performance Unload can store the output in multiple
formats including those that are user tailored.
New capabilities:
-
DB2 Admin Line command support
-
Multiple unload statement in one SYSIN
-
Tablespace name becomes an optional parameter
-
Support of FastUnload from Computer Associates and Unload Plus from BMC
Software, Inc.
-
Expressions supported in the SELECT clause of the select statement
-
SQL-Case statements supported in the SELECT clause and in the WHERE
clause
Refer to the
DB2
High Performance Unload for z/OS
section for more information on the new capabilities of this product.
DB2 Object Comparison Tool for z/OS, V2
helps you keep your test and development system as a mirror image of the
production system. New applications, application modifications, or
mistakes can cause DB2 objects in one of these systems to have different
attributes than on other systems. The DB2 Object Comparison Tool allows
you to compare objects (and dependent objects) from one source to
another. Once a difference file is generated, the product can be used to
generate the DB2 commands needed to bring the catalogs back into
synchronization.
Enhancements include:
-
Target changes can be generated into a work statement list
-
Improved reports
For
DB2 Utilities Suite for z/OS, V7.1
(5697-E98),
DB2 Diagnostic and Recovery Utilities
(5655-E62), and
DB2 Operational Utilities
(5655-E63) PTFs, refer to the following APAR Numbers:
-
PQ56296 for DB2 Diagnostic and Recovery Utilities (5655-E62)
-
PQ56295 for DB2 Operational Utilities (5655-E63)
-
PQ56293 for DB2 Universal Database Server for z/OS and OS/390®
(5675-DB2)
These PTFs enhance V7 of the DB2 Utilities by removing a restriction in
the COPY/RECOVERY parallelism support when backup copies are on tape.
This support improves backup and recovery elapsed time performance by
parallel processing of backup copies going to or from different tape
devices and usability by automatic stacking of backup copies on tape for
the COPY and RECOVER utilities in these products.
IMS High Availability Large Database (HALDB) Conversion Aid for z/OS, V1
can help you take advantage of the capacity and availability features of
IMS at a stepped up pace by giving you utilities and aids to analyze,
model, and convert existing IMS database structures to a HALDB format.
IMS HALDB Conversion Aid gives you:
-
An easy-to-use ISPF front-end
-
Automatic DBD conversion
-
Conversion of TEST databases
-
Index pointer healing
-
Partition modeling tool
Refer to the
IMS HALDB Conversion Aid for z/OS
section for more information on the capabilities of the product.
IMS High Performance Prefix Resolution, V2
performs the same functions as the IMS Prefix Resolution utility
(DFSURG10) but with considerably reduced elapsed times.
Prefix resolution is a required step for resolving pointers for databases
containing logical relationships and for creating or recreating secondary
indices. Unlike V1, this version of the product does not require the
BatchPipes®/MVS™ subsystem. A data transfer service called HPPRPIPE
is used to eliminate the intermediate Work File 2 (WF2) data set, which
avoids much of the I/O, tape handling, and DASD requirements often
associated with prefix resolution.
IMS Index Builder, V2.2
can help you simplify index recovery and maintenance, reduce index
maintenance time, and eliminate the need to image copy index databases.
IMS Index Builder gives you an easy-to-use, one-step procedure for the
maintenance of primary and secondary indices. This release of the
product provides a complete service rollup. No new function is included
with this release.
IBM Database Tools for Replication and Recovery
DB2 Change Accumulation Tool for z/OS, V1.2
helps DB2 administrators minimize data recovery time by efficiently
keeping current and consistent data images more readily available.
New and enhanced capabilities are:
-
New ISPF user interface integrated with the DB2 Admin Launchpad
-
Mini-logs
-
SYSLGRNX log ranges supported just like the DB2 Recover Utility
-
Full image copy produced when no incremental or log data found
-
Improved support for LP/RP/LB/RB
-
Up to 5000 separate tablespaces can be specified per job
-
Improved Support for Data Sharing
-
Usability improvements
-
SHRLEVEL now propagated from the last image copy read
-
TO_QUIESCE control card
-
User defined BUFNO and NCP parameters
-
SMS management classes for temp datasets now user definable
Refer to the
DB2
Change Accumulation Tool for z/OS
section for more information on the new capabilities of this product.
IBM Database Tools for Performance Management
DB2 Performance Expert for z/OS, V1
integrates and provides common user interfaces, ISPF, and workstation GUI
for the functions of:
-
DB2 Performance Monitor for z/OS
-
DB2 Buffer Pool Analyzer for z/OS
-
New application performance expert facilities
While DB2 Performance Expert for z/OS includes all the functions and
features of DB2 Performance Monitor for z/OS and DB2 Buffer Pool Analyzer
for z/OS, the stand-alone products continue to be available and
supported. Program Services for DB2 Performance Monitor for z/OS, V7
have been extended 12 months to November 30, 2004.
DB2 Performance Expert may be optionally integrated with the DB2 Tools
Launchpad on ISPF and DB2 Control Center for the workstation GUI.
Trade-up Prices
to DB2 Performance Expert are available for customers who currently have
DB2 Performance Monitor, V7 (5655-E61), and/or DB2 Buffer Pool Analyzer
V1 (5655-E54). Refer to the
Ordering Information
section for a description of the trade-up opportunities.
Refer to the
DB2
Performance Expert for z/OS
section for more information on the new capabilities of this product.
DB2 Query Monitor for z/OS, V1.2
helps you maximize DB2 availability by clearly identifying
resource-intensive queries and providing drill-down analysis of the
resources used in their execution. Administrators can more easily
develop problem prevention measures for all types of queries issued from
any type of connection (including static SQL, dynamic SQL, JDBC, ODBC,
DB2 Connect®) in multiple types of operational environments, including
transactional, data warehouse, and Web-based.
New and enhanced capabilities are:
-
Enhanced monitoring profiles
-
VSAM file support
-
Easy drill-through from summary to detail data
-
Section oriented tracking and visibility
-
Usability enhancements
-
Quiet-time detection
Refer to the
DB2
Query Monitor for z/OS
section for more information on the new capabilities of this product.
DB2 SQL Performance Analyzer for z/OS, V2
delivers performance analysis for all phases of database application
design and development. Installations spend a great deal of their budget
managing the performance of their applications. DB2 SQL Performance
Analyzer is an outstanding aid to prevent queries from running too long.
With this tool you can find out how long queries will take:
-
Before you run them
-
Before resources are consumed
-
Before the query exceeds your installation's governor settings
New capabilities include:
-
Improved SQL Cost Estimates
-
Enhanced SQL Advisor
-
COBOL Stored Procedure Sample Program
-
Multiple DBRM Member Support under ISPF
-
Supplemental Information on Indices
Refer to the
DB2
SQL Performance Analyzer for z/OS
section for more information on the new capabilities of this product.
IBM Database Tools for Application Management
DB2 Table Editor for z/OS, V4.3
is IBM's multipurpose table editing environment that offers database
administrators, developers, and the entire enterprise, direct update and
data creation operations on DB2 UDB for OS/390 and z/OS databases from
within Java™, ISPF or Windows®-based interfaces.
The following new features have been added to the ISPF component of DB2
Table Editor:
-
Row-at-a-time editor/form mode
Now Table Editor gives you increased flexibility in viewing and editing
data by allowing you to view data vertically, one row at a time. Once in
"form mode", you can move from one row to another (go to the next row or
the previous row). You can also zoom into large columns. At any time,
you can go back to tabular mode.
-
Edit remote data via alias
With proper licensing, DB2 for z/OS and OS/390 tables residing at remote
locations can be edited by specifying the defined alias name.
-
INSERT into Empty Table
If you specify a table that contains no data, Table Editor will display
an empty table and allow you to insert one or more rows of data. Once
data is inserted, you can edit normally.
-
VARCHAR updates when in zoom mode
When making changes to VARCHAR columns on the Zoom Panel, Table Editor
will calculate automatically the length of the column based on the input
value and trailing "pad" characters.
-
Flexible null indicator
If you edit a value that is NULL, Table Editor will turn the NULL
indicator off automatically, preventing the loss of changes made.
-
Abbreviated or full data type names
You can choose to see abbreviated or full data type names on the column
selection panel.
-
Undo for change
You can now specify the Undo line command on rows that are changed. The
row changes will be undone and reset to their original values.
-
Improved Scrolling
Numerous scrolling enhancements are provided, including persistent cursor
positioning and column justified scrolling.
-
Display current row position
Two row counters are displayed. The first counter indicates the number
of the rows currently displayed at the top of the tabular section of the
ISPF panel. The second counter indicates the total number of rows
available for display, for example, "Row 5 of 3000."
-
Improved handling of decimals
Decimal columns will not contain spaces on either side of the decimal
character.
-
Thousands separator in numeric columns
Table Editor now shows you the thousands separator (comma, period) in a
numeric column.
DB2 Web Query Tool for z/OS, V1.3
allows end users and administrators to access enterprise data with speed,
reliability, and simplicity. It enables pervasive connectivity over the
Internet to every desktop. DB2 Web Query sets a new standard for
business responsiveness because now anyone in your organization can take
robust data access for granted, virtually anywhere, and at anytime. Less
latency, less waiting, and less waste means more opportunity for you and
your organization.
DB2 Web Query Tools are capable of accessing DB2 data on z/OS, iSeries,
AIX, Linux, Windows, HP-UX, and Sun platforms. The products run on Web
servers, which need not be on the same platforms as the database servers.
For example, to access DB2 database data on iSeries, you need the DB2 Web
Query Tool for iSeries. To access DB2 database data on z/OS, you need DB2
Web Query Tool for z/OS. To access DB2 database data on AIX, Linux,
Windows, HP-UX and Sun platforms, you need DB2 Web Query Tool for
Multiplatforms.
DB2 Web Query V1.3 gives you increased versatility with the introduction
of the following features:
-
J2EE Support
Web Query is now a J2EE-compliant Web application. As such, it can now
be deployed on WebSphere® V4.
-
Server-side XSLching
Server side XSL transformations are now applied to the generated XML/XSL
data, which removes all requirements for client side XML translation
software components.
-
Stored Procedure Support
A DB2 stored procedure can be run by selecting it from the Web Query
object tree. You can also run a stored procedure by specifying a CALL
statement in your query.
-
Web Services (SOAP)
A saved query can be published as a SOAP service that any SOAP requestor
can access.
-
Scalable Vector Graphing
Result sets can be transformed to graphs/charts using the Scalable Vector
Graphics (SVG) model.
-
Large Object (LOB) Support
You can retrieve LOB data in Web Query. Web Query can also launch the
appropriate viewing application to render the LOB data (picture, video,
and audio).
IMS Queue Control Facility for z/OS, V1.2
delivers all the functions of IMS Message Requeuer and a lot more. QCF
gives you an interactive ISPF front end, allowing you to Browse, Query,
Unload, and Dequeue messages, set controls for the Queue Overflow
Protection feature, and more. Message selection capabilities and other
features quickly locate checkpoints. QCF supports IMS Standard Queues
and Shared Queues. This release of IMS Queue Control Facility contains
no new function but provides a rollup of all service.
Accessibility by People with Disabilities
The following features support use by people with disabilities:
-
Operation by keyboard alone
-
Optional font enlargement and high-contrast display settings
Euro Currency
These programs are not impacted by euro currency.
Reference Information
Previous DB Tools Announcements
There were four major DB tools announcements last year. Refer to:
-
Software Announcement
201-250
, dated September 11, 2001
-
Software Announcement
201-251
, dated September 11, 2001
-
Software Announcement
201-162
, dated May 29, 2001
-
Software Announcement
201-056
, dated March 6, 2001
These announcements offered 12 new products, seven new versions, and 13
new releases.
Trademarks
-
-
IMS, z/OS, and MVS are trademarks of International Business Machines
Corporation in the United States or other countries or both.
-
-
WebSphere, DB2 Universal Database, DB2, OS/390, BatchPipes, and DB2
Connect are registered trademarks of International Business Machines
Corporation in the United States or other countries or both.
-
-
Windows is a registered trademark of Microsoft Corporation.
-
-
Java is a trademark of Sun Microsystems, Inc.
-
-
Other company, product, and service names may be trademarks or service
marks of others.
DB2® Change Accumulation Tool for z/OS™, V1.2
V1.2 of this program helps DB2 administrators minimize data recovery time
by efficiently keeping current and consistent data images more readily
available. This release offers the following new and enhanced
capabilities:
-
New ISPF user interface
A new method is provided for building the Change Accumulation batch job
by using a series of ISPF panels that group objects to recover along with
options "profiles." These components are then used by the ISPF online
component to build the JCL via ISPF file tailoring services. The
resulting jobs can then be stored off and run at a later time.
-
Mini-logs
Change Accumulation Tool now has a new component called mini-logs that
extracts portions of the DB2 log that pertain to the object being
processed. Creating an alternate mini-log dataset that is stored in a
Change Accumulation Tool maintained database saves you valuable
resources. If mini-logs are present, they will be used instead the
entire DB2 log. Mini-logs shift the I/O time spent in reading vast
portions of the log (even when SYSLGRNX is factored in), which contain no
relevant data, to non-critical times.
-
SYSLGRNX log ranges supported just like the DB2 Recover Utility
Change Accumulation Tool now adds support for SYSLGRNX that greatly
reduces the amount of log records, archive log files, and archive log
file mounts needed for processing.
-
Full image copy produced when no incremental or log data found
In the case where a tablespace was processed and it is determined to have
no updates to apply, the Change Accumulation Tool notices this condition
and makes no copy and writes no record to SYSCOPY.
-
Improved support for LP/RP/LB/RB
The RECOVERY_SITE control card is used when writing a new SYSCOPY record.
-
Up to 5000 separate tablespaces can be specified per job
Now you can specify up to 5000 separate tablespaces for DB2 Change
Accumulation Tool processing.
-
Improved Support for Data Sharing
All the members in a data sharing group can be easily found. The Change
Accumulation Tool can read all of the appropriate BSDSs, find all of the
log ranges, and read all of the necessary log records.
-
Usability improvements
For easier analysis and diagnosis of errors, all error messages are now
written to SYSOUT and all follow the same message format.
-
SHRLEVEL now propagated from the last image copy read
The Change Accumulation Tool will always write into the new SYSCOPY row
the share level of the most recent image copy (either full or
incremental) used in processing.
-
TO_QUIESCE control card
The Change Accumulation Tool now has a TO_QUIESCE control card that
allows you to process the data up to a log point established by a
stand-alone quiesce utility run. This will prevent the Change
Accumulation Tool from going beyond the most recent quiesce point in the
log.
-
User defined BUFNO and NCP parameters
Instead of using the default values for BUFNO (number of QSAM buffers)
and NCP (number of QSAM channel programs), the Change Accumulation Tool
now gives you the ability to specify these values. These values are then
used during dynamic allocation of its work and input/output files.
-
SMS management classes for temp datasets now user definable
Instead of using the default values for all SMS fields, the Change
Accumulation tool now gives you the ability to specify these values.
These values are then used during dynamic allocation of work files.
DB2 High Performance Unload for z/OS, V2
DB2 High Performance Unload for z/OS, V2 offers sequential reading and
the capability to access your DB2 data at top speed. It can unload data
from image copies as well as active tables and create multiple output
files during a single unload with minimal cost. DB2 High Performance
Unload can store the output in multiple formats including those that are
user tailored.
New capabilities:
-
New and integrated DB2 Admin Line command support
This support enables you to launch High Performance Unload from the DB2
Admin Tool. This support also includes a new ISPF interface that allows
High Performance Unload to be invoked from either batch or ISPF. As with
all of our DB2 tools products that have an ISPF interface, High
Performance Unload can also be launched from the DB2 Admin Launchpad.
-
Multiple unload statement in one SYSIN
You may now code multiple Unload statements in a single SYSIN. Each
Unload statement will be processed one at a time.
-
The tablespace name becomes an optional parameter
Prior to High Performance Unload V2.1, you were required to specify the
tablespace name in the Unload statement. Now the tablespace name will be
derived from the tablename specified in the SELECT statements. If
multiple Select statements are present and can be processed natively but
refer to different table spaces, distinct unload processing will be
created automatically.
-
Support of FastUnload from Computer Associates and Unload Plus from BMC
Software, Inc.
High Performance Unload V2.1 is JCL tolerant of FastUnload 3.1 and Unload
Plus 2.1.01. Some features of the these two products may be ignored or
have slightly different interpretations when executed by High Performance
Unload. In most cases, this function significantly reduces the amount of
work required to convert from FastUnload or UnloadPlus to High
Performance Unload.
-
Native support of expressions in the SELECT clause
Expressions are supported in the SELECT clause of the select statement.
For example, Select C1, SUBSTR(C1 || C2, 5, 10), C3 FROM..., is supported
natively. The expressions supported are the same ones that are supported
in the WHERE clause.
-
Native support of SQL-Case statements
SQL-Case statements are supported in the SELECT clause and in the WHERE
clause.
DB2 Performance Expert for z/OS, V1
DB2 Performance Expert is the tool for ultimate performance. It helps
you get optimum performance from your database management system and
provides support for resolving critical performance issues. It may be
optionally integrated with the DB2 Tools Launchpad on ISPF and DB2
Control Center for the workstation GUI.
Monitoring functions keep you informed about the health of your system
and what is currently running in it.
The Reporting Facility presents performance information about details of
DB2 events. The system-wide performance data provides information about
CPU times, buffer pool usage, locking, I/O activity, and more.
The Performance Warehouse function supports you in managing and handling
your DB2 Performance Expert performance database. You can:
-
Save DB2 trace and report data in the performance database for further
investigation and trend analysis
-
Configure and schedule the report and load process from the workstation
GUI functions
-
Use analysis functions (rules of thumb) that are shipped with the product
along with analysis functions you define
Buffer Pool Analysis helps database administrators (DBAs) manage buffer
pools more efficiently by providing information about current buffer pool
behavior and using simulation to anticipate future behavior. It helps
you tune DB2 buffer pools and get the most out of your system resources.
It lets you optimize memory usage by specifically recommending which
buffer pool to change and by how much.
Explain functions complete the monitoring, reporting, and analysis
functions with the capability to explain the determined access path of
SQL statements. You can explain a single SQL statement, which is
currently executed or saved in the dynamic statement cache, and you can
also explain an SQL statement out of your editor during coding of your
application program. The Batch Explain report allows you to explain all
or selected SQL statements of your plan or package. The workstation GUI
invokes the Visual Explain function shipped with DB2.
The key benefits of DB2 Performance Expert are:
-
Specificity
Detailed monitoring and in-depth analysis of DB2 Universal Database®
for z/OS and DB2 applications is provided.
-
Reliability
You can trust DB2 Performance Expert. It is the tool IBM relies on to
develop and test DB2.
-
Flexibility
DB2 Performance Expert presents its analysis results in a wide range of
specialized reports that can be tailored to suit individual needs.
-
Comprehensiveness
DB2 Performance Expert helps you prevent and solve performance problems
covering the full range of DB2 Universal Database for z/OS installations.
-
Investment protection
The close relation between DB2 and Performance Expert ensures that your
investment in DB2 is protected. DB2 Performance Expert provides complete
coverage of the latest DB2 Universal Database for z/OS enhancements and
also supports all previous DB2 versions starting with DB2 Universal
Database for OS/390®, V6.
DB2 Query Monitor for z/OS, V1.2
V1.2 of this program helps you maximize DB2 availability by clearly
identifying resource-intensive queries and providing drill-down analysis
of the resources used in their execution. Administrators can more easily
develop problem prevention measures for all types of queries issued from
any type of connection (including static SQL, dynamic SQL, JDBC, ODBC,
DB2 Connect®) in multiple types of operational environments, including
transactional, data warehouse, and Web-based.
DB2 Query Monitor gives you extensive control over what data is gathered
during activity monitoring, when it is gathered, about whom and what
database resources, and then what alerts should be executed. Monitoring
agents, which can be started and stopped dynamically, use menu-driven
criteria to watch up to 64 DB2 subsystems. As defined by administrators,
data gathered is offloaded at intervals from memory to storage. DB2
Query Monitor provides powerful views into the query processing events
occurring in your enterprise z/OS environment.
New and enhanced capabilities are:
-
Enhanced monitoring profiles
Monitoring Profiles determine when and for what Query Monitor should
start collecting detail statistics. Query Monitor collects only summary
data when there is no active Monitoring Profile. When a Monitoring
Profile is active, then detail is collected for the specified resources
(plan, DBRM, job, or user) when exception conditions are triggered
(excessive GETPAGE requests, or negative SQL CODEs).
-
VSAM file support
Detail data being collected by Query Monitor is written to VSAM at each
interval boundary or when the dataspace usage exceeds a certain
threshold. You can load the data from VSAM to DB2 via batch jobs that
are provided.
-
Easy drill-through from summary to detail data
Panel navigation now flows from summary data directly to detail data.
Users can see detail/exceptions related to summary data items.
-
Section oriented tracking and visibility
Query Monitor now separates SQL performance statistics at the section
level. SQL calls are combined at the section level along with associated
host variable and SQLCA data.
-
Usability enhancements
These enhancements include columnar scrolling improvements, automatic
cursor positioning when drilling through data, and enhanced help for
detail statistics.
-
Quiet-time detection
Query Monitor can detect when there is quiet time (no activity) in DB2.
When quiet time is detected, a user exit is called.
DB2 SQL Performance Analyzer for z/OS, V2
V2 of this program delivers performance analysis for all phases of
database application design and development. Developing applications
under DB2 requires the cooperative skills of the system architect, the
database administrator, the programming staff, and members of the systems
support team. In the daily quest to produce applications on time and
within budget, too often corners are cut such that performance is not
adequately considered. Once put into production, these applications fail
to perform adequately, particularly at high-transaction volumes. In
addition, even applications that originally performed well may
deteriorate over time due to changes in data distribution and data
volume, system changes, and even changes to the DB2 product itself.
Therefore, installations spend a great deal of their budget managing the
performance of their applications.
All DB2 problem queries have one thing in common. They run too long.
These queries cause the batch production window to shrink. Too often the
online queries take what seems like forever to execute, causing customers
and users to become frustrated. The most cost-effective solution to the
problem is prevention. DB2 SQL Performance Analyzer is an aid to prevent
queries from running too long. With this tool you can find out how long
queries will take:
-
Before you run them
-
Before resources are consumed
-
Before the query exceeds your installation's governor settings
New capabilities include:
-
Improved SQL cost estimates through:
-
Revamped cost estimates, algorithms, and formulas
-
Better recognition and handling of multistep and multiquery block
estimates
-
Accuracy enhancements for filter factors and query cardinality estimates
-
Enhanced SQL Advisor
New and updated information and recommendations, fine tuning of advice
given under certain special circumstances, elimination of some
non-essential advice; upgraded Warnings, Alerts, Guidelines,
Recommendations, Good News, and Performance Notes™ covering DB2 V5
through V7.
-
White Paper on Calibration and Validation
Documentation on how to calibrate SQL Performance Analyzer, validate the
installation configuration parameters, and compare SQL Performance
Analyzer cost estimates against measured results.
-
COBOL Stored Procedure Sample Program
In addition to the sample PL/1 program provided in V1, a new COBOL sample
program calling the SQL Performance Analyzer stored procedure (ANLPROC)
is provided, including source code, to allow your users familiar with
COBOL to more easily incorporate SQL Performance Analyzer stored
procedure calls into their application programs.
-
Multiple DBRM Member Support under ISPF
Under the TSO/ISPF interface to SQL Performance Analyzer, users will now
be able to analyze the content of an entire DBRM library, or selected
members (screened with the DBRMKEY parameter) interactively under a TSO
session. Previously, this feature was only available to SQL Performance
Analyzer Batch users.
-
Supplemental Information on Indices
For all indices chosen by the DB2 Optimizer for access path selection,
SQL Performance Analyzer will now display additional index "key column"
information, similar to the data available on alternative indices via the
optional SHOWALT parameter.
IMS High Availability Large Database (HALDB) Conversion Aid for z/OS,
V1
IMS HALDB Conversion Aid for z/OS, V1 can help you take advantage of the
capacity and availability features of IMS at a stepped-up pace by
providing utilities and aids to analyze, model, and convert existing IMS
database structures to an HALDB format. IMS HALDB Conversion Aid
provides:
-
An easy-to-use ISPF front-end
HALDB conversion requires a skilled DBA. As these skills are not freely
available, this tool supports migration without a skilled DBA. The
conversion process is guided by an ISPF application. It allows you to
model the partitions (via ISPF dialog or by standard setup rules). The
DBD and DBRC definitions are created. The HALDB partition datasets are
allocated. The conversion JCL is created. The conversion process can be
monitored.
-
Automatic DBD conversion
The HALDB database definition is "cloned" from the original DBD. There
are setup parameters for changing the dataset group definition (the old
DBD may have multiple datasets because of its size) or access method
(VSAM, OSAM). The "old" DBD is saved as source code during the
conversion process. It can be made available as necessary. This process
can be interactive or automatic.
-
Conversion of TEST databases
Many installations require the test environment to be a mirror of the
production environment, so the test databases need to be converted.
There may be many test environments. The ISPF application has setup
definitions for different environments, for example, production or test.
This allows the conversion of test databases to be made by application
programmers, since no DBA skills are required. The standard modeling
rule for partition sizes and boundaries should be used.
-
Index pointer healing
The migration process and a "normal" reorganization puts all EPS pointers
into "healing needed" status. This tool allows you to heal the index
pointer. It is part of the conversion process. It may be used after
reorganization. If the primary database has multiple indices, it will
run them in parallel.
-
Partition modeling tool
The modeling tool reads the database to be converted and saves data in a
repository. The data is used to create partition boundaries and sizes.
You can now interactively determine the size and the number of
partitions. There is no need to rerun the data collection portion
several times.
Offering Information
Product information is available through Offering Information (OITOOL)
at:
Publications
Effective March 8, 2002, user publications, other than license
agreement and program directories, will be available in softcopy only for
previously announced Data Management Tools. Specifically, hardcopy
publications will no longer be available for the following products:
Product ID
Product Number
DB2 DataPropagator(TM) V7 5655-E60
DB2 Performance Monitor V7 5655-E61
DB2 Row Archive Manager V1 5655-E65
IMS Advanced ACB Generator V1 5655-E05
IMS DEDB Fast Recover V2 5655-E32
IMS High Performance Load V1 5655-E07
IMS High Performance Prefix Resolution V1 5655-E08
IMS High Performance Unload V1 5655-E06
IMS Library Management Utilities V1 5655-E04
IMS Performance Analyzer V3 5655-E15
IMS Program Restart Facility V2 5655-E14
IMS Randomizer Generator V1 5655-E11
One copy of the following publications is supplied automatically with the
basic machine-readable material.
Order
Title Number
DB2 Administration Tool for z/OS, V4 GC27-1596
(5655-I23) License Information
DB2 Change Accumulation Tool for z/OS, GC27-1196
V1.2 (5655-F55) License Information
DB2 High Performance Unload for z/OS, GC27-1597
V2 (5655-I19) License Information
DB2 Object Comparison Tool for z/OS, GC27-1598
V2 (5655-I20) License Information
DB2 Performance Expert for z/OS GC27-1599
(5655-I21) License Information
DB2 Query Monitor for z/OS, V1.2 GC27-0969
(5655-E67) License Information
DB2 SQL Performance Analyzer GC27-1600
for z/OS, V2 (5655-I22)
License Information
DB2 Table Editor for z/OS, V4.3 GC27-1200
(5697-G65) License Information
DB2 Web Query Tool for z/OS, V1.3 GC27-0970
(5655-E71) License Information
IMS High Availability Large Database GC27-1578
Conversion Aid for z/OS (5655-I01)
License Information
IMS High Performance Prefix GC27-1589
Resolution for z/OS, V2.1
(5655-I15) License Information
IMS Index Builder for z/OS, V2.2 GC27-0931
(5655-E24) License Information
IMS Queue Control Facility for z/OS, GC26-9686
V1.2 (5697-E99) License Information
The following publications
cannot be ordered in hardcopy.
The publications are made available on the Web at:
Publications on CD-ROM for the products in this announcement will be
available on the next release of the following collections of software
product libraries:
-
z/OS Software Products Collection (SK3T-4270), BookManager® and PDF
formats
-
OS/390 Software Products Collection (SK2T-6700), BookManager format
Order
Title Number
DB2 Administration Tool for z/OS, V4
(5655-I23)
User's Guide SC27-1601
Reference Card SX26-3850
DB2 Change Accumulation Tool for z/OS, SC27-1191
V1.2 (5655-F55) User's Guide
DB2 High Performance Unload for z/OS, SC27-1602
V2 (5655-I19) User's Guide
DB2 Object Comparison Tool for z/OS, SC27-1603
V2 (5655-I20) User's Guide
DB2 Performance Expert for z/OS (5655-I21)
Monitoring User's Guide -- Workstation SC27-1645
Installation and Customization SC27-1646
Report Reference SC27-1647
Report Command Reference SC27-1649
Messages SC27-1650
Reporting User's Guide SC27-1651
Monitoring User's Guide -- ISPF SC27-1652
Buffer Pool Analyzer User's Guide SC27-1653
DB2 Query Monitor for z/OS, V1.2 SC27-0968
(5655-E67) User's Guide
DB2 SQL Performance Analyzer for z/OS,
V2 (5655-I22)
User's Guide SC27-1605
Installation Guide SC27-1625
DB2 Table Editor for z/OS, V4.3 SC27-1616
(5697-G65) User's Guide
DB2 Web Query Tool for z/OS, V1.3 SC27-0971
(5655-E71) User's Guide
IMS High Availability Large SC27-1579
Database Conversion Aid
for z/OS (5655-I01) User's Guide
IMS High Performance Prefix SC27-1590
Resolution for z/OS, V2.1
(5655-I15) User's Guide
IMS Index Builder for z/OS, V2.2 SC27-0930
(5655-E24) User's Guide
IMS Queue Control Facility for z/OS, SC26-9685
V1.2 (5697-E99) User's Guide
The following material is available on the Internet at:
Overview brochure
-
IBM Tools for DB2 and IMS for z/OS and OS/390 (GC27-1070)
Specification Sheets
-
DB2 Administration Tool (GC27-1045)
-
DB2 Change Accumulation Tool (GC27-1052)
-
DB2 High Performance Unload (GC27-1047)
-
DB2 Object Comparison Tool (GC27-1051)
-
DB2 Performance Expert (GC27-1633)
-
DB2 Query Monitor (GC27-1042)
-
DB2 SQL Performance Analyzer (GC27-1038)
-
DB2 Table Editor (GC27-1053)
-
DB2 Web Query Tool (GC27-1044)
-
IBM IMS High Availability Large Database (HALDB) Conversion Aid
(GC27-1632)
-
IBM IMS High Performance Prefix Resolution (GC27-1065)
-
IBM IMS Index Builder (GC27-1065)
-
IBM IMS Queue Control Facility (GC27-1069)
Technical Information
Hardware Requirements
The products in this announcement will operate on any hardware
configuration that supports the required versions of DB2 and/or IMS.
Additional hardware requirements are:
-
A display station supported by Interactive System Productivity Facility
(ISPF).
-
An IBM color graphics display station, or equivalent, supported by
Graphical Data Display Manager (GDDM®) is needed by the host-based
graphics facility of DB2 Performance Expert.
-
A workstation with a high-resolution monitor that supports Windows NT®
V4, Windows® 2000, or Windows XP with approximately 120 MB of available
hard disk space is required by the DB2 Performance Expert
workstation-based Online Monitor.
Software Requirements
DB2 Object Comparison Tool for z/OS, V2 (5655-I20) requires DB2
Administration Tool for z/OS, V4 (5655-I23). DB2 Performance Expert
requires DB2 V6, or later. The other DB2 products in this announcement
require DB2 V5, or later.
-
DB2 V5 (5655-DB2)
-
DB2 V6 (5645-DB2)
-
DB2 V7 (5675-DB2)
DB2 Performance Expert has additional software requirements:
-
ISPF, Windows NT or Windows XP is needed depending on which Online
Monitor you use. The host-based graphics facility (ISPF) requires:
-
Graphical Data Display Manager (GDDM) V2.3 (5665-356)
-
GDDM Presentation Graphics Feature (GDDM/PGF) V2.1.1 (5668-812)
-
DB2 Connect Personal Edition V7 (5648-D40) is needed if you use the
Performance Warehouse.
DB2 Web Query for z/OS is supported for hosting on WebSphere® for z/OS,
V3.5 (5655-A98) and V4 (5655-F31).
-
Host servers require support for:
-
JDK V1.3, or later
-
JDBC V1, or later
-
JSDK V2, or later
-
JSP V1.1, or later
-
Servlet 2.2, or later
-
Client interfaces and devices must support:
-
HTTP (Web browser) interface, Level 4 browser capable of Java™
-
WAP device interface, V3, or later
-
POP/SMTP interface, standard POP/SMTP e-mail protocols
IMS HALDB Conversion Aid requires IMS V7, or later. The other IMS
products in this announcement operate on all supported versions of IMS.
-
IMS V6 (5655-158)
-
IMS V7 (5655-B01)
-
IMS V8 (5655-C56)
Planning Information
Packaging:
The programs in this announcement are distributed with the following
content:
-
Basic machine-readable material on a 3480 tape cartridge except for DB2
Web Query Tool and DB2 Table Editor:
-
DB2 Web Query Tool machine-readable material, which is all workstation
code, is on CD-ROM. No z/OS code is required. During installation on
the workstation, DB2 Web Query binds to the appropriate databases on
z/OS.
-
DB2 Table Editor is shipped with workstation code on CD-ROM and z/OS code
on 3480 tape cartridge.
-
Program Directory
-
Proof of Entitlement (PoE)
-
IBM International Program License Agreement (IPLA)
-
License Information
Security, Auditability, and Control
The announced programs use the security and auditability features of the
host operating system software.
The customer is responsible for evaluation, selection, and implementation
of security features, administrative procedures, and appropriate controls
in application systems and communication facilities.
Ordering Information
The products in this announcement have one charge unit: Value Unit.
Value Unit based pricing will help to align the prices of these Products
to the principle of the PSLC pricing curve, which provides for a lower
price per MSU (millions of service units per hour) for larger capacities.
There is also be a price benefit when customers grow their capacity.
Additional capacity will be based on the number of Value Units (MSUs) the
customer has already installed, for example, additional capacity will not
be priced starting at the base with a higher price per unit but on the
capacity that is already installed.
Note that Value Units of a given product cannot be
exchanged/interchanged/aggregated with Value Units of another product.
Translation from MSUs to Value Units
MSUs Value Units/MSU
Base 1-3 1.00
Tier A 4-45 .45
Tier B 46-175 .36
Tier C 176-315 .27
Tier D 316+ .20
The total number of Value Units is calculated according to the following
example:
If the customer has installed 1,000 MSUs, the applicable Value Units
would be: 3 x 1.00 + 42 x 0.45 + 130 x 0.36 + 140 x 0.27 +
685 x 0.20 = 244 Value Units
When calculating the total number of Value Units, the sum is to be
rounded up to the next integer.
Value Units for IBM 9672 Processors will be based upon the full capacity
of these systems. This is applicable to all S/390®-based systems that
are measured on MSU capacity. Information on MSU capacities can be found
in the IBM System/370™, System/390®, and IBM  zSeries
Machine Exhibit (Z125-3901).
Value Units for zSeries will be based upon full MSU capacity as defined
in the Machine Exhibits, unless a customer qualifies for sub-capacity
pricing on the z/900 server.
Value Units for non-MSU-based S/390 Processors
MP3000 Models
H30 = 6.00 Value Units
H50 = 8.00 Value Units
H70 = 12.00 Value Units
P/390, R/390, IBM 3006 = 2.00 Value Units
A tool is available that supports transforming the MSU-based capacities
of S/390 Systems to new Value Units by calculating the applicable number
of Value Units for a given number of MSUs. The person preparing an order
is required to use this tool to calculate the number of Value Units,
based upon the number of MSUs (processor capacity). CFSW expects Value
Units as configuration input.
Value Unit Exhibit VUE007
Value Value
Units/ Units/
Usage Level Minimum Maximum MSU Hardware Machine
Base 1 3 1 MP3000 H30 6
PSLC / Level A 4 45 0.45 MP3000 H50 8
PSLC / Level B 46 175 0.36 MP3000 H70 12
PSLC / Level C 176 315 0.27 ESL Models 2
PSLC / Level D 316 + 0.2
The products in this announcement have one charge unit: Value Units.
Value Units for IBM 9672 Processors will be based upon the full capacity
of these Systems. This is applicable to all S/390-based systems that are
measured on MSU capacity. Information on MSU capacities can be found in
the IBM System/370, System/390, and zSeries Machine Exhibit (Z125-3901).
Value Units for zSeries will be based upon full MSU capacity as defined
in the Machine Exhibits.
There is a tool available that provides support for transforming the
MSU-based capacities of S/390 systems to new Value Units by calculating
the applicable number of Value Units for a given number of MSUs.
Translation from MSUs to Value Units Example
Translation from MSUs to Value Units
MSUs Value Units/MSU
Base 1-3 1.00
Tier A 4-45 .45
Tier B 46-175 .36
Tier C 176-315 .27
Tier D 316+ .20
Note:
For the actual translation from MSUs to Value Units for this product,
see below.
Ordering Example:
The total number of Value units is calculated according to the
following example:
If the customer has installed 1,000 MSUs, the applicable Value Units
would be:
Translation from MSUs to Value Units
MSUs x Value Units/MSU = Value Units
Base 3 x 1.00 = 3.00
Tier A 42 x .45 = 18.90
Tier B 130 x .36 = 46.80
Tier C 140 x .27 = 37.80
Tier D 685 x .20 = 137.00
Total 1000 244
When calculating the total number of Value Units the sum is to be rounded
up to the next integer.
Feature
1 Value Unit 0001
250 Value Units 0002
Example:
For a product running on machines with 1,000 MSUs requiring 244
Value Units, you would order feature number 0001, quantity 244.
Note:
For actual feature numbers, see below.
Value Units for Non-MSU-Based S/390 Processors
MP3000 Models
H30 = 6.00 Value Units
H50 = 8.00 Value Units
H70 = 12.00 Value Units
P/390, R/390, IBM 3006 = 2.00 Value Units
Basic License:
To order, specify the program number, feature number 9001 for asset
registration, and the one-time charge (OTC) feature number. Also specify
the feature number of the desired distribution medium. To suppress
shipment of media, select the License-only option in CFSW.
Translation from MSUs to Value Units
MSUs Value Units/MSU
Base 1-3 1.00
Tier A 4-45 .45
Tier B 46-175 .36
Tier C 176-315 .27
Tier D 316+ .20
The ordering information is not changed for:
-
New product releases in this announcement from prior releases
-
Subscription and Support licenses for new product releases and product
versions in this announcement from prior releases and versions
Program
Program Name Number
DB2 Change Accumulation Tool 5655-F55
for z/OS, V1.2
Subscription and Support DB2 Change 5655-E48
Accumulation Tool for z/OS
DB2 Query Monitor for z/OS, V1.2 5655-E67
Subscription and Support 5655-E87
DB2 Query Monitor for z/OS
DB2 Table Editor for z/OS, V4.3 5697-G65
Subscription and Support 5655-E84
DB2 Table Editor for z/OS
DB2 Web Query Tool for z/OS, V1.3 5655-E71
Subscription and Support 5655-E91
DB2 Web Query Tool for z/OS
IMS Index Builder for z/OS, V2.2 5655-E24
Subscription and Support 5655-E23
IMS Index Builder for z/OS
IMS Queue Control Facility for z/OS, V1.2 5697-E99
Subscription and Support 5655-E99
IMS Queue Control Facility for z/OS
Subscription and Support 5655-E90
DB2 Administration Tool for z/OS
Subscription and Support 5655-E89
DB2 High Performance Unload for z/OS
Subscription and Support 5655-E40
DB2 Object Comparison Tool for z/OS
Subscription and Support 5655-E97
DB2 SQL Performance Analyzer for z/OS
Subscription and Support 5655-E28
IMS High Performance Prefix
Resolution for z/OS
Trade-up Prices to DB2 Performance Expert, V1 (5655-I21)
are available for customers who currently have DB2 Performance Monitor V7
(5655-E61), and/or DB2 Buffer Pool Analyzer V1 (5655-E54). The trade-up
prices are supported with unique trade-up price feature numbers and will
be available until March 31, 2003. The price metric is per
Value Unit, and the terms and conditions of the IPLA license apply.
The ordering information for the new products and versions in this
announcement follows.
OTC Medium
Feature Feature
Description Number Number Medium
Program Number 5655-I23
DB2 Administration Tool for 5802 3480
z/OS, V4 Tape
One Value Unit 0001
250 Value Units 0002
Program Number 5655-I19
DB2 High Performance 5802 3480
Unload for z/OS, V2 Tape
One Value Unit 0001
250 Value Units 0002
Program Number 5655-I20
DB2 Object Comparison 5802 3480
Tool for z/OS, V2 Tape
One Value Unit 0001
250 Value Units 0002
OTC Medium
Feature Feature
Description Number Number Medium
Program Number 5655-I21
DB2 Performance Expert 5802 3480
for z/OS, V1 Tape
One Value Unit 0001
250 Value Units 0002
Trade-Up from DB2
Performance Monitor
(5655-E61)
One Value Unit 0003
250 Value Units 0004
Trade-Up from DB2
Buffer Pool Analyzer
(5655-E54)
One Value Unit 0005
250 Value Units 0006
Trade-Up from DB2
Performance
Monitor (5655-E61) and
DB2 Buffer Pool
Analyzer (5655-E54)
One Value Unit 0007
250 Value Units 0008
Program Number 5655-I22
DB2 SQL Performance 5802 3480
Analyzer for z/OS, V2 Tape
One Value Unit 0001
250 Value Units 0002
Program Number 5655-I01
IMS High Availability Large 5802 3480
Database Conversion Aid Tape
for z/OS, V1
One Value Unit 0001
250 Value Units 0002
Program Number 5655-I15
IMS High Performance Prefix 5802 3480
Resolution for z/OS, V2 Tape
One Value Unit 0001
250 Value Units 0002
Subscription and Support
To receive voice technical support via telephone during normal business
hours, and future releases and versions at no additional charge,
Subscription and Support must be ordered. The capacity of Subscription
and Support (Value Units) must be the same as the capacity ordered for
the Product Licenses.
Subscription and Support will be available in the country in which the
agreement is made.
To order, specify the support program number. IBM is also providing
subscription and support for these products via a separately purchased
offering under the terms of the IBM International Agreement for
Acquisition of Support (IAAS). This offering:
-
Includes and extends the support services provided in the base support to
include technical support via telephone during normal business hours.
-
Entitles customers to future releases and versions at no additional
charge. Note that customer is not entitled for new products.
Once subscription and support is ordered, the charges will renew annually
automatically unless cancelled by the customer.
OTC
Reseller
ACS(1) One Year Medium
Feature Feature Feature
Description Number Number Number
Subscription and Support for:
Program Number 5655-I31
DB2 Performance Expert 6621
for z/OS Paper
One Value Unit 0002 0005
250 Value Units 0003 0006
Decline (No charge) 0004
Program Number 5655-I02
IMS High Availability 6610
Large Database Paper
Conversion Aid
for z/OS
One Value Unit 0001 0004
250 Value Units 0002 0005
Decline (No charge) 0003
-
1
-
Annual support charge
Single-Version Charging:
To elect single version charging, the customer must notify and
identify to IBM the prior program and replacement program and the machine
the programs are operating on.
Customized Offerings
Product media is shipped only via Customized Offerings (that is, CBPDO,
ServerPac, and Systempac®). Non-customized items (CDs, diskettes,
source media, media kits) will continue to be shipped via the stand-alone
product.
Terms and Conditions
Sub-Capacity Charges Terms and Conditions
zSeries software charges at less than full machine capacity for eligible
Data Management and Application Development Tools apply when z/OS is
running in z/Architecture (64 bit) mode on an IBM zSeries
900, no other MVS™-based operating system is licensed to that server
and the required information is provided by the customer in accordance
with the applicable terms.
Sub-capacity charges for an eligible AD or DM Tool is based on the z/OS
product defined capacity. To obtain charges at less than full machine
capacity for eligible AD and DM tools, the customer is required to:
-
Determine the MSUs needed for each machine on which the Tools will run.
Only machines on which the customer has implemented sub-capacity WLC
according to the above terms and conditions are eligible for charges at
less than full machine capacity for the Tools.
-
Use the product defined capacity for z/OS (as specified on the
Sub-Capacity Reports submitted to IBM for sub-capacity WLC) as the
sub-capacity (MSUs)for each tool.
-
Submit any additional MSUs and/or Value Units required for each product
along with the current entitlement in Value Units for each Product.
Sub-Capacity Charges for AD and DM Tools
To be eligible for sub-capacity charges for AD and DM Tools, the machine
on which the AD and DM Tools are running must be eligible for WLC
sub-capacity charges terms and conditions. The customer must have signed
the Attachment for zSeries Workload License Charges-Pre-ILM (Z125-6516)
and submitted at least one Sub-Capacity Report to IBM as defined in the
attachment.
With sub-capacity charges, the charge for an eligible AD or DM Tool is
based on the z/OS product defined capacity. To obtain charges at less
than full machine capacity for each eligible AD and DM Tool for each
machine, the customer should:
-
Determine the MSUs needed for the machine on which the Tools will run.
In a data sharing environment, determine the aggregate MSUs needed on the
machine where the tools run. Use the product defined capacity (MSUs) for
z/OS (as specified on the Sub-Capacity Reports submitted to IBM for
sub-capacity WLC) as the sub-capacity (MSUs) for each tool.
-
Submit any additional MSUs and/or Value Units required for each product
along with the current entitlement in Value Units for each product.
-
If the use of sub-capacity pricing terms for AD and DM Tools results in a
reduced requirement for Value Units, thus "freeing up" entitlements,
customers can reallocate the entitlement difference by distributing the
Value Units across a larger or different set of systems, or reserve them
for future growth. There will be no refunds for these "freed up" Value
Units. Subscription and Support volumes and entitlements for existing
contracts will continue to be at the same levels as the acquired
licenses.
Management of the Value Unit entitlements continues to be a customer
responsibility. If one of the following occur on a machine to which AD
or DM Tools are licensed, the customer must determine if additional Value
Units and Subscription and Support need to be ordered for those Tools to
cover the increase:
-
The z/OS defined capacity is increased.
-
The requirements for WLC sub-capacity charges are no longer met.
Licensing:
IPLA. Proofs of Entitlement (PoE) 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.
The following agreements apply for maintenance and do not require
customer signatures:
-
IBM Agreement for Acquisition of Support (Z125-6011)
These products are licensed under the IPLA, and the associated Agreement
for Acquisition of Support, and the Addendum for Support (Z125-6336),
which provides for support with ongoing access to releases and versions
of the program. These programs have a one-time license charge for use of
the program and an ongoing recurring charge for the enhanced support that
includes telephone assistance (voice support for defects during normal
business hours) as well as access to updates, releases, and versions of
the program as long as support is in effect. S/390 and zSeries IBM
Operational Support Services — Support Line is an option for those
customers who desire added services.
IPLA licenses can be transferred from one machine to another within, but
not limited to an enterprise. The customer may aggregate the capacity
for all the processors the product is operated on to achieve a more
economic price. This will result in a single Proof of Entitlement. It
is the customer's responsibility to manage the distribution of Value
Units within the limits of the Entitlement of the Product License.
Limited Warranty:
Yes
Program Services
-
Available until March 31, 2005, for all products in this
announcement except DB2 Performance Monitor for z/OS, V7
-
Available until November 30, 2004, for the previously announced
DB2 Performance Monitor for z/OS, V7 (a 12-month extension)
Money-Back Guarantee:
A 30-day, money-back guarantee, applicable to the first instance per
customer enterprise. The money-back guarantee will commence on the
invoice date.
Copy and Use on Home/Portable Computer:
No
Volume Orders (IVO):
No
Passport Advantage Applies:
No
Software Maintenance Applies:
For Operating System software, the revised IBM Operational Support
Services — Support Line offering will provide support for those
operating systems and associated products that are not available with the
newly announced Software Maintenance offering. This will ensure total
support coverage for your enterprise needs, including IBM and selected
non-IBM products. For complete lists of products supported under both
the current and revised Support Line offering, refer to our Web site at:
For additional information on the revised IBM Operational Support
Services, refer to Services Announcement
601-023
, dated July 10, 2001.
IBM Operational Support Services — Support Line:
Yes
AIX®/UNIX® Upgrade Protection Applies:
No
Entitled Upgrade for Current AIX/UNIX Upgrade Protection Licensees:
No
IBM e(logo)Server iSeries Software Subscription Applies:
No
Variable Charges Apply:
No
Educational Allowance Available:
Yes, a 15% education allowance applies to qualified education
institution customers.
Replaced Programs Replacement Programs
DB2 Administration Tool DB2 Administration
feature of DB2 V6 Tool V4 (5655-I23)
(5645-DB2)
DB2 Administration Tool
for OS/390, V2 (5655-D52)
DB2 Administration Tool
for MVS/ESA(TM), V1 (5688-515)
DB2 High Performance DB2 High Performance
Unload V1 (5697-F44) Unload V2 (5655-I19)
DBT V2 (Fast Prefix IMS High Performance
Resolution Feature) Prefix Resolution V2
(5685-093) (5655-I15)
Prices
Contact your IBM representative for charges information for this
announcement.
Order Now
Use Priority/Reference Code: LE001
Phone: 800-IBM-CALL
Fax: 800-2IBM-FAX
Internet: ibm_direct@vnet.ibm.com
Mail: IBM Atlanta Sales Center
Dept. LE001
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.
Trademarks
-
-
iSeries and zSeries are trademarks of International Business Machines
Corporation.
-
-
The e-business logo, z/OS, IMS, DataPropagator, System/370, MVS, and
MVS/ESA are trademarks of International Business Machines Corporation in
the United States or other countries or both.
-
-
WebSphere, DB2, DB2 Universal Database, OS/390, DB2 Connect, BookManager,
GDDM, S/390, System/390, Systempac, and AIX are registered trademarks of
International Business Machines Corporation in the United States or other
countries or both.
-
-
Windows and Windows NT are registered trademarks of Microsoft
Corporation.
-
-
Java is a trademark of Sun Microsystems, Inc.
-
-
UNIX is a registered trademark is a registered trademark of the Open
Company in the United States and other countries.
-
-
Notes is a trademark of Lotus Development Corporation and/or IBM
Corporation.
-
-
Other company, product, and service names may be trademarks or service
marks of others.
|
