IBM DB2 tools expanded for multiplatform environments

IBM United States Software Announcement 206-130
June 6, 2006

 

 ENUS206-130.PDF (73KB)

Table of contents   Document options  
TOC link At a glance TOC link Technical information
TOC link Overview TOC link Ordering information
TOC link Key prerequisites TOC link Terms and conditions
TOC link Planned availability dates TOC link IBM Electronic Services
TOC link Description TOC link Prices
TOC link Offering Information TOC link Order now
TOC link Publications  
 
Printable version Printable version

 
At a glance

DB2 Change Management Expert for Multiplatforms V1.1 helps database administrators (DBAs) to:

  • Reduce human error by automating and managing complex DB2 structural changes and rolling back changes as needed
  • Increase application availability by analyzing the impact of proposed changes prior to execution
  • Ensure data integrity by automatically finding all related schema change elements

IBM DB2 High Performance Unload for Multiplatforms V3.1 and DB2 High Performance Unload for Workgroups V3.1 offer:

  • Improved performance
  • Processing enhancements
  • Enhancements to extractions from backups
  • Significant platform changes
  • Miscellaneous enhancements

For ordering, contact:

Your IBM representative or IBM Americas Call Centers at 800-IBM-CALL (Reference: YE001).
 
Back topBack to top
 

Overview

DB2® Change Management Expert (CME) for Multiplatforms V1.1 is designed to help DBAs:

  • Improve productivity and reduce human errors by automating and managing complex DB2 structural changes
  • See the impact of proposed changes prior to implementation
  • Automatically find all related schema change elements and integrate the changes made by a team
  • Expedite the process of developing and implementing DB2 database-related changes

DB2 CME lets DBAs:

  • Manage the deployment of changes on the target databases
  • Compare two applications (sets of objects) to determine where they differ
  • Migrate a set of objects or redefine the target objects to be like the source
  • Create a historical baseline for future reference
  • Create, view, add, delete, and modify change commands (DDL, DML, DCL, utilities, DB2 commands, and system commands)
  • Preserve data, such as running DB2 import and export utilities
  • Run maintenance utilities such as rebind or RUNSTATS
  • Deploy changes to a single database or multiply provision
  • Automatically undo CME changes, if needed

By automating and simplifying the change management process, DB2 CME is intended to give DBAs the reliability they need to manage DB2 structural changes, while consistently ensuring data integrity and reducing application downtime.

DB2 High Performance Unload (HPU) for Multiplatforms V3.1 and DB2 High Performance Unload for Workgroups V3.1 are high-speed tools for unloading, extracting, and repartitioning data from DB2 databases on Linux™, UNIX®, and Windows™. DB2 HPU is made to help reduce the maintenance window through shorter elapsed time operations and new capabilities.

DB2 HPU V3.1 now has both 32-bit and 64-bit executables, and is designed to install either one, or both, depending on the operating environment. An executable is selected and used at runtime, based on the wordsize of the DB2 instance where the table being unloaded resides. Also, if you are extracting from a DB2 backup that is managed by a storage manager (such as IBM Tivoli® Storage Manager (TSM)), DB2 HPU is engineered to use the same storage manager client, by way of the same DB2 library, as DB2 itself uses.

Enhancements to the DB2 HPU support for extracting tables from backups:

  • In a DB2 DPF environment, you may start DB2 HPU on a system other than the one from where the backup is taken.
  • For online backups, DB2 HPU is designed to extract the data as it is on the backup itself, with no effort to apply any log records to restore it to a consistent state. This functionality is useful for disaster recovery situations and situations where data inconsistencies do not cause problems (such as summarizations and aggregations for warehousing).

Additional enhancements offered by DB2 HPU V3.1:

  • Support for the following operating environments:
    • Linux on System x™ (x86-64)
    • Linux on System p™
    • Linux on System z™
    • Solaris 10
  • New output format of XML, which may be useful for cross-system movement of data

 
Back topBack to top
 
Key prerequisites

Refer to Hardware requirements and Software requirements .
 
Back topBack to top
 

Planned availability dates
  • June 9, 2006, electronic software delivery
  • July 21, 2006, media and documentation

Note: The new functional capability of DB2 HPU for Multiplatforms V3.1 is scheduled to be included in the DB2 Toolkit for Multiplatforms offering, effective on the availability date for DB2 HPU for MP V3.1. For more information, refer to Software Announcement 206-044 , dated March 7, 2006.
 
Back topBack to top
 

Description

IBM DB2 Change Management Expert for Multiplatforms V1.1

To respond to changing business needs, DBAs must frequently update DB2 structures and data. Approaching this task manually can be tedious, time consuming, and error prone. To address this challenge, IBM offers DB2 Change Management Expert for Multiplatforms V1.1. With an interactive GUI, DB2 CME allows DBAs to iteratively make changes and see the results from different viewpoints.

The tool also offers investigation capabilities to help DBAs understand relationships between data, specifications of results, and the execution of change commands. For example, the tool includes visualization capabilities such as graphical compare, graphical dependency viewing, SQL source text formatting, and context-sensitive assistance. These capabilities help increase reliability and reduce human errors when analyzing, migrating, and executing database schema object changes. Other key features include:

  • Graphical wizards to assist even novice users in the change management process
  • Ability to aggregate summary information and drill down to get a deeper understanding of the issues relating to impact and migration
  • Ability to automatically propagate changes to related objects, streamlining change management
  • Ability to generate Data Definition Language (DDL) to change the database, which can then be viewed, added, deleted, and validated before deployment
  • Automated forward and reverse schema engineering between database and DDL
  • Ability to synchronize, copy, clone, or merge database schema definitions from the source to the target
  • Remote DB2 Command execution, such as utility execution, application bind/rebind, and data load/unload
  • Ability to create new schemas or load them from a variety of different sources, such as databases, DDL, and snapshots:
    • Report on the impact of proposed changes speeding a time-consuming process
    • Provide Authorization Management
    • Create an historical baseline for future reference

DB2 High Performance Unload V3.1

DB2 HPU V3.1 Multiplatform and Workgroup editions offer:

  • Improved performance: A key focus for DB2 HPU V3.1 is performance. This release delivers significant new enhancements, including:
    • Better distribution of work across partitions
    • Replacement of some current processes with threads
    • Reduced dispatching path length
    • Reduced requirement for shared memory and semaphores
  • Processing enhancements that include:
    • 32-bit and 64-bit executables
    • Ability to specify the system on which the output is to be generated
  • Enhancements to extraction from backups that include:
    • Unloading from backups that reside on a different system
    • Automatic recall from TSM of a backup that was created on a different system
  • Additional platform support:
    • Linux for System x, 64-bit added
    • Linux for System z and Linux for System p added (64-bit executables)
    • Solaris 10 added for SPARC
  • Other enhancements that include:
    • XML output format
    • DISTINCT column support
    • Repartitioning enhancements
    • LOB data conversion when unloading into separate file using LOBFILE
    • Separation of installation and configuration
    • New option of BINARY to DOUBLEDELIM
    • Improved handling of errors
    • Improved User's Guide
    • ITLM enablement

Accessibility by people with disabilities

A U.S. Section 508 Voluntary Product Accessibility Template (VPAT) can be requested via IBM's Web site

Section 508 of the U.S. Rehabilitation Act

The following programs, are capable as of July 21, 2006, 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:

  • DB2 Change Management Expert for Multiplatforms (5724-L29)
  • DB2 High Performance Unload for Multiplatforms (5724-B90)
  • DB2 High Performance Unload for Workgroups (5724-E56)

Note that IBM assumes that Section 508 applies only to normal and routine end-user operations, and not to setup and service functions. A U.S. Section 508 VPAT can be requested at

Trademarks

 
System x, System p, and System z are trademarks of International Business Machines Corporation in the United States or other countries or both.
 
DB2 and Tivoli are registered trademarks of International Business Machines Corporation in the United States or other countries or both.
 
Microsoft and Windows are trademarks of Microsoft Corporation.
 
UNIX is a registered trademark of the Open Company in the United States and other countries.
 
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.

 
Back topBack to top
 
Offering Information

Product information is available via the Offering Information Web site

Also, visit the Passport Advantage® Web site


 
Back topBack to top
 
Publications

No publications are shipped with these products.

The IBM Publications Center

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 (in the U.S.) or customer number for 20 countries. A large number of publications are available online in various file formats, and they can all be downloaded by all countries free of charge.
 
Back topBack to top
 

Technical information

Specified operating environment

Hardware requirements

IBM DB2® Change Management Expert for Multiplatforms V1.1: DB2 Change Management Expert can be installed on the following client platforms:

  • Windows™ 2000, Windows Server 2003, and Windows XP (all 32-bit)
  • Linux™ on System x™ (32-bit)

DB2 Change Management Expert was tested on the following servers:

  • AIX 5L™ V5.2 (32-bit and 64-bit) and AIX® 5L V5.3 (32-bit and 64-bit)
  • Windows 2000, Windows Server 2003, and Windows XP (all 32-bit)
  • Solaris V9 (32-bit and 64-bit) and Solaris V10 (32-bit and 64-bit)
  • Linux on System x (Red Hat V3; SUSE 8 (32-bit)), Linux on System p™ (Red Hat V3), Linux on System z™ (Red Hat V3; SUSE 9 (64-bit))

DB2 Change Management Expert has the following hardware requirements:

  • 1 GB RAM (4 GB recommended)
  • 450 MB disk space
  • 25 MB free disk space
  • Additional space for user data (the amount you need depends upon the size of your databases and the amount of change activity on your system)

DB2 High Performance Unload for Multiplatforms V3.1: DB2 High Performance Unload for Multiplatforms V3.1 operates on any hardware configuration that supports DB2 UDB V8.x. Specifically, the operating environments are:

  • AIX 5L V5.2, or later (32-bit and 64-bit)
  • Sun Solaris 8, or later (32-bit and-64 bit)(Solaris 10 on SPARC only)
  • Linux on System x Kernel 2.4.7, or later (32-bit)
  • Linux on System x Kernel 2.4.7, or later (64-bit)(AMD Opteron; Intel® Xeon EM64T)
  • Linux on System p Kernel 2.4.7, or later (64-bit only)
  • Linux on System z Kernel 2.4.7, or later (64-bit only)
  • Windows 2000
  • Windows XP
  • Windows Server 2003

DB2 High Performance Unload for Workgroups V3.1: DB2 High Performance Unload for Workgroups V3.1 operates on any hardware configuration that supports DB2 UDB V8.x Workgroup Server Edition. Specifically, those operating environments are:

  • AIX 5L V5.2, or later (32-bit and 64-bit)
  • Linux on System x Kernel 2.4.7, or later (32-bit)
  • Linux on System x Kernel 2.4.7, or later (64-bit)(AMD Opteron; Intel Xeon EM64T)
  • Windows 2000
  • Windows XP
  • Windows Server 2003

Software requirements

DB2 Change Management Expert for Multiplatforms V1.1: DB2 Change Management Expert requires the following:

  • DB2 V8 Fix Pack 7, or later
  • Connection to a locally installed DB2 database, or connection to a DB2 UDB Administration Client
  • A Web browser (to view demonstrations of the product in the online documentation)

In order to run DB2 Change Management Expert, you must use the IBM JDBC Type 4 driver. The JDBC Type 4 driver is included in DB2 Change Management Expert. You may select a different JDBC driver if necessary.

You must ensure that the DB2 libraries are in the PATH environment variable (Windows) or in the LD_LIBRARY_PATH environment variable (UNIX).

You must also have connectivity to the DB2 Administration Server (DAS) that is running on the same machine as the database. The DAS connectivity libraries can be provided by either of the following:

  • A local DB2 instance
  • The DB2 UDB Administration Client

In either case, make sure the bin directory is in the path before you start DB2 Change Management Expert (in Linux, this is handled by sourcing $INST_HOME/sqllib/db2profile). The DB2 UDB Administration Client is available from IBM developerWorks™ at

DB2 High Performance Unload for Multiplatforms V3.1: DB2 High Performance Unload for Multiplatforms V3.1 operates on any software configuration that supports DB2 UDB V8.x as follows:

  • DB2 UDB Enterprise Server Edition V8.x
  • DB2 UDB Workgroup Server Edition V8.x
  • DB2 UDB Workgroup Server Unlimited Edition V8.x

DB2 High Performance Unload for Workgroups V3.1: DB2 High Performance Unload for Workgroups V3.1 operates on any software configuration that supports DB2 UDB V8.x as follows:

  • DB2 UDB Workgroup Server Edition V8.x
  • DB2 UDB Workgroup Server Unlimited Edition V8.x

Planning information

Customer responsibilities: Software Maintenance, previously referred to as Software Subscription and Technical Support, is included in the Passport Advantage Agreement. Installation and technical support is provided by the Software Maintenance offering of the IBM International Passport Advantage Agreement. This fee service enhances customer productivity, with voice and electronic access into IBM support organizations.

Packaging

DB2 Change Management Expert for Multiplatforms V1.1: The physical deliverable consists of a media pack that includes the following CDs:

Product                           Media pack content
 
DB2 Change Management Expert      DB2 CME for MP CDs (2)
 for Multiplatforms
DB2 Grouper component             DB2 Grouper CD (1)

DB2 High Performance Unload for Multiplatforms V3.1: The physical deliverable consists of a media pack that includes the following CDs:

Product                           Media pack content
 
DB2 High Performance Unload       DB2 HPU for MP CDs (2)
 for Multiplatforms

DB2 High Performance Unload for Workgroups V3.1: The physical deliverable consists of a media pack that includes the following CDs:

Product                           Media pack content
 
DB2 High Performance Unload for   DB2 HPU for WG CD (1)
 Workgroups

Security, auditability, and control

The following programs use the security and auditability features of the DB2 Universal Database®.

  • DB2 Change Management Expert for Multiplatforms (5724-L29)
  • DB2 High Performance Unload for Multiplatforms (5724-B90)
  • DB2 High Performance Unload for Workgroups (5724-E56)

The customer is responsible for evaluation, selection, and implementation of security features, administrative procedures, and appropriate controls in application systems and communication facilities.

Integrated Technology Services (IBM Global Services)

Software Services: IBM 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

To locate an IBM Business Partner, visit


 
Back topBack to top
 
Ordering information

This product is only available via Passport Advantage. It is not available as shrinkwrap.

Product information

                                                Product
Licensed function title         Product group   category
 
DB2 Change Management Expert    Database 2(TM)  DB2 Tools
 for Multiplatforms Processor
DB2 High Performance Unload     Database 2      DB2 Tools
 for MP
DB2 High Performance Unload     Database 2      DB2 Tools
 for Workgroups
 
                                  PID        Charge unit
Program name                      number     description
 
DB2 Change Management Expert for  5724-L29   Processor(s)
 Multiplatforms Processor
DB2 Change Management Expert for  5724-L29   Processor Day
 Multiplatforms Processor
DB2 High Performance Unload for   5724-B90   Processor(s)
 MP
DB2 High Performance Unload for   5724-E56   Processor(s)
 Workgroups

Charge metrics definitions

Processor

A processor (commonly called a CPU or core ) is a functional unit within a computing device that interprets and executes instructions. A processor consists of at least an instruction control unit and one or more arithmetic or logic unit. With multi-core technology, each core is considered a processor. With full capacity licensing, a Proof of Entitlement (PoE) must be acquired for all activated processors on the server available to the program or a component of the program.

Passport Advantage program licenses

                                                 Part
Part description                                 number
 

DB2 High Performance Unload for Multiplatforms

 
DB2 High Performance Unload Processor(s)         D512ALL
 License & SW Maintenance 12 Months
DB2 High Performance Unload Processor(s)         E009HLL
 SW Maintenance Annual Renewal
DB2 High Performance Unload Processor(s)         D512CLL
 SW Maintenance Reinstatement 12 M
 

DB2 High Performance Unload for Workgroups

 
DB2 Hi Perf Unld for WG Processor(s)             D529XLL
 License & SW Maintenance 12 Months
DB2 Hi Perf Unld for WG Processor(s)             E00Q2LL
 SW Maintenance Annual Renewal
DB2 Hi Perf Unld for WG Processor(s)             D529YLL
 SW Maintenance Reinstatement 12 Months
 

DB2 Change Management Expert for Multiplatforms

 
DB2 CME for MP Processor(s) License              D54Y9LL
 & SW Maintenance 12 Months
DB2 CME for MP Processor(s) SW                   E01RBLL
 Maintenance Annual Renewal
DB2 CME for MP Processor(s) SW                   D54YALL
 Maintenance Reinstatement 12 Months

Passport Advantage supply

                                                        Part
Program name                                            number
 
DB2 CME for MP V1.1.0
Media Pack English U.S. Windows 2000, Windows XP,       BB0NINA
 Solaris (Sun Microsystems), Linux for zSeries®
 Enterprise Servers (Mainframes), Linux for pSeries®
 UNIX Servers (incl pSeries IntelliStation®), AIX 5L,
 V5, Linux for x86Series Intel-based servers CD-ROM
 Digital Disk -- ISO 9660 Standard V1.1.0
DB2 Hi Perf Unld for WG V3.1.0
Media Pack English U.S. Windows 2000, Windows XP,       BB0QANA
 Windows Server 2003, AIX 5L, V5, Linux for x86Series
 Intel-based servers CD-ROM Digital Disk --
 
 ISO 9660 Standard V3.1.0
DB2 High Perf Unld for MP V3.1.0
Media Pack English U.S. Windows 2000, Windows XP,       BB0Q9NA
 Solaris (Sun Microsystems), Windows Server 2003,
 Linux for zSeries Enterprise Servers (Mainframes),
 Linux for pSeries UNIX Servers (incl pSeries
 Intellistation), AIX 5L, V5, Linux for x86Series
 Intel-based servers CD-ROM Digital Disk --
 ISO 9660 Standard V3.1.0

Passport Advantage customer: Media pack entitlement details

Customers with active maintenance or subscription for the products listed are entitled to receive the corresponding media pack.

Entitled maintenance                                    Part
offerings description      Media packs description      number
 

DB2 High Perf Unld for MP V3.1.0

 
DB2 HIGH PERF UNLOAD FOR   DB2 High Perf Unld for MP    BB0Q9NA
MP PROC                     English U.S. Windows 2000,
                            Windows XP, Solaris (Sun
                            Microsystems), Windows
                            Server 2003, Linux for
                            zSeries Enterprise Servers
                            (Mainframes), Linux for
                            pSeries UNIX Servers (incl
                            pSeries Intellistation),
                            AIX 5L, V5, Linux for
                            x86Series Intel-based
                            servers CD-ROM Digital
                            Disk -- ISO 9660 Standard
 

DB2 Hi Perf Unld for WG V3.1.0

 
DB2 HIGH PERF UNLOAD       DB2 Hi Perf Unld for WG      BB0QANA
WKGP PROC                   English U.S. Windows 2000,
                            Windows XP, Windows Server
                            2003, AIX 5L, V5, Linux
                            for x86Series Intel-based
                            servers CD-ROM Digital
                            Disk -- ISO 9660 Standard
 

DB2 CME for MP V1.1.0

 
DB2 Change Management      DB2 CME for MP English U.S.  BB0NINA
Expert for Multiplatforms   Windows 2000, Windows XP,
Processor                   Solaris (Sun
                            Microsystems), Linux for
                            zSeries Enterprise Servers
                            (Mainframes), Linux for
                            pSeries UNIX Servers (incl
                            pSeries Intellistation),
                            AIX 5L, V5, Linux for
                            x86Series Intel-based
                            servers CD-ROM Digital
                            Disk -- ISO 9660 Standard

Withdrawal of previous Passport Advantage part numbers: Effective July 21, 2006, IBM will withdraw from marketing the following products licensed under the IBM International Program License Agreement (IPLA). A replacement product and availability date is listed if one is available.

Withdrawn products           Replacement products
 

DB2 High Performance Unload for Multiplatforms V2.2.0
(5724-B90)

 
DB2 High Perf Unld           DB2 High Perf Unld
 for MP Windows 2000,         for MP Windows 200
 Windows XP,                  Windows XP,
 Solaris (Sun Microsystems)    Solaris (Sun Microsystems)
 (BB0M9ML)                    (BB0Q9NA)
 

DB2 High Performance Unload for Workgroups V2.2.0
(5724-E56)

 
DB2 Hi Perf Unld             DB2 Hi Perf Unld
 for WG Windows 2000,         for WG Windows 2000,
 Windows XP,                  Windows XP,
 Windows Server 2003,         Windows Server 2003,
 AIX V5 (BB0MAML)             AIX 5L (BB0QANA)

Orders for these part numbers will not be accepted after the stated effective date of withdrawal, nor will normal marketing activities or educational support be available unless previous agreement exists between the customer and IBM.

On/Off Capacity on Demand

DB2 Change Management Expert for Multiplatforms Processor

                                                       Part
Part description                                       number
 
DB2 CME for MP Processor Day Per Use-DAY, On Off       D57SXLL
 Capacity on demand Tempor

 
Back topBack to top
 
Terms and conditions

This product is only available via Passport Advantage. It is not available as shrinkwrap.

Licensing: IPLA and License Information document. PoEs 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.

This software license includes Software Maintenance, previously referred to as Software Subscription and Technical Support.

License information form numbers

                                            Program    Form
Program name                                number     number
 
DB2 High Performance Unload for             5724-B90   GC18-9837
 Multiplatforms
DB2 High Performance Unload for Workgroups  5724-E56   GC18-9839
DB2 Change Management Expert for MP         5724-L29   GC18-9957

On or near the planned availability date, the LI will be available for review on the IBM Software License Agreement Web site

Limited warranty applies: Yes

Warranty: This program includes a warranty for one year from acquisition from IBM or an authorized IBM Business Partner. For one year from acquisition of the program, this warranty provides the customer with access to databases containing program information and FAQs, including any known fixes to defects, which the customer can download or otherwise obtain and install.

Money-back guarantee: If for any reason you are dissatisfied with the program and you are the original licensee, return it within 30 days from the invoice date, to the party (either IBM or its reseller) from whom you acquired it, for a refund.

  • For programs acquired under the IBM International Passport Advantage offering, this term applies only to your first acquisition of the program.
  • 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 the customer.

Copy and use on home/portable computer: No

Volume orders (IVO): No

Passport Advantage applies: Yes, and through the Passport Advantage Web site at

Usage restriction: Yes

DB2 Change Management Expert for Multiplatforms

  • Charges for this program are based on the total number of processors from which the data being processed by the program originates, including any processors available to the database servers on which the data originally resides, and the processors available to the database servers to which the program is licensed. The total number of processors within database servers on which the data being processed by the program resides and which are attached or available to the program may not exceed the number authorized by the applicable PoE or authorized by each product authorization acquired under Passport Advantage. If the total number exceeds the quantity in your PoE or exceeds your product authorizations acquired under Passport Advantage, you must notify IBM or its reseller as stated in the IPLA.
  • High availability/failover licensing
    • After the server is fully licensed, it can be used to service user workload. In high availability configurations this server is called a primary server ; additional servers acting as backups are called standby servers that may be deployed in active or idle configurations.
    • In active standby or idle standby, you must acquire a correct number of processor PoEs in addition to the processor PoEs you obtained for the primary server.
    • Active standby
      • In an active standby configuration, the program is operational on all servers to service user transactions or queries. Because each of the active standby servers is used to operate the program for user transactions or queries before and after a failure, the program must be fully licensed on all active servers.
      • In active standby, you must license the program for the number of processors attached or available to the active standby servers. For example, consider an environment with two servers, one primary server with four processors and one active standby server with two processors. This environment must be licensed for six processors (four for the primary server and two for the active standby server).
    • Idle standby
      • In idle standby configuration, idle standby servers have the program installed, however, they do not have the program operational to service user transactions or query workloads. A server is considered idle if it is used exclusively for administrative actions that assist in failover scenarios such as having a database in roll forward pending state to support log shipping, or in making a flash copy of a DB2 database and then performing a database backup of this copy on another server, or in keeping a standby database synchronized using the High Availability Disaster Recovery (HADR) component.
      • In idle standby, you must license the program for one processor per idle standby server only, regardless of the number of processors attached or available to the server. For example, consider an environment with two servers, one primary server with four processors and one idle standby server with two processors. This environment must be licensed for five processors (four for the primary server and one for the idle standby server).

DB2 High Performance Unload for Multiplatforms

  • Charges for this program are based on the total number of processors from which the data being processed by the program originates, including any processors available to the database servers on which the data originally resides, and the processors available to the database servers to which the program is licensed. The total number of processors within database servers on which the data being processed by the program resides and which are attached or available to the program may not exceed the number authorized by the applicable PoE or authorized by each product authorization acquired under Passport Advantage. If the total number exceeds the quantity in your PoE or exceeds your product authorizations acquired under Passport Advantage, you must notify IBM or its reseller as stated in the IPLA.
  • High availability/failover licensing
    • After the server is fully licensed, it can be used to service user workload. In high availability configurations this server is called a primary server ; additional servers acting as backups are called standby servers that may be deployed in active or idle configurations.
    • In active standby or idle standby, you must acquire a correct number of processor PoEs in addition to the processor PoEs you obtained for the primary server.
    • Active standby
      • In an active standby configuration, the program is operational on all servers to service user transactions or queries. Because each of the active standby servers is used to operate the program for user transactions or queries before and after a failure, the program must be fully licensed on all active servers.
      • In active standby, you must license the program for the number of processors attached or available to the active standby servers. For example, consider an environment with two servers, one primary server with four processors and one active standby server with two processors. This environment must be licensed for six processors (four for the primary server and two for the active standby server).
    • Idle standby
      • In idle standby configuration, idle standby servers have the program installed, however, they do not have the program operational to service user transactions or query workloads. A server is considered idle if it is used exclusively for administrative actions that assist in failover scenarios such as having a database in roll forward pending state to support log shipping, or in making a flash copy of a DB2 database and then performing a database backup of this copy on another server, or in keeping a standby database synchronized using the HADR component.
      • In idle standby, you must license the program for one processor per idle standby server only, regardless of the number of processors attached or available to the server. For example, consider an environment with two servers, one primary server with four processors and one idle standby server with two processors. This environment must be licensed for five processors (four for the primary server and one for the idle standby server).

DB2 High Performance Unload for Workgroups

  • Charges for this program are based on the total number of processors from which the data being processed by the program originates, including any processors available to the database servers on which the data originally resides, and the processors available to the database servers to which the program is licensed. The total number of processors within database servers on which the data being processed by the program resides and which are attached or available to the program may not exceed the number authorized by the applicable PoE or authorized by each product authorization acquired under Passport Advantage. If the total number exceeds the quantity in your PoE or exceeds your product authorizations acquired under Passport Advantage, you must notify IBM or its reseller as stated in the IPLA.
  • High availability/failover licensing
    • After the server is fully licensed, it can be used to service user workload. In high availability configurations this server is called a primary server ; additional servers acting as backups are called standby servers that may be deployed in active or idle configurations.
    • In active standby or idle standby, you must acquire a correct number of processor PoEs in addition to the processor PoEs you obtained for the primary server.
    • Active standby
      • In an active standby configuration, the program is operational on all servers to service user transactions or queries. Because each of the active standby servers is used to operate the program for user transactions or queries before and after a failure, the program must be fully licensed on all active servers.
      • In active standby, you must license the program for the number of processors attached or available to the active standby servers. For example, consider an environment with two servers, one primary server with four processors and one active standby server with two processors. This environment must be licensed for six processors (four for the primary server and two for the active standby server).
    • Idle standby
      • In idle standby configuration, idle standby servers have the program installed, however, they do not have the program operational to service user transactions or query workloads. A server is considered idle if it is used exclusively for administrative actions that assist in failover scenarios such as having a database in roll forward pending state to support log shipping, or in making a flash copy of a DB2 database and then performing a database backup of this copy on another server, or in keeping a standby database synchronized using the HADR component.
      • In idle standby, you must license the program for one processor per idle standby server only, regardless of the number of processors attached or available to the server. For example, consider an environment with two servers, one primary server with four processors and one idle standby server with two processors. This environment must be licensed for five processors (four for the primary server and one for the idle standby server).
  • DB2 High Performance Unload for Workgroups is not licensed for use with and will not run against DB2 Universal Database Enterprise Edition, Extended Enterprise Edition, and Enterprise Server Edition.

Software Maintenance applies: Yes

Software Maintenance, previously referred to as Software Subscription and Technical Support, is included in the IBM International Passport Advantage Agreement. Installation and technical support is provided by the Software Maintenance offering of the IBM International Passport Advantage Agreement. This fee service provides voice and electronic access to IBM support organizations.

IBM includes one year of Software Maintenance with the initial license acquisition of each program acquired. The initial period of Software Maintenance can be extended by the purchase of a renewal option, if available.

While your Software Maintenance is in effect, IBM provides you assistance for your routine, short duration installation and usage (how-to) questions, and code-related questions. IBM provides assistance via telephone and, if available, electronic access, only to your IS technical support personnel during the normal business hours (published prime shift hours) of your IBM support center. (This assistance is not available to your end users.) IBM provides Severity 1 assistance 24 hours a day, every day of the year. For additional details, consult your IBM Software Support Guide at

Software Maintenance does not include assistance for the design and development of applications, your use of programs in other than their specified operating environment, or failures caused by products for which IBM is not responsible under this agreement.

For more information about the Passport Advantage Agreement, visit the Passport Advantage Web site at

iSeries™ Software Maintenance applies: No

Educational allowance available: Not applicable.

On/Off CoD

To be eligible for On/Off CoD pricing, customers must be enabled for temporary capacity on the corresponding hardware, and the required contract — Z125-6907, Amendment for iSeries and pSeries Temporary Capacity On Demand — Software — must be signed prior to use.
 
Back topBack to top
 

IBM Electronic Services

IBM Global Services has transformed its delivery of hardware and software support services to put you on the road to higher systems availability. IBM Electronic Services is a Web-enabled solution that provides you with an exclusive, no-additional-charge enhancement to the service and support available on the IBM eServer® platform. These services provide the opportunity for greater system availability due to faster problem resolution and preemptive monitoring. IBM Electronic Services is comprised of two separate but complementary elements: IBM Electronic Services news page and IBM Electronic Service Agent™.

IBM Electronic Services news page provides you with a single Internet entry point that replaces the multiple entry points traditionally used by customers to access IBM Internet services and support. The news page enables you to gain easier access to IBM resources for assistance in resolving technical problems.

The IBM Electronic Service Agent is no-additional charge software that resides on your eServer system. It is designed to proactively monitor events and transmit system inventory information to IBM on a periodic, customer-defined timetable. The IBM Electronic Service Agent tracks system inventory, hardware error logs, and performance information. If the server is under a current IBM maintenance service agreement or within the IBM warranty period, the Service Agent automatically reports hardware problems to IBM. Early knowledge about potential problems enables IBM to provide proactive service that may result in higher system availability and performance. In addition, information collected through the Service Agent will be made available to IBM service support representatives when they are helping answer your questions or diagnosing problems.

To learn how IBM Electronic Services can work for you, visit


 
Back topBack to top
 
Prices

The prices provided in this announcement are suggested retail prices for the U.S. only and are provided for your information only. Dealer prices may vary, and prices may also vary by country. Prices are subject to change without notice. For additional information and current prices, contact your local IBM representative.

Passport Advantage

For Passport Advantage information and charges, contact your IBM representative or authorized IBM Business Partner. Additional information is also available at

Business Partner information

If you are an IBM Business Partner — Distributor for Workstation Software acquiring products from IBM, you may link directly to Business Partner pricing information. An ID and password are required (use IBM ID).


 
Back topBack to top
 
Order now

To order, contact the Americas Call Centers or your local IBM representative.

To identify your local IBM representative, 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 Americas Call Centers
             Dept. Teleweb Customer Support, 9th floor
             105 Moatfield Drive
             North York, Ontario
             Canada M3B 3R1
 
 Reference:  YE001

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

 
System x, AIX 5L, System p, System z, developerWorks, Database 2, iSeries, and Electronic Service Agent are trademarks of International Business Machines Corporation in the United States or other countries or both.
 
Passport Advantage, DB2, AIX, DB2 Universal Database, zSeries, pSeries, IntelliStation, eServer, and PartnerWorld are registered trademarks of International Business Machines Corporation in the United States or other countries or both.
 
Intel is a registered trademark of Intel Corporation.
 
Windows is a trademark of Microsoft Corporation.
 
UNIX is a registered trademark of the Open Company in the United States and other countries.
 
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.

Back to topBack to top
 

 
Printable version Printable version