IBM DB2, IMS, and information integration tools expanded and enhanced to help better manage database
environments
IBM United States
Software Announcement 207-319
December 4, 2007
 ENUS207319.PDF (84KB)
|
|
Table of contents
| | Document options |
|
| |
|
Enhanced DB2, IMS, and information integration tools deliver:
-
Administration: DB2 Audit Management Expert for z/OS, V2.1
-
Information integration:
-
WebSphere Replication Server for z/OS, V9.1
-
WebSphere Data Event Publisher for z/OS, V9.1 PTF
-
Performance:
-
DB2 SQL Performance Analyzer for z/OS, V3.2
-
IMS Buffer Pool Analyzer for z/OS, V1.2
-
Recovery:
-
DB2 Log Analysis Tool for z/OS, V3.1
-
IMS Recovery Expert for z/OS, V1.1
-
Utilities:
-
DB2 Accessories Suite for z/OS, V1.2
-
IMS High Performance Fast Path Utilities for z/OS, V3.2
For ordering, contact:
Your IBM representative, an IBM Business Partner, or IBM Americas Call Centers at
800-IBM-CALL
(Reference: LE001).
Back to top
A new product, new versions and releases, and a PTF offer enhancements to help manage DB2®,
IMS™, and information integration environments:
New product: IMS Recovery Expert for z/OS®, V1.1 (5655-R26) supports recovery across multiple IMS
systems.
New versions:
-
DB2 Audit Management Expert for z/OS, V2.1 (5655-T57) provides the ability to selectively audit
inserts, updates, deletes, and reads in DB2 systems.
-
DB2 Log Analysis Tool for z/OS, V3.1 (5655-T56) delivers a powerful tool to ensure high availability
and complete control over data integrity.
New releases:
-
DB2 Accessories Suite for z/OS, V1.2 (5655-R14) has two features that deliver text search and
database application development enhancements.
-
DB2 SQL Performance Analyzer for z/OS, V3.2 (5697-I04) offers functional, usability, and reporting
enhancements to help you better analyze and tune your SQL queries.
-
IMS Buffer Pool Analyzer for z/OS, V1.2 (5697-H77) helps you determine the impact of buffer pool
changes before they are made to take the guesswork out of changes to the process.
-
IMS High Performance Fast Path Utilities for z/OS, V3.2 (5655-R05) contains all the right components
to analyze, maintain, tune, and migrate IMS Fast Path Data Entry Databases (DEDBs).
A PTF makes important new functions available for the following information integration products:
-
WebSphere® Replication Server for z/OS, V9.1 (5655-R55) provides an enhanced level of the
SQL-based data replication and queue-based data replication (Q replication).
-
WebSphere Data Event Publisher for z/OS, V9.1 (5655-R56) makes it easy for data events to initiate
business processes. It provides efficient changed-data publishing environments for
application-to-application integration, business process initiation, critical data event monitoring,
and data population.
To view a complete list of the DB2, IMS, and information integration tools, visit
Back to top
Prerequisites are listed in the
Hardware requirements
and
Software requirements
sections.
Back to top
-
December 14, 2007:
-
DB2 Accessories Suite for z/OS, V1.2 (5655-R14)
-
DB2 Log Analysis Tool for z/OS, V3.1 (5655-T56)
-
DB2 SQL Performance Analyzer for z/OS, V3.2 (5697-I04)
-
IMS Buffer Pool Analyzer for z/OS, V1.2 (5697-H77)
-
IMS High Performance Fast Path Utilities for z/OS, V3.2 (5655-R05)
-
IMS Recovery Expert for z/OS, V1.1 (5655-R26)
-
January 25, 2008: DB2 Audit Management Expert for z/OS, V2.1 (5655-T57)
Back to top
Administration
DB2 Audit Management Expert for z/OS, V2.1 (5655-T57)
provides the ability to selectively audit inserts, updates, deletes, reads, authorization failures,
grants and revokes, and AUTHID changes, as well as command and utility executions in DB2 systems.
Enhancements include:
-
Capture of the SQL statements, both dynamic and static.
-
Capture of the host variable values.
-
SQL DML (update, insert, delete) audit data is collected using an internal collection mechanism
instead of utilizing DB2 audit trace. The audit flag is required to track DDL, utility access, and
commands.
DB2 Audit Management Expert can help your IT staff meet the ever-growing requirements placed on them
for achieving regulatory compliance. This easy-to-use tool allows you to view all reported activity
on specific DB2 tables, generate meaningful reports to report on the data collected in the audit
repository, and perform a log analysis based on collected audit data.
DB2 Audit Management Expert separates the roles of auditing and database administration, freeing up
valuable resources needed to support auditing requests. It removes the requirement that auditors be
privileged users on the systems they are auditing and delivers:
Information integration
WebSphere Replication Server for z/OS, V9.1 (5655-R55) and WebSphere Data Event Publisher for z/OS,
V9.1 (5655-R56)
have important new functions available with PTF for APAR PK49430 that include:
-
Reduce lock contention for z/OS batch jobs: You can now set a maximum number of agents for the Q
Apply program to use when processing transactions that have the same z/OS batch job name or
correlation ID. You set the maxagents_correlid parameter for a replication queue map. This
parameter allows you to reduce lock contention by limiting parallelism for transactions from the
same batch job on a z/OS Q Capture server. Reducing lock contention can lower latency.
-
Replicate and publish XML columns: You can now replicate or publish DB2 XML columns. These columns
are replicated or published in a similar manner to other columns. You can also replicate or publish
these data types to federated targets that support XML columns or you can map XML columns to
character large-object (CLOB) columns or binary large-object (BLOB) columns at the target.
-
New option for sending LOB data for improved performance: You can now replicate or publish LOB data
within the transactions message instead of in a separate LOB message by setting the LOB_SEND_OPTION
to I (inline). When the LOB data is sent in the transaction messages, the Q Capture and Q Apply
programs send fewer messages and the Q Apply program is able to write all the columns at one time.
This new inline option helps to reduce CPU usage at the Q Capture server and significantly improve
throughput at the Q Apply server.
-
Delimited message format for event publishing: WebSphere Data Event Publisher now publishes
delimited messages. The delimited message format is similar to delimited sequential files, but with
the high throughput advantage of WebSphere MQ queues. Changes are read from the recovery log and
transformed into WebSphere MQ messages that use delimiters to separate the column data, records, and
other information. Organizations that now use WebSphere DataStage® Change Data Capture to send
DB2 changes to WebSphere DataStage can take advantage of the messaging infrastructure of event
publishing by using the delimited message format.
-
New option for maintaining target tables: You can now place a Q subscription into a temporary spill
state so that you can perform maintenance on the target table. You use the asnqacmd spillsub
command to put the Q subscription into the spilling state and the asnqacmd resumesub command to
resume normal operations. This new option allows you to take a single table offline for maintenance
rather than many tables.
-
New error action for code-page conversion and option for sending raw data: Previously, when the Q
Capture program encountered a code-page conversion error, the Q Capture program would treat it as a
fatal error and stop. Now, the column is flagged as having an code-page conversion error. You can
also configure publishing queue maps to send raw data in a hexadecimal format when an error occurs
during code-page conversion.
-
New CCD target type in SQL replication avoids join of UOW and CD tables: You now have the option of
replicating to a consistent-change-data (CCD) target table without joining the change-data (CD)
table and the IBMSNAP_UOW table. To use the new table type, specify a value of 9 in the
TARGET_STRUCTURE column of the IBMSNAP_SUBS_MEMBR table. Even though the type 9 CCD table includes
the IBMSNAP_LOGMARKER column, the Apply program does not require a join of the CD table and
IBMSNAP_UOW table to obtain the source commit information for this column. Instead, the Apply
program generates the same value in the IBMSNAP_LOGMARKER column for all of the rows in the same
cycle. The new CCD table type has the same structure as a type 3 CCD table. You can register the
new target table type as a source table for a three-tier replication configuration.
Performance
DB2 SQL Performance Analyzer for z/OS, V3.2 (5697-I04)
delivers an extensive analysis of SQL queries without executing them. This analysis aids you in
tuning your queries to achieve maximum performance. Functional enhancements include:
-
From any input source, the ability to drill down and display all the SQL statements or all the DB2
tables used within the given source is provided. This gives you the ability to selectively explain
at a finer granularity.
-
An option to use the DB2 stored procedure called DSN8.DSN8EXP. This feature can be used to run an
EXPLAIN of an SQL statement without needing the authority to run the SQL. DSN8.DSN8EXP is useful to
your application programmers who need to analyze access paths for queries to ensure they perform
efficiently, yet lack the authority to execute (and therefore explain) the queries against
production objects due to security; for example, sensitive payroll data.
-
A new message is provided when SQL/PA processing encounters a DBRM with no explainable SQL
statements. The message:
-
Lists the DBRM name in the ANLCOST report
-
Reports that no explainable statements were found
-
Easy Explain TSO processing may now use a set of generic plan tables for DB2 Explains to remove the
requirement for individual users to have a unique authid.PLAN_TABLE which:
-
Conserves space
-
Helps handle ad hoc users who do not have their own EXPLAIN output tables
-
Modification of precompiler options and bind process to handle package versioning.
Usability enhancements include:
-
Easy Explain batch processing acceptance of SQL statements where a semicolon to delimit the end of
the statement was unintentionally left off.
-
Ability to selectively allow specification of PROGNAME(s) when processing a retro explain.
-
Enhanced interface to DB2 Query Monitor accepts either a DDNAME or a DSNAME when SQL Performance
Analyzer is called.
-
New ISPF panel displays each SQL statement of a DBRM in a list.
-
The install and customization processes have been simplified by combining these processes for SQL
Performance Analyzer and Easy Explain.
-
TSO access enhancements deliver seamless integration between SQL Performance Analyzer and the Easy
Explain function.
Reporting enhancements include:
-
A parameter is available to control whether the system and user parameters are displayed at the top
of the Enhanced Explain and Trace Reports.
-
When processing SQL statements, both the SQL Performance Analyzer and Easy Explain reports are
available.
-
The ability to use a line command on the QLIMIT report gives you the ability to:
-
Jump into any of the available reports directly to where the query's information is displayed
-
Perform what-if analysis — a query to see what impact a change in the SQL would have on the
selected DB2 access path
-
Format of SQL statements displayed on the COST report improved by breaking the lines based on
keywords; for example, SELECT, FROM, and WHERE.
-
Maximum record length increased from 72 to 255 for SQL Performance Analyzer statements contained in
sequential and PDS data sets.
-
A new parameter controls how SQL Performance Analyzer executes an EXPLAIN either by use of a stored
procedure or, as it is done today, by using embedded SQL. The default is the use of embedded SQL.
This allows you to be granted authority to run performance reports using SQL Performance Analyzer
without affecting your authority on the DB2 level.
-
New parameter controls whether host variable names or parameter markers appear in the COST report
when the SQL statement is displayed.
-
New primary commands are now available for processing input sources:
-
Explain all
-
Show SQL
-
Show tables
-
A title has been added to reports indicating the source of input; for example, PLAN NAME, DBRM,
PACKAGE, and SQL.
IMS Buffer Pool Analyzer for z/OS, V1.2 (5697-H77)
delivers statistical analysis that helps you analyze your current IMS online and batch job buffer
pools. Additionally, it provides the information required to determine whether changes to the
buffer pool configuration would benefit IMS performance.
Every database buffer pool has different characteristics, so it is hard to know how changes might
affect each one. Often, you have to resort to guesswork, hoping that your tuning activities will
not impede I/O rates.
IMS Buffer Pool Analyzer for z/OS is able to:
-
Review your buffer pool environment and recommend changes to the number of buffers in each subpool
to improve performance. Buffer Pool Analyzer makes specific recommendations for the number of
buffers for each subpool and the resulting change in storage usage and reduction in number of
database reads.
-
Review the databases allocated to each subpool and document subpools that include databases with hit
ratios that are inconsistent, providing the information you can use to change your subpool
configuration.
-
Identify storage that is wasted because the most efficient buffer sizes are not available for
database data sets.
-
Determine if adding or subtracting buffers will improve the performance of a selected buffer pool.
-
Model buffer pool usage to determine I/O rates for various numbers of buffers in each pool.
-
Identify which databases most heavily use each database subpool.
-
Provide I/O rates and buffering requirements for a specific database to facilitate required buffer
pool changes for database structure alterations.
-
Perform "what if" scenario analysis, including the impact of creating new buffer pools or changing
the buffer size of a database.
-
Visualize the impact of change — before it is too late.
For both the actual buffer pool configuration and a model configuration (with different buffer pool
or database data set assignments), IMS Buffer Pool Analyzer for z/OS provides a report for each
subpool that shows:
-
Subpool information, including the pool configuration, buffer request rate and actual performance
information.
-
Database information, including a list of all the database data sets with activity in that subpool,
along with the hit ratio, buffer request rate, and I/O rate for each data set.
-
Projections, including various buffer pool sizes, subpool hit ratio, I/O rate, and buffer life.
-
In addition, for each buffer pool size projection, IMS Buffer Pool Analyzer for z/OS calculates a
number that can be used to compare subpools. The marginal reduction shows which subpools would
reduce I/O the most, per 1 KB of storage added to the pool.
IMS Buffer Pool Analyzer for z/OS is extended to deliver the following new features and functional
improvements:
-
Model impact of database access method or buffer size change.
-
Buffer pool statistics for FP DEDB databases.
-
Recommendations for changes to the number of buffers allocated to each subpool.
-
Suggestions for review, including inconsistent hit ratio databases sharing the same subpool, and
databases that do not have the most efficient buffer sizes available.
-
New buffer pool allocation report.
Recovery
DB2 Log Analysis Tool for z/OS, V3.1 (5655-T56)
delivers a powerful tool to ensure high availability and complete control over data integrity. It
allows you to monitor data changes by automatically building reports of changes that are made to
database tables. Version 3.1 includes the following enhancements.
-
Use of current table space dictionary: A current table space dictionary can be used while running
in log-forward mode. Previously, every dictionary needed to decompress row data, required reading
an image copy when running in log-forward mode. Now the product can determine if it can use a
current table space dictionary, which may avoid any image copy reads entirely, assuming no other
data is required from the image copy. This can result in performance improvements.
-
Automatic determination of table space names: When running in Expert Mode, if only current table
space reads are needed for input, the product can determine which table space dataset names are
needed. This alleviates the need to type in, potentially, many dataset names if the table space is
partitioned.
-
Limited support for table versioning: DB2 V8 introduced the concept of table versioning, or
altering a column data type. For example, you can change a SMALLINT to an INTEGER column data type.
Log Analysis Tool delivers support for table versioning where possible; however, due to the nature
of table versioning, the support is limited and may require manual intervention.
-
Removing compensation log records: When processing rollbacks, you can now control whether the
compensation log records are included in the output. Removing compensation records can decrease the
amount of data tracked.
-
Current row exclusion: Current row information can be omitted from log-backward reports. This
represents a 33% reduction in certain file sizes, as well as the detail report itself. If you don't
need to see current row information, it is recommended it be omitted.
-
Trigger support: Triggers are now identified in reports. Where possible, trigger support has been
added to SQL generation.
-
Hexadecimal values for filters: Hexadecimal values can now be provided for column-level filtering.
-
Sending messages to SYSOUT: Informational messages have always been written to the job log. These
messages prevent unnecessary re-runs for diagnostic purposes. Most of these messages can now be
directed to SYSOUT, rather than to your system log and job log. This reduces the number of messages
going to your system log. In some cases, messages will still be written to the job log, but these
will be minimal.
-
Load general reports into a DB2 table: General report output can now be loaded back into a DB2
table. Previous releases have only allowed detail report output to be loaded back into DB2.
-
Updated user interface: The look-and-feel of product panels and help for those panels now conforms
to generally accepted IBM ISPF guidelines. Note that many panels are now scrollable and contain
more input fields below the original view.
-
User-controlled file allocation: Dynamic allocation of many of the files needed by the product was
introduced in Version 2.3. Some users prefer having complete control over those datasets. This
release allows you to override the default behavior (dynamic allocation of files) and instead
include all needed files in the JCL as hard-coded values (similar to pre-2.3 releases).
The User settings panel gives you this ability and can be changed as wanted for each run of the
product. Note that there are many such files, and when overriding the product's default behavior
(of dynamically allocating files), the generated JCL will be much longer as it will include all
these files in hard-coded format.
-
Support for large object (LOB) and XML data types: LOB and XML data types are now supported for
some operations. LOB data can be viewed, included in SQL operations if using DB2 9, or later, and
included in LOAD operations if using DB2 V7, or later, with the appropriate DB2 PTFs applied. XML
data can be viewed and used in SQL and in LOAD operations. Both of these potentially large objects
require the DB2 "file-by-reference" feature for support in SQL and LOAD operations, and the above
restrictions reflect DB2's current support level in these areas.
-
One-phase mode processing: New methods of processing the general and detail reports, along with
LOAD options, have been introduced. These new methods fall under the term " one-phase mode."
Effectively, this means processing for all these tasks can now be accomplished in a single job step,
or in one phase. These new methods of processing are provided for performance improvements and also
greatly reduce the number of files you need to manage.
-
Multi-level security support: MLS support is now provided. Multi-level security provides
authorizations down to the row level within a table. If a user is not allowed to view the row due
to MLS definitions, Log Analysis Tool will not allow the user to view the row either.
-
Log reading in parallel: Log reading parallelism has been extended to nondata sharing groups. In
past releases, reading logs in parallel was only possible if operating in a data sharing
environment, and each separate member's logs could be read in parallel. Now, parallelism is by log,
not member, so data sharing is no longer a determining factor. The "User settings" panel still
provides the "Log read parallelism maximum" field, which a site can use to control the maximum
number of subtasks to handle reading logs in parallel.
-
Mode report to aid in diagnostics: For diagnostic purposes, a new DD has been added to JCL
involving general and detail reports. This DD, named MODERPT, will contain output reflecting both
user-defined values and product-determined values in the MODEFILE. Different programs can modify
the values contained therein, so multiple occurrences of these reports will be output during general
and detail reporting. The product-determined values are output exclusively to aid the vendor in
diagnostics. The user-defined values reflect values set by the user prior to executing the JCL.
These reports are only available with V3.1 generated JCL. If you migrated from V2.3 and did not
regenerate V3.1 JCL, the DDs for MODERPT will be missing, and no reports will be possible.
-
MODEFILE operations for using new release: A new section in "User Settings" allows you to convert a
MODEFILE from a previous release to the 3.1 version, making it easier to convert your jobs. You can
examine the MODEFILE contents from past releases so you do not have to remember what settings you
used previously to regenerate your JCL for 3.1. You can also convert the MODEFILE and it will fill
in the panels for regenerating the JCL.
-
New advanced filter: The NC advanced filter allows a column level filter where the value did not
change. This complements the previously existing filter CH, to filter on a column value that
changed.
-
Bypass column level formatting: You can bypass column level formatting when running a detail report.
This can result in performance improvements. When requested, and if allowed by the product, raw row
data will not be formatted into displayable row data. See the User Settings panel for more
information.
-
Backup image copy support: Image copy backups are now supported. If the primary image copy is
unavailable, a backup copy will automatically be used, if available. No input from you on this
process is required.
IMS Recovery Expert for z/OS, V1.1 (5655-R26)
is a new addition to the IMS Tools product portfolio that provides features to ensure that your IMS
database environment is recoverable. The product inspects information that is stored in the RECON
data sets, system catalogs, and in the repositories of IBM IMS Tools Knowledge Base for z/OS, V1.1
(5655-R34) and detects problems that can affect database recovery. It provides the ability to
create clean recovery points across multiple IMS systems and performs synchronized log switches.
IMS Recovery Expert for z/OS offers features to determine valid database recovery points, makes sure
that all of the resources necessary to perform a recovery are present, and provides the ability to
manage the RECON data sets to ensure that they match the disaster recovery environment.
Features that you can utilize:
-
Recovery Point Create: Allows you to create a recovery point for one or more databases by issuing
/DBR or /DBD commands against the databases, waiting for the databases to become unallocated on all
systems, and then restarting them. Additionally, a synchronized log switch feature is provided that
performs a /SWI OLDS command on all active systems in the group.
-
Recovery Point Identification: Reads information in the RECON data sets to determine common
recovery points for one or more databases.
-
Recovery Assets Verification: Examines the RECON data sets and generates a list of the recovery
assets that are needed to recover one or more databases. This feature performs one or all of the
following functions:
-
List or print the recovery assets required to recover the specified databases
-
Allocate all recovery assets in order to ensure that they exist
-
Open all recovery assets to ensure that they are valid
-
RECON Clean Up: Allows you to prepare a set of RECON data sets for your disaster recovery
environment by modifying the contents of the RECON data sets to match your disaster recovery site.
-
Recovery Health Check: Consists of many different options to check and verify the recoverability of
your environment. This feature inspects and verifies information in the RECON data sets.
Additionally, it validates the information in the RECON data sets against information outside the
RECON data sets (for example, the z/OS catalog).
-
IMS Command: Allows you to issue IMS commands in batch to active IMS subsystems and view the output
from those commands.
IMS Tools Knowledge Base for z/OS is also used to store information relating to various existing IMS
environments. The information is stored in the form of RECONID records. For example, RECON data
set name, IMS Tools Online System Interface XCF group, IMSPlex name, and command security
information is saved.
In order to reduce the impact to active IMS subsystems, IMS Recovery Expert provides an option to
create and access a copy of the RECON data sets instead of accessing the RECON data sets currently
in use by the online systems. The RECON copy operation is performed dynamically based on parameters
that you specify.
IMS Recovery Expert utilizes the DBRC Application Programming Interface to access information in the
RECON data sets.
IMS Recovery Expert executes as a batch job that you or the job scheduler can submit. There is no
need for IMS Recovery Expert to have an active address space up and running to service requests.
Everything is contained in a single address space.
Utilities
DB2 Accessories Suite for z/OS, V1.2 (5655-R14)
consists of two features that are made up of a series of independent components designed to enhance
your use of the DB2 for z/OS data server. Its initial release provided support for:
-
Enhanced SQL tuning
-
Spatial data support
-
Unicode and internationalization operations
DB2 Accessories Suite V1.2 and its Subscription and Support offering (5655-R30) now have two
features. One or both of these features must be specified when ordering.
-
OmniFind™ Text Search Server is delivered in the enhanced DB2 Accessories Suite feature.
-
Data Studio capabilities are delivered in the new Data Studio feature.
OmniFind Text Search Server in the DB2 Accessories Suite feature is an easy-to-use facility to help
you search text information stored in a DB2 for z/OS database. This is important because the key in
any organization is to get the right information to the right people at the right time. Industry
experts state that as much as 70% of an employee's time is spent searching for information.
OmniFind Text Search Server for DB2 for z/OS lets you speed and simplify your enterprise data
searches.
-
It is a highly scalable, highly available search solution that allows you to issue SQL statements to
satisfy familiar text search queries on data stored in a DB2 for z/OS database. Its text search
feature is built on the index and search strengths of IBM OmniFind Yahoo Edition V8.5.
-
It is fully supported in a DB2 for z/OS data sharing Parallel Sysplex® environment.
-
Leveraging the unique security and performance of the System z™ platform, OmniFind Text Search
Server for DB2 for z/OS provides a single focal point to efficiently search and retrieve text
information found in various forms, including PDF, Lotus® 1-2-3®, Lotus Word, Microsoft®
Excel, Microsoft Word DOC, HTML, Lotus Freelance®, Microsoft PowerPoint, and TXT files, just to
name a few.
-
Its architecture employs the concept of keeping a master index in a DB2 table, which allows access
to the index from all DB2 subsystems in a data sharing group and from all multiple OmniFind servers.
This also provides a takeover capability, which allows the assignment of a different OmniFind server
for a collection if multiple servers are defined as search servers and one fails.
-
It is available in 20 languages.
The functions of the Data Studio feature help you reduce the time required for database application
development tasks. They provide a comprehensive data management solution that empowers you to
effectively design, develop, deploy, and manage your data, databases, and database applications
throughout the data management life cycle of DB2 for z/OS applications. A consistent and integrated
user interface is used. Functions included are:
-
Physical data modeling
-
Data distribution viewer
-
Integrated query editor
-
SQL builder
-
SQL routine debugger
-
Java™ routine debugger
-
XML editor
-
XML schema editor
-
Data Web services
-
Object management
-
Data management
-
Update statistics
-
Visual explain
-
Security access controls
-
Project management
DB2 Accessories Suite remains a no-charge offering, helping you achieve immediate return on your
investment, because there are no upfront costs associated with the product.
IMS High Performance Fast Path Utilities for z/OS, V3.2 (5655-R05)
is composed of IMS Fast Path Advanced Tool, IMS Fast Path Online Tools, and IMS Fast Path Basic
Tools. It provides all functions of the previous release and is enhanced as follows:
-
IMS Fast Path Advanced Tool improves JCL ease-of-use by enabling you to use the same JCL for various
functions by merely changing the command name. By using this tool, you can easily and quickly
develop a standard, single driver for unloading, reloading, reorganizing, analyzing, and extracting
multiple Data Entry Database (DEDB) areas. Additionally, it integrates various tool functions and
improves processing efficiency and greatly reduces the time and resources required for database
administration in parallel in a single job step.
IMS Fast Path Advanced Tool has the following
enhancement:
-
The Reorganize function enables reorganizing multiple DEDB areas in place without using shadow data
sets. It also enables the reorganization of a set of units of work (UOWs) in a DEDB area based on
RBASEFS and RDOVFFS criteria. You can select the analysis and the image copy options as
subfunctions. When selected, the analyze function runs and the image copy data sets are generated
after the reorganization is completed.
-
IMS Fast Path Online Tools run in an online IMS environment and provide the interface to the IMS
Fast Path Advanced Tool and to the IMS Fast Path Basic Tools. IMS Fast Path Online Tools consist of
Online Pointer Checker, Online Data Extract, Online Area Extender, Online Expert Reorganization, and
Online DMAC Print. You can use these utilities to boost system availability by performing a variety
of key functions without having to take your IMS database offline.
Online Pointer Checker has the following enhancements:
-
Performs the DEDB integrity verification in a single step.
-
Provides the reports that contain statistical information about the DEDB areas in a single step.
These reports are compatible with the ones produced by the Fast Path Advanced Tool Analyze function.
It writes historical records at the same time.
The commands and their keywords for these utilities are specified in a single input stream and no
longer as a combination of SYSIN or another input stream as was required by IMS High Performance
Fast Path Utility for z/OS, V2.2.
-
IMS Fast Path Basic Tools include DEDB Unload/Reload, DEDB Pointer Checker, and DEDB Tuning Aid.
Additional utilities are included for compatibility reasons.
Accessibility by people with disabilities
You can request a U.S. Section 508 Voluntary Product Accessibility Template (VPAT) with details on
accessibility compliance at
Section 508 of the U.S. Rehabilitation Act
The products in this announcement are capable as of their general availability, when used in
accordance with IBM's associated documentation, of satisfying the applicable requirements of Section
508 of the Rehabilitation Act, provided that any assistive technology used with the product properly
interoperates with it.
Value Unit-based pricing
Value Unit pricing for eligible IBM eServer® System z IBM International Program License Agreement
(IPLA) programs enables a lower cost of incremental growth and enterprise aggregation. Each System
z IPLA product with Value Unit pricing, has a single price per Value Unit and a conversion matrix,
called Value Unit Exhibit, for converting from some designated measurement to Value Units. Most
commonly, Millions of Service Units (MSUs) is the measurement designated by IBM to be converted to
Value Units. Some other measurements are engines or messages. Since MSUs are the most common
measurement, that measurement will be used for the remainder of this description.
Value Unit pricing offers price benefits for you. For each System z IPLA program with Value Unit
pricing, the quantity of that program needed to satisfy applicable IBM terms and conditions is
referred to as the
required license capacity.
Each of the various Value Unit Exhibits stipulate that the larger your required license capacity,
the fewer Value Units per MSU you will need. Value Unit Exhibits are uniquely identified by a
three-digit code and referred to using the nomenclature VUExxx, where xxx is the three-digit code.
Subsequent acquisitions of Value Unit priced programs offer additional price benefits. The quantity
of each System z IPLA program that you have acquired is referred to as
entitled license capacity.
If you wish to grow your entitled license capacity for a System z IPLA program, the calculation to
determine additional needed Value Units is based upon the number of Value Units already acquired.
For each System z IPLA program with Value Unit pricing, you should:
-
Determine the required license capacity, in MSUs
-
Aggregate the MSUs across the enterprise
-
Convert the total MSUs to Value Units, using the applicable Value Unit Exhibit
-
Multiply the price per Value Unit by the total number of Value Units to determine the total cost
To simplify conversion from the designated measurement to Value Units or vice-versa, use the Value
Unit Converter Tool. For additional information or to obtain a copy of the Value Unit Converter
Tool, visit the Value Unit Converter Tool Web site
Note that Value Units of a given product cannot be exchanged,
interchanged, or aggregated with Value Units of another product.
To determine the required license capacity for the System z IPLA program
you selected, refer to the
Terms and conditions
section.
Business Partner information
If you are a Direct Reseller - System Reseller acquiring products from IBM, you may link directly to
Business Partner information for this announcement. A PartnerWorld ID and password are required
(use IBM ID).
BP Attachment for Announcement Letter 207-319
Trademarks
-
-
IMS, OmniFind, and System z are trademarks of International Business Machines Corporation in the
United States or other countries or both.
-
-
DB2, z/OS, WebSphere, DataStage, Parallel Sysplex, Lotus, 1-2-3, Freelance, and eServer are
registered trademarks of International Business Machines Corporation in the United States or other
countries or both.
-
-
Microsoft 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.
Back to top
Product information is available via the Offering Information Web site
Back to top
The IBM Publications Center portal is at
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. Payment options for orders are
via credit card or customer number. A large number of publications are
available online in various file formats. They can all be downloaded
free of charge.
One copy of the following publications is supplied automatically with the
basic machine-readable material.
Title Order number
DB2® Accessories Suite for z/OS®, V1.2 (5655-R14)
License Information GC19-1111
Program Directory GI10-8749
DB2 Audit Management Expert for z/OS, V2.1 (5655-T57)
License Information GC19-1300
Program Directory GI10-8771
DB2 Log Analysis Tool for z/OS, V3.1 (5655-T56)
License Information GC19-1301
Program Directory GI10-8772
DB2 SQL Performance Analyzer for z/OS, V3.2
(5697-I04)
License Information GC18-9823
Program Directory GI10-8707
IMS™ Buffer Pool Analyzer for z/OS, V1.2 (5697-H77)
License Information GC18-7067
Program Directory GI10-8486
IMS High Performance Fast Path Utilities for z/OS,
V3.2 (5655-R05)
License Information GC18-9868
Program Directory GI10-8710
IMS Recovery Expert for z/OS, V1.1 (5655-R26)
License Information GC18-9872
Program Directory GI10-8711
The publications for the products in this announcement cannot be ordered
in hardcopy. All the publications in this announcement are available at
Publications are available in PDF and BookManager® formats on CD-ROM
and on DVD on the next release of the software product libraries:
-
z/OS Software Products CD Collection Kit (SK3T-4270)
-
z/OS and Software Products DVD Collection (SK3T-4271) (requires a DVD
drive in DVD-9 (single-sided, dual-layer) format)
Title Order number
DB2 Accessories Suite for z/OS, V1.2 (5655-R14)
IBM Spatial Support for DB2 for z/OS User's Guide and GC19-1145
Reference
Getting Started -- IBM Optimization Service Center for GC19-1143
DB2 for z/OS
IBM OmniFind(TM) Text Search Server for DB2 for z/OS GC19-1146
Installation, Administration, and Reference
DB2 Audit Management Expert for z/OS, V2.1 (5655-T57)
User's Guide SC19-1302
DB2 Log Analysis Tool for z/OS, V3.1 (5655-T56)
User's Guide SC19-1303
DB2 SQL Performance Analyzer for z/OS, V3.2
(5697-I04)
User's Guide SC18-9824
IMS Buffer Pool Analyzer for z/OS, V1.2 (5697-H77)
User's Guide SC18-7068
IMS High Performance Fast Path Utilities for z/OS,
V3.2 (5655-R05)
User's Guide: Volume 1 High Performance Fast Path SC18-9869
Reorganization Tool
User's Guide: Volume 2 Fast Path Basic Tools SC18-9870
User's Guide: Volume 3 Fast Path Online Tools SC18-9871
IMS Recovery Expert for z/OS, V1.1 (5655-R26)
User's Guide SC18-9873
The following material is available at
-
Overview brochure: IBM DB2 and IMS Tools Overview (IMD11760-USEN)
-
Fact sheet:
-
DB2 Audit Management Expert for z/OS (IMD11752-USEN)
-
DB2 Log Analysis Tool for z/OS (IMD14004-USEN)
-
DB2 SQL Performance Analyzer for z/OS (IMD14003-USEN)
-
IMS Buffer Pool Analyzer for z/OS (GC18-7193)
-
IMS High Performance Unload for z/OS (GC27-1065)
-
IMS Recovery Expert for z/OS (IMD14000-USEN)
Specification sheets, user's guides, and white papers are also available
on CD-ROM (GK3T-7099). This CD-ROM can be ordered from the IBM
Publications Center Portal at
Back to top
Hardware requirements
The products in this announcement will operate on any S/390® hardware configuration that supports
the required versions of DB2 and IMS.
DB2 Accessories Suite for z/OS, V1.2:
-
Data Studio component requires:
-
512 MB RAM (1 GB recommended)
-
300 to 600 MB of disk space, depending on the functions selected
-
Omnifind Text Search Server component requires:
-
Two dual-core 2.66 GHz processors
-
4 GB RAM
-
Enough disk space to hold four times the original text size for each collection
The DB2 Audit Management Expert client will operate on any hardware capable of running Windows® XP
with a minimum of:
-
150 MB free disk space
-
512 MB memory
Software requirements
Software requirements for the DB2 products in this announcement
DB2 Accessories Suite for z/OS, V1.2:
-
Data Studio feature supports:
-
Microsoft® Windows Vista® Business, Enterprise, Ultimate
-
Microsoft Windows 2000 Professional x86-32 with Service Pack 3 or 4
-
Microsoft Windows 2000 Advanced Server x86-32 with Service Pack 4
-
Microsoft Windows 2000 Server x86-32 with Service Pack 3 or 4
-
Microsoft Windows Server 2003 Enterprise Edition x86-32 with Service Pack 1
-
Microsoft Windows Server 2003 Enterprise Edition x86-64 (run in 32-bit mode) with Service Pack 1
-
Microsoft Windows Server 2003 Standard Edition x86-32 with Service Pack 1
-
Microsoft Windows Server 2003 Standard Edition x86-64 (run in 32-bit mode) with Service Pack 1
-
Microsoft Windows XP Professional x86-32 with Service Pack 1 or 2
-
Microsoft Windows XP Professional x86-64 Edition (run in 32-bit mode) with Service Pack 1 or 2
-
Red Hat Enterprise Linux™ 4 Update 4 (32-bit)
-
SUSE Linux Enterprise Server (SLES) 9 (all service packs; running in 32-bit mode)
-
SLES 10 (32-bit mode)
-
DB2 for z/OS V8 and V9
-
DB2 Accessories Suite 1.2 feature requires DB2 for z/OS V9. In addition:
-
Omnifind Text Search Server component requires IBM Java™ Runtime 1.5 SR4 and one of the following:
-
32-bit Red Hat Enterprise Linux 5 with the latest updates
-
32-bit SLES 10
-
32-bit Windows Server 2003 with the latest service pack
-
Omnifind search support in DB2 for z/OS requires:
-
z/OS, V1.7, or later, or z/OS.e V1.7, or later, with PTF UK14217 for APAR PK09128 for authorized
Language Environment® socket support.
-
DB2 V9.1 (5635-DB2) with APAR PK48212 for operation.
-
IBM International Components for Unicode (ICU) for DB2 for z/OS with PTF UK29820 for APAR PK48213.
ICU is included with DB2 Accessories Suite.
DB2 Audit Management Expert for z/OS, V2.1, DB2 Log Analysis Tool for z/OS, V3.1, and DB2 SQL
Performance Analyzer for z/OS, V3.2 require:
-
Operating systems: z/OS, V1.7 (5694-A01), or later, or z/OS.e V1.7 (5655-G52), or later
-
One of the following DB2 versions:
-
DB2 V7.1 (5675-DB2)
-
DB2 V8.1 (5625-DB2)
-
DB2 V9.1 (5635-DB2)
DB2 Audit Management Expert for z/OS, V2.1:
-
Client requires:
-
Windows XP Professional (32-bit)
-
DB2 JDBC Driver V2.3.63, or later
-
DB2 UDB for Windows DB2 Connect® to enable the connection to the DB2 Audit Management Expert
repository
-
Server: Requires DB2 Utilities Suite for z/OS, V7.1, V8.1, or V9.1, corresponding to the version of
DB2 for z/OS you have installed, be installed and available.
DB2 Log Analysis Tool for z/OS, V3.1 requires APAR PK43912 for H25F132 DB2 Change Accumulation —
FEC Common Code.
Software requirements for the IMS products in this announcement
Operating systems: z/OS V1.7 (5694-A01), or later
One of the following IMS versions:
-
IMS V8.1 (5655-C56)
-
IMS V9.1 (5655-J38)
-
IMS V10.1 (5635-A01)
IMS HP Fast Path Utilities for z/OS, V3.2 has the following operational requirements:
-
IMS V8.1 (5665-C56) with APAR PK15110 for one input DD statement.
-
IMS V9.1 (5665-J38) with APAR PK15111 for one input DD statement.
-
IMS V10.1 (5635-A01) includes the required support, so an APAR is not needed.
Additionally, IMS HP Fast Path Utilities for z/OS, V3.2 has the following functional requirements:
-
z/OS V1.7, or later, (includes DFSORT™) or a functionally equivalent sort program for function
Pointer Checker and for Restructure/Reorganization functions
-
IMS HP Image Copy for z/OS, V4.1 (5655-N45) at current maintenance level for Fast Path Advanced Tool
with Image Copy, Fast Path Basic Tools Reload with Image Copy, and Online Pointer Checker with Image
Copy Compression
Fast Path Online Tools requires one of the following:
-
IMS V8.1 (5665-C56) with APAR PK25289 for Online Data Extract and Online DMAC Print AREA=ALL option.
-
IMS V9.1 (5665-J38) with APAR PK25294 for Online Data Extract and Online DMAC Print AREA=ALL option.
-
IMS V10.1 (5635-A01) includes the required support, so an APAR is not needed.
IMS Recovery Expert for z/OS, V1.1 requires:
-
IMS V9.1 (5655-J38) with APAR PK51813
-
IMS Tools Knowledge Base for z/OS, V1.1 (5655-R34) for storing and retrieving report output data
Customer requirements
Customer requirements are used extensively to determine how database tools evolve.
DB2 Audit Management Expert for z/OS, V2.1 (5655-T56) satisfies the following requirements:
MR0308075313 MR0308077136 MR1202066016
Customer requirements are used extensively to determine how database tools evolve.
DB2 Log Analysis Tool for z/OS, V2.1 (5655-T57) satisfies the following requirements:
MR0128034847 MR0204036254 MR021307140 MR0308054056
MR0314067630 MR0316062033 MR0317056940 MR0318055133
MR0331062449 MR0415053211 MR0501052458 MR0510045742
MR0701045536 MR0717063049 MR0819047210 MR083006364
MR1007042113
DB2 SQL Performance Analyzer for z/OS, V3.2 (5697-I04) satisfies the following requirements:
MR020107511 MR0221066413 MR0320064518 MR032906164
MR032906341 MR0329063830 MR0329064255 MR0329066559
MR0509063125 MR0625014230 MR0811062822 MR1111056059
MR1123056157 MR112306742 MR113005626 MR121605163
MR1228053648
IMS Buffer Pool Analyzer for z/OS, V1.2 (5697-H77) satisfies the following requirement:
MR0412072823
IMS High Performance Fast Path Utilities for z/OS, V3.2 (5655-R05) satisfies the following
requirements:
MR1110056510 MR1116055936 MR1128055553
IMS Recovery Expert for z/OS, V1.1 (5655-R26) satisfies the following requirements:
MR0606055419 MR0614054850
Planning information
Packaging:
The programs in this announcement are distributed with the following content:
-
Basic machine-readable material on tape
-
Program Directory
-
Proof of Entitlement (PoE)
-
IBM International Program License Agreement (IPLA)
In addition, DB2 Accessories Suite for z/OS, V1.2 is distributed with client code on CDs and DVDs.
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.
Software Services
IBM Software Services has the breadth, depth, and reach to manage your services needs. You can
leverage the deep technical skills of our lab-based, software services team and the business
consulting, project management, and infrastructure expertise of our IBM Global Services team. Also,
we extend our IBM Software Services reach through IBM Business Partners to provide an unmatched
portfolio of capabilities. Together, we provide the global reach, intellectual capital, industry
insight, and technology leadership to support any critical business need.
To learn more about IBM Software Services or to contact a Software Services sales specialist, visit
Back to top
Charge metric
PID Charge
Program name number metric
DB2 Accessories Suite for z/OS, V1.2 5655-R14 Installs
and
Value Unit
DB2 Audit Management Expert for z/OS, V2.1 5655-T57 Value Unit
DB2 Log Analysis Tool for z/OS, V3.1 5655-T56 Value Unit
DB2 SQL Performance Analyzer for z/OS, V3.2 5697-I04 Value Unit
IMS Buffer Pool Analyzer for z/OS, V1.2 5697-H77 Value Unit
IMS High Performance Fast Path Utilities for 5655-R05 Value Unit
z/OS, V3.2
IMS Recovery Expert for z/OS, V1.1 5655-R26 Value Unit
DB2 Accessories Suite for z/OS, V1.2 is a no-charge product. It has the following two features:
-
The DB2 Accessories Suite 1.2 feature charge metric is No Charge Unlimited Installs.
-
The Data Studio feature charge metric is Value Units. There is no charge per Value Unit.
All the other programs in this announcement have Value Unit-based pricing.
Value
Program Unit
number Program name Exhibit
5655-R14 DB2 Accessories Suite for z/OS, V1.2
-- DB2 Accessories Suite 1.2 feature N/A
-- Data Studio feature VUE007
5655-T57 DB2 Audit Management Expert for z/OS, V2.1 VUE007
5655-T56 DB2 Log Analysis Tool for z/OS, V3.1 VUE007
5697-I04 DB2 SQL Performance Analyzer for z/OS, V3.2 VUE007
5697-H77 IMS Buffer Pool Analyzer for z/OS, V1.2 VUE007
5655-R05 IMS High Performance Fast Path Utilities for VUE007
z/OS, V3.2
5655-R26 IMS Recovery Expert for z/OS, V1.1 VUE007
For each IBM eServer® zSeries® IPLA program with Value Unit pricing, the quantity of that
program needed to satisfy applicable IBM terms and conditions is referred to as the "required
license capacity." Your required license capacity is based upon the following factors:
-
The zSeries IPLA program you select
-
The applicable Value Unit Exhibit
-
The applicable terms
-
Whether your current mainframes are full-capacity or sub-capacity
Value Unit exhibit VUE007
MSUs MSUs
minimum maximum Value Units/MSU
Base 1 3 1
Tier A 4 45 0.45
Tier B 46 175 0.36
Tier C 176 315 0.27
Tier D 316 + 0.2
Value Units for mainframes without MSU ratings:
Hardware Value Units/machine
MP3000 H30 6
MP3000 H50 8
MP3000 H70 12
ESL Models 2
Ordering example
The total number of Value Units is calculated according to the following example.
If your required license capacity is 1,500 MSUs for your selected System z™ IPLA product, the
applicable Value Units would be:
Translation from MSUs to Value Units
MSUs * Value Units/MSU = Value Units
Base 3 * 1.00 = 3.00
Tier A 42 * .45 = 18.90
Tier B 130 * .36 = 46.80
Tier C 140 * .27 = 37.80
Tier D 1,185 * .20 = 237.00
Total 1,500 343.50
When calculating the total number of Value Units, the sum is to be rounded up to the next integer.
Ordering z/OS through the Internet
ShopzSeries provides an easy way to plan and order your z/OS ServerPac or CBPDO. It will analyze
your current installation, determine the correct product migration, and present your new
configuration based on z/OS. Additional products can also be added to your order (including
determination of whether all product requisites are satisfied). ShopzSeries is available in the
U.S. and several countries in Europe. In countries where ShopzSeries is not available yet, contact
your IBM representative (or IBM Business Partner) to handle your order via the traditional IBM
ordering process. For more details and availability, visit the ShopzSeries Web site at
Basic license
On/Off Capacity on Demand (On/Off CoD)
DB2 Accessories Suite for z/OS, V1.2 (5655-R14):
-
The DB2 Accessories Suite 1.2 feature is not eligible for On/Off CoD with
a temporary use charge calculated based on MSUs per-day usage. It is a
no-charge feature for unlimited installs.
-
The Data Studio feature is eligible for On/Off CoD. However, there is no
charge for the calculated MSUs per-day usage.
The remaining products in this announcement are eligible for On/Off CoD
with a temporary use charge calculated based on MSUs per-day usage.
The On/Off CoD ordering information for the following products has not
changed. Therefore, On/Off CoD ordering information is not included for
them in this announcement.
Product name PID
DB2 SQL Performance Analyzer for z/OS, V3.2 5697-I04
IMS Buffer Pool Analyzer for z/OS, V1.2 5697-H77
IMS High Performance Fast Path Utilities for z/OS, V3.2 5655-R05
The On/Off CoD ordering information follows for the remaining products in
this announcement.
DB2 Accessories Suite for z/OS, V1.2
Program PID: 5655-R14
Entitlement License option/
Identifier Description Pricing metric
S014KSF Data Studio Basic OTC, Per MSU-day TUC
DB2 Audit Management Expert for z/OS, V2.1
Program PID: 5655-T57
Entitlement License option/
Identifier Description Pricing metric
S014J6P DB2 Audit Management Exp V2 Basic OTC, Per MSU-day TUC
DB2 Log Analysis Tool for z/OS, V3.1
Program PID: 5655-T56
Entitlement License option/
Identifier Description Pricing metric
S014J6K DB2 Log Analysis Tool V3 Basic OTC, Per MSU-day TUC
IMS Recovery Expert for z/OS, V1.1
Program PID: 5655-R26
Entitlement License option/
Identifier Description Pricing metric
S012HF6 IMS Recovery Expert Basic OTC, Per MSU-day TUC
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
To order, specify the program product number and the appropriate license
or charge option. Also, specify the desired distribution medium. To
suppress shipment of media, select the license-only option in CFSW.
The ordering information for the following products has not changed.
Therefore, ordering information is not included for these products in
this announcement.
Product name PID
Subscription and Support for DB2 Audit Management Expert 5697-K16
Subscription and Support for DB2 Log Analysis Tool 5655-E86
DB2 SQL Performance Analyzer for z/OS, V3.2 5697-I04
Subscription and Support for DB2 SQL Performance Analyzer 5655-E97
IMS Buffer Pool Analyzer for z/OS, V1.2 5697-H77
Subscription and Support for IMS Buffer Pool Analyzer 5697-H78
IMS High Performance Fast Path Utilities for z/OS, V3.2 5655-R05
Subscription and Support for IMS High Performance Fast 5655-E36
Path Utilities
The ordering information for the other products in this announcement
follows:
Program Name: DB2 Accessories Suite for z/OS, V1.2
Program PID: 5655-R14
The following is a summary of the license option and pricing metric
information offered for the above PID number.
One or both of the
following features may be ordered.
Entitlement License option/
Identifier Description Pricing metric
S012HFX DB2 Accessories Suite 1.2 Unlimited Installs
Basic No Charge
Orderable Supply ID Language Distribution Medium
S013JV3 US English 3480 Tape Cartridge
Entitlement License option/
Identifier Description Pricing metric
S014KSF Data Studio Basic OTC, Value Units
Orderable Supply ID Language Distribution Medium
S014KSD US English DVD
Subscription and Support PID: 5655-R30
Order the features
corresponding to those ordered for DB2 Accessories Suite for z/OS, V1.2
Entitlement
Identifier Description License options/Pricing metrics
S013JXJ DB2 Accessories Unlimited Installs
Suite S&S
Orderable Supply ID Language Distribution Medium
S013JV4 English Hardcopy publication
Entitlement
Identifier Description License options/Pricing metrics
S014LHX Data Studio S&S SW Subscription and Support AS
Decline SW S&S No Charge
SW Subscription and Support MS
(EMEA only)
SW S&S Registration No Charge
Orderable Supply ID Language Distribution Medium
S014LHW English Hardcopy publication
Program Name: DB2 Audit Management Expert for z/OS, V2.1
Program PID: 5655-T57
The following is a summary of the license option and pricing metric
information offered for the above PID number.
Entitlement License option/
Identifier Description Pricing metric
S014J6P DB2 Audit Management Exp V2 Basic OTC, Value Units
Orderable Supply ID Language Distribution Medium
S014J6R US English 3480 Tape Cartridge
Program Name: DB2 Log Analysis Tool for z/OS, V3.1
Program PID: 5655-T56
The following is a summary of the license option and pricing metric
information offered for the above PID number.
Entitlement License option/
Identifier Description Pricing metric
S014J6K DB2 Log Analysis Tool V3 Basic OTC, Value Units
Orderable Supply ID Language Distribution Medium
S014J6L US English 3480 Tape Cartridge
Program Name: IMS Recovery Expert for z/OS, V1.1
Program PID: 5655-R26
The following is a summary of the license option and pricing metric
information offered for the above PID number.
Entitlement License option/
Identifier Description Pricing metric
S012HF6 IMS Recovery Expert Basic OTC, Value Units
Orderable Supply ID Language Distribution Medium
S012HF7 US English 3480 Tape Cartridge
Subscription and Support PID: 5655-R27
Entitlement
Identifier Description License options/Pricing metrics
S012HFC IMS Recovery Expert SW Subscription and Support AS
S&S Decline SW S&S No Charge
SW Subscription and Support MS
(EMEA only)
SW S&S Registration No Charge
Orderable Supply ID Language Distribution Medium
S012HFD English Hardcopy publication
Subscription and Support
To receive voice technical support via telephone 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.
To order, specify the Subscription and Support program number (PID)
referenced above and the appropriate license or charge option.
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 Software Maintenance (IAASM). This
offering:
-
Includes and extends the support services provided in the base support to
include technical support via telephone.
-
Entitles you to future releases and versions, at no additional charge.
Note that you are not entitled to new products.
When Subscription and Support is ordered, the charges will renew
automatically annually unless cancelled by you.
The combined effect of the IPLA license and the Agreement for Acquisition
of Software Maintenance gives you rights and support services comparable
to those under the traditional ICA S/390 and zSeries license or its
equivalent. To ensure that you continue to enjoy the level of support
you are used to in the ICA business model, you must order both the
license for the program and the support for the selected programs at the
same Value Unit quantities.
Single version charging:
To elect single version charging, you must notify and identify to
IBM the prior program and replacement program, and the machine the
programs are operating on.
Customized Offerings
Product deliverables are shipped only via Customized Offerings (for example, CBPDO, ServerPac,
SystemPac®).
CBPDO and ServerPac are offered for Internet delivery, where ShopzSeries product ordering is
available. Internet delivery of ServerPac may help improve automation and software delivery time.
For more details on Internet delivery, refer to the ShopzSeries help information at
Media type for this software product is chosen during the Customized
Offerings ordering process. Based on your customer environment, it is
recommended that the highest possible density tape media is selected.
Currently offered media types are:
-
CBPDOs — 3480, 3480 Compressed, 3490E, 3590, 3592*
-
ServerPacs — 3480, 3480 Compressed, 3490E, 3590, 3592*
-
SystemPacs — 3480, 3480 Compressed, 3490E, 3590, 3592*
-
*
-
3592 is highest density media. Selecting 3592 will ship the fewest
number of media.
Once a product becomes generally available, it will be included in the
next ServerPac and SystemPac monthly update.
Production of software product orders will begin on the planned general
availability date.
-
CBPDO shipments will begin one week after general availability.
-
ServerPac shipments will begin two weeks after inclusion in ServerPac.
-
SystemPac shipments will begin four weeks after inclusion in SystemPac
due to additional customization, and data input verification.
Back to top
The information provided in this announcement letter is for reference and
convenience purposes only. The terms and conditions that govern any
transaction with IBM are contained in the applicable contract documents
such as the IBM International Program License Agreement, IBM
International Passport Advantage® Agreement, and the IBM Agreement for
Acquisition of Software Maintenance.
Licensing:
IBM International Program License Agreement including the License
Information (LI) document and Proof of Entitlement (PoE) govern your use
of the program. PoEs are required for all authorized use.
Agreement for Acquisition of Software Maintenance:
The following agreement applies for maintenance and does not require
customer signatures:
-
IBM Agreement for Acquisition of Software Maintenance (Z125-6011)
These programs are licensed under the IBM Program License Agreement
(IPLA) and the associated Agreement for Acquisition of Software
Maintenance, which provide 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 annual renewable 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 System z IBM Operational Support Services — SoftwareXcel
is an option if you desire added services.
Limited warranty:
Yes
Limited warranty:
IBM warrants that when the program is used in the specified
operating environment, it will conform to its specifications. The
warranty applies only to the unmodified portion of the program. IBM does
not warrant uninterrupted or error-free operation of the program or that
IBM will correct all program defects. You are responsible for the
results obtained from the use of the program.
IBM provides you with access to IBM databases containing information on
known program defects, defect corrections, restrictions, and bypasses at
no additional charge. Consult the IBM Software Support Guide for further
information at
IBM will maintain this information for at least one year after the
original licensee acquires the program (warranty period).
Program support:
Enhanced support, called Subscription and Support, includes
telephone assistance, as well as access to updates, releases, and
versions of the program as long as support is in effect. You will be
notified of discontinuance of support with 12 months' notice.
Money-back guarantee:
If for any reason you are dissatisfied with the program and you are
the original licensee, you may obtain a refund of the amount you paid for
it, if within 30 days of your invoice date you return the program and its
PoE to the party from whom you obtained it. If you downloaded the
program, you may contact the party from whom you acquired it for
instructions on how to obtain the refund.
For clarification, note that for programs acquired under any of IBM's
On/Off Capacity on Demand (On/Off CoD) software offerings, this term does
not apply since these offerings apply to programs already acquired and in
use by you.
Authorization for use on home/portable computer:
You may not copy and use this program on another computer without
paying additional license fees.
Other terms
Volume orders (IVO):
No
Passport Advantage applies:
No
Software Maintenance applies
No. For operating system software, the revised IBM Operational Support Services — SoftwareXcel
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
SoftwareXcel offering, visit
For additional information on the revised IBM Operational Support
Services, refer to
601-023
, dated July 10, 2001.
IBM Operational Support Services — SoftwareXcel:
Yes
System i™ Software Maintenance applies:
No
Variable charges apply:
No
Educational allowance available
Yes. A 15% education allowance applies to qualified education
institution customers.
Replaced program Replacement program
Program Program
number Program name number Program name
5685-093 IMS System Utilities/ 5655-R05 IMS High Performance
Database Tools V2 Fast Path Utilities
(DEDB Unload/Load for z/OS, V3.2
Feature)
5685-093 IMS System Utilities/ 5655-R05 IMS High Performance
Database Tools V2 Fast Path Utilities
(DEDB Pointer Checker for z/OS, V3.2
Feature)
5685-093 IMS System Utilities/ 5655-R05 IMS High Performance
Database Tools V2 Fast Path Utilities
(DEDB Tuning Aid for z/OS, V3.2
Feature)
5668-856 IMS/VS System Utilities/ 5655-R05 IMS High Performance
Data Base Tools V1 Fast Path Utilities
(DEDB Unload/Reload for z/OS, V3.2
Feature)
5668-856 IMS/VS System Utilities/ 5655-R05 IMS High Performance
Data Base Tools V1 Fast Path Utilities
(DEDB Pointer Checker for z/OS, V3.2
Feature)
5668-856 IMS/VS System Utilities/ 5655-R05 IMS High Performance
Data Base Tools V1 Fast Path Utilities
(DEDB Tuning Aid for z/OS, V3.2
Feature)
5799-GJE DB2 Batch Undo 5655-T56 DB2 Log Analysis Tool
for z/OS, V3.1
Sub-capacity terms and conditions
For each System z IPLA program with Value Unit pricing, the quantity of that program needed to
satisfy applicable IBM terms and conditions is referred to as the required license capacity. Your
required license capacity is based upon the following factors:
-
The System z IPLA program you select
-
The applicable Value Unit Exhibit
-
The applicable terms
-
Whether your current mainframes are full capacity or sub-capacity
For more information on the Value Unit Exhibit for the System z IPLA program you selected, refer to
the
Ordering information
section.
Program Parents,
number Program name Terms if applicable
5655-R14 DB2 Accessories Suite Reference- DB2 V9 (5635-DB2)
for z/OS, V1.2 based
(Data Studio feature
only)
5655-T57 DB2 Audit Management Reference- DB2 V7 (5675-DB2) or
Expert for z/OS, V2.1 based DB2 V8 (5625-DB2) or
DB2 V9 (5635-DB2)
5655-T56 DB2 Log Analysis Tool Reference- DB2 V7 (5675-DB2) or
for z/OS, V3.1 based DB2 V8 (5625-DB2) or
DB2 V9 (5635-DB2)
5697-I04 DB2 SQL Performance Reference- DB2 V7 (5675-DB2) or
Analyzer for z/OS, V3.2 based DB2 V8 (5625-DB2) or
DB2 V9 (5635-DB2)
5697-H77 IMS Buffer Pool Reference- IMS V8 (5655-C56) or
Analyzer for z/OS, V1.2 based IMS V9 (5655-J38) or
IMS V10 (5635-A01)
5655-R05 IMS High Performance Reference- IMS V8 (5655-C56) or
Fast Path Utilities based IMS V9 (5655-J38) or
for z/OS, V3.2 IMS V10 (5635-A01)
5655-R26 IMS Recovery Expert Reference- IMS V8 (5655-C56) or
for z/OS, V1.1 based IMS V9 (5655-J38) or
IMS V10 (5635-A01)
Full-capacity mainframes:
In cases where full capacity is applicable, the following terms apply.
Execution based, z/OS based, full machine based: The required capacity of a System z IPLA program
with these terms equals the MSU-rated capacity of the machines where the System z IPLA program
executes.
For more information on mainframe MSU-rated capacities, visit
Reference based: The required license capacity of a System z IPLA
program with these terms equals the license capacity of the applicable
monthly license charge (MLC) program. This MLC program is called the
parent program.
Sub-capacity mainframes:
In cases where sub-capacity is applicable, the following terms
apply.
Execution based: The required capacity of a System z IPLA sub-capacity
program with these terms equals the capacity of the LPARs where the
System z IPLA program executes.
z/OS based: The required license capacity of a System z IPLA program with
these terms equals the license capacity of z/OS (and z/OS.e) on the
machines where the System z IPLA program executes.
Reference based: The required license capacity of a System z IPLA program
with these terms equals the license capacity of the applicable monthly
license charge (MLC) program. This MLC program is called the parent
program.
Full-machine-based: The required license capacity of a System z IPLA
program with full-machine-based terms equals the MSU-rated capacity of
the machines where the System z IPLA program executes.
For more information on mainframe MSU-rated capacities, refer to
The System/370™, System/390®, and System z Machine Exhibit
(Z125-3901), or visit the Mainframes section of the System z Exhibits Web
site
For more information on sub-capacity System z IPLA terms and conditions,
refer to
204-184
, dated August 10, 2004.
For additional information for products with reference-based terms,
System z IPLA sub-capacity programs with reference-based terms adds value
to the parent program across the environment, regardless of where in the
environment the System z IPLA program executes.
An environment is defined as either a single or stand-alone machine or a
qualified Parallel Sysplex®. You may have one or more different
environments across the enterprise. To determine the required license
capacity for each System z IPLA program with referenced-based terms, each
environment should be assessed separately.
When a System z IPLA sub-capacity program with reference-based terms is
used in a qualified Parallel Sysplex environment, the required license
capacity of the System z IPLA program must equal with the license
capacity of the parent program across the Parallel Sysplex. Qualified
Parallel Sysplex refers to one:
-
That meets the criteria defined in
198-001
, dated January 13, 1998
-
Where MLC pricing is aggregated across the Sysplex
Sub-capacity eligibility:
To be eligible for sub-capacity charging on select System z IPLA
programs, you must first implement and comply with all terms of either
sub-capacity Workload License Charges (WLC) or sub-capacity Entry
Workload License Charges (EWLC). To implement sub-capacity WLC or EWLC,
a machine must be System z (or equivalent). On that machine:
-
All instances of the OS/390® operating system must be migrated to the
z/OS (or z/OS.e) operating systems.
-
Any licenses for the OS/390 operating system must be discontinued.
-
All instances of the z/OS operating (or z/OS.e) systems must be running
in z/Architecture™ (64-bit) mode.
For that machine, you must create and submit a Sub-Capacity Report to IBM
each month. Sub-Capacity Reports must be generated using the
Sub-Capacity Reporting Tool (SCRT). For additional information or to
obtain a copy of SCRT, visit the System z Software Pricing Web site
You must comply with all of the terms of the WLC or EWLC offering,
whichever is applicable:
-
The complete terms and conditions of sub-capacity WLC are defined in the
IBM Customer Agreement — Attachment for System z Workload License
Charges (Z125-6516).
-
The complete terms and conditions for sub-capacity EWLC are defined in
the IBM Customer Agreement — Attachment for IBM eServer System z 890
and 800 License Charges (Z125-6587).
Additionally, you must sign and comply with the terms and conditions
specified in the amendment to the IPLA contract —
Amendment for IBM System z9™ and eServer zSeries Programs Sub-Capacity
Pricing
(Z125-6929). Once the amendment is signed, the terms in the amendment
replace any and all previous System z IPLA sub-capacity terms and
conditions.
Sub-capacity utilization determination
Sub-capacity utilization is determined based on the utilization of a sub-capacity eligible reference
product and machine.
On/Off Capacity on Demand (CoD)
To be eligible for On/Off CoD pricing, you must be enabled for temporary capacity on the
corresponding hardware, and the required contract, Attachment for Customer Initiated Upgrade and IBM
eServer On/Off Capacity on Demand — Software (Z125-6611) must be signed prior to use.
Back to top
The ordering and price information for the products has not changed. Therefore, ordering and price
information is not included for these products in this announcement.
Back to top
To order, contact the Americas Call Centers, your local IBM representative, or your IBM Business
Partner.
To identify your local IBM representative or IBM Business Partner, call 800-IBM-4YOU (426-4968).
Phone: 800-IBM-CALL (426-2255)
Fax: 800-2IBM-FAX (242-6329)
Internet: callserv@ca.ibm.com
Mail: IBM Teleweb Customer Support
ibm.com Sales Execution Center, Americas North
3500 Steeles Ave. East, Tower 3/4
Markham, Ontario
Canada
L3R 2Z1
Reference: LE001
The Americas Call Centers, our national direct marketing organization, can add your name to the
mailing list for catalogs of IBM products.
Note:
Shipments will begin after the planned availability date.
Trademarks
-
-
IMS, OmniFind, DFSORT, System z, System i, System/370, z/Architecture, and System z9 are trademarks
of International Business Machines Corporation in the United States or other countries or both.
-
-
z/OS, DB2, BookManager, S/390, Language Environment, DB2 Connect, zSeries, eServer, SystemPac,
Passport Advantage, System/390, Parallel Sysplex, and OS/390 are registered trademarks of
International Business Machines Corporation in the United States or other countries or both.
-
-
Windows, Microsoft, and Windows Vista are registered trademarks of Microsoft Corporation.
-
-
Java is a trademark of Sun Microsystems, Inc.
-
-
Linux is a trademark of Linus Torvalds in the United States, other countries or both.
-
-
Other company, product, and service names may be trademarks or service marks of others.
At a glance
