Feedback

IBM Optim portfolio adds Oracle database development support, extending administration solutions and enhancing solution integration

IBM United States Software Announcement 209-131
June 2, 2009

 
 ENUS209-131.PDF (121KB)

Table of contents   Document options  
At a glance At a glance Publications Publications
Overview Overview Technical information Technical information
Key prerequisites Key prerequisites Software Services Software Services
Planned availability dates Planned availability dates Ordering information Ordering information
Description Description Terms and conditions Terms and conditions
Product positioning Product positioning  IBM  Electronic Services IBM Electronic Services
Program number Program number Prices Prices
Education support Education support Order now Order now
Offering Information Offering Information
 
Printable version Printable version

 
Top rule
At a glance
Bottom rule

IBM® Optim Development Studio V2.2 and IBM Optim pureQuery Runtime V2.2, previously known as Data Studio Developer and Data Studio pureQuery Runtime, now include support for DB2® V9.7 and its new compatibility features for Oracle PL/SQL stored procedures. Also new in this release, developers can use Optim Development Studio for application development on Oracle databases. Key features include:

  • Connect to and explore Oracle database objects
  • Move database objects and data between Oracle and DB2
  • Edit, deploy, run, and debug PL/SQL procedures on Oracle and DB2
  • Build Java™ applications with pureQuery data access methods on Oracle
  • Use productivity features for tracing SQL to source, hot spot analysis, and impact analysis for Oracle applications

IBM Optim Database Administrator V2.2, previously known as Data Studio Administrator, is extended to manage large DB2 environments:

  • Database Partitioning Facility (DPF) support added
  • High Availability Disaster Recovery (HADR) support added
  • Ability to move data more quickly and efficiently when used together with the advanced streaming capabilities found in DB2 High Performance Unload for Linux®, UNIX®, and Windows®

This release expands compatibility and integration across Optim Development Studio, Optim Database Administrator, Optim Query Tuner, Optim Workload Query Tuner, and InfoSphere Data Architect, facilitating movement between roles as well as cross-role collaboration.

For ordering, contact:
Your IBM representative or an IBM Business Partner.  For more information, 
contact the Americas Call Centers at 1 800-IBM-CALL.
 
Reference: YE001

 
Back to topBack to top
 
Top rule
Overview
Bottom rule

IBM Optim solutions can help organizations support business growth without growing costs by helping them better manage today's heterogeneous data environments from requirements to retirement.

Now organizations doing development for multiple environments can use a single database development environment across Oracle, DB2, and Informix®. Optim Development Studio V2.2 (formerly Data Studio Developer) and Optim pureQuery Runtime for Linux, UNIX, and Windows V2.2 (formerly Data Studio pureQuery Runtime) have extended support to Oracle databases, including native support for PL/SQL stored procedures. Additionally, this release supports DB2 V9.7 and its new compatibility features for Oracle PL/SQL stored procedures.

Trends toward small team development, where each team member assumes multiple roles, call for more flexibility in development environments. Optim solutions are addressing those requirements by providing more and more plug-in capabilities to our common Eclipse base. Developers and administrators can more easily access expert SQL tuning advice during development: Optim Development Studio introduces seamless integration with the new Optim Query Tuner. Optim Query Tuner provides expert advice for tuning queries targeted for DB2 on Linux, UNIX, Windows, and z/OS® environments. Furthermore, team members can copy and paste database objects and data from one environment to another, including across mixed database environments. Integration with Optim Test Data Management and Data Privacy Solutions make it easier to create right-sized, fictionalized, production-like test databases.

Optim pureQuery Runtime now improves SQL best practices by providing conversion and consolidation of literals. Use of literals instead of variables or parameters is generally discouraged within SQL because it makes each statement unique, which drives down cache hit ratios and impacts performance. Now multiple statements that were each unique due to use of literals will be consolidated into a single statement using parameters to help improve application performance. In addition, Version 2.2 introduces a more lifecycle-driven means for capturing application SQL by simplifying use of pureQuery overtime. This release also introduces the ability to configure data source parameters on the application server online, increasing the flexibility of managing a pureQuery deployment.

Optim Database Administrator for DB2 for Linux, UNIX, and Windows simplifies DB2 database administration by providing an easier-to-use interface and built-in analysis to automate complex database changes and migrations with confidence. This release extends support for large database environments and disaster recovery.


 
Back to topBack to top
 
Top rule
Key prerequisites
Bottom rule

Refer to the Hardware requirements and Software requirements sections.


 
Back to topBack to top
 
Top rule
Planned availability dates
Bottom rule

June 19, 2009 (electronic software delivery).

July 17, 2009 (media and documentation).


 
Back to topBack to top
 
Top rule
Description
Bottom rule

Optim Development Studio enables database developers to more rapidly develop higher quality code by providing a feature-rich database development environment. This environment helps simplify database development by providing procedure building and debugging features along with database object management, project management, and optimization tools with Optim pureQuery Runtime.

  • Support for DB2 for Linux, UNIX, and Windows; DB2 for z/OS; DB2 for i; Informix Dynamic Server; and Oracle.
  • Support for create, alter, and drop of database objects.
  • A rich SQL and Java programming environment.
  • Seamless integration with Optim Query Tuner for expert advice in tuning queries that target DB2 on Linux, UNIX, Windows, or z/OS environments.
  • Code assist and SQL syntax validation for IBM databases.
  • Procedure building and debugging.
  • Data access layer generation that leverages best practices for SQL and JDBC.
  • Ability to move database objects and data between Oracle and DB2. Optionally, invoke Optim Test Data Management and Data Privacy offerings for right-sized, fictionalized, production-like test data.

Optim pureQuery Runtime adds additional capability designed to boost SQL performance and mitigate the risk of SQL injection. In addition, key performance metrics and correlation metadata can be captured and displayed within Optim Development Studio. Thus, Optim pureQuery Runtime enables users to:

  • Capture, review, share, and optimize SQL, including the ability to replace poorly performing SQL with optimized SQL without changing the application
  • Convert DB2 dynamic SQL to static SQL to reduce CPU consumption, provide better manageability, and enforce tighter security
  • Prevent SQL injection by restricting the SQL executed by a specific application to an approved set of SQL statements
  • Display performance metrics within Optim Development Studio to identify SQL hot spots
  • Trace problem SQL back to its source code for fast problem isolation
  • Visualize the impact of database changes

New in Version 2.2, Optim pureQuery now provides conversion and consolidation of literals. SQL statements including literals are unique, reducing the likelihood of the database server finding them in the dynamic cache, which impacts performance. Additionally, SQL statements with literals become difficult for the DBA to convert to static SQL. By converting literals to parameters or variables and then consolidating those with common structure into a single statement, you can use Optim pureQuery to help:

  • Improve application performance because the resultant SQL statement, when executed dynamically, is more likely to be cached, avoiding the overhead of parsing the statement and computing an access plan
  • Simplify management of static packages by reducing the number of statements to be captured and bound
  • Improve security by increasing the manageability and performance of the pureQuery SQL restriction capability

Optim pureQuery Runtime V2.2 also introduces incremental SQL capture and merge, simplifying use of pureQuery over the application lifecycle. Now test suites running on separate systems can capture SQL independently and merge the SQL into a common file for visualization, optimization, and binding more easily. Furthermore, incremental application enhancements can be captured incrementally and merged without recapturing previously captured statements.

Optim pureQuery Runtime V2.2 also introduces the ability to configure data source parameters on the application server online, helping to increase the flexibility of managing a pureQuery deployment. Previously, changing data source parameters such as setting capture mode on or execution mode to static required rebooting the application server. Now these configuration parameters can be set without impacting the availability of the application server. Furthermore, multiple applications sharing a common data source can each have unique values assigned, increasing deployment flexibility.

Optim Database Administrator simplifies DB2 database administration by providing an easier-to-use interface and built-in analysis to automate complex database changes and migrations with confidence. Optim Database Administrator capabilities make it easier to perform everyday tasks such as object changes, utilities, commands, configuration changes, and granting or revoking of security privileges, and enables immediate script execution or the ability to save the script for later execution. IBM Optim Database Administrator features include:

  • An easier-to-use interface to perform everyday administration tasks
  • Integration with InfoSphere Data Architect for streamlining logical modeling to physical deployment
  • Built-in dependency analysis to help ensure all impacted objects are included
  • Powerful undo capabilities to enable backing out production changes
  • Integration with DB2 High Performance Unload for Linux, UNIX, and Windows to provide faster and more efficient data movement between servers
  • Version control via Rational® ClearCase® or other configuration management software
  • Plus, new in this release: enhanced support for partitioned database environments and high availability disaster recovery

These releases continue to extend the portfolio integration. Common base components are integrated across Optim Development Studio, Optim Database Administrator, Optim Query Tuner, Optim Workload Query Tuner, and InfoSphere Data Architect, including:

  • An enhanced database explorer so you can
    • Navigate to the data sources you care about faster
    • Initiate tasks more easily and intuitively from the Data Source Explorer
    • Share database connection information across products and users
  • Common database support, including a database overview diagram, schema management, DDL generation, impact analysis, compare and synchronize function, property browser, privilege management, and more
  • A common data development project to create, edit, and run SQL, including Visual Explain for IBM databases to assist in tuning efforts

Accessibility by people with disabilities

A US Section 508 Voluntary Product Accessibility Template (VPAT) can be requested via the IBM Web site

http://www.ibm.com/able/product_accessibility/index.html

Section 508 of the U.S. Rehabilitation Act

The products included in this announcement are capable as of July 17, 2009, 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. A U.S. Section 508 Voluntary Product Accessibility Template (VPAT), containing details on the products accessibility compliance, can be requested on the following Web site

http://www.ibm.com/able/product_accessibility/index.html

 
Back to topBack to top
 
Top rule
Product positioning
Bottom rule

IBM Optim solutions for Integrated Data Management offer proven, integrated capabilities to manage enterprise application data from requirements to retirement. With Optim, teams can share data artifacts (like models, policies, and metadata) to better align data management with business goals and help improve collaboration. Today, organizations of all types leverage Optim to help improve performance, streamline database administration, speed application development, and support more effective governance. Optim supports efforts to deliver better business outcomes with lower costs and risks, while providing capabilities that scale across enterprise applications, databases, and platforms.

Optim Development Studio V2.2 is an upgrade from Data Studio Developer V2.1. Optim Development Studio is used by database developers or database administrators to more quickly and efficiently develop code for DB2, Informix, or Oracle databases. Built-in procedure builders and debuggers, code assists, and SQL syntax verification for IBM databases help facilitate faster and better code development. Integration with Optim Query Tuner gives users expert advice for tuning queries pre-development or post-deployment. Included in Optim Development Studio is database object management. This enables the developer to create and alter test database objects as part of the development process. Integration with Optim Test Data Management and Data Privacy Solutions helps drive value by enabling the creation of right-sized, fictionalized, production-like test data.

Optim pureQuery Runtime for Linux, UNIX, and Windows V2.2 is an upgrade from Data Studio pureQuery Runtime V2.1. Optim pureQuery Runtime works in conjunction with Optim Development Studio to help accelerate development, improve performance, enhance security, and improve manageability of data-driven applications. Optim pureQuery Runtime takes advantage of DB2-unique static SQL execution in both Java and .NET environments to help drive down costs and lock-in performance. Optim pureQuery Runtime can further enhance any Java environment -- whether custom-written code, framework based, or packaged application -- by providing value-added insight into application SQL to help improve impact analysis and problem isolation.

Optim Database Administrator for DB2 for Linux, UNIX, and Windows V2.2 is an upgrade from Data Studio Administrator V2.1. Optim Database Administrator is a powerful database administration tool that provides an easier-to-use interface to perform everyday tasks such as object changes, utility execution, command execution, configuration changes, and granting or revoking of security privileges. Optim Database Administrator is typically used by database administrators to automate building of database administration scripts. Automated building of scripts can be initiated by indicating a set of changes typed in manually through the GUI or specified in a file or model.

Database object migrations can be initiated by using the copy/paste function. Once these actions have been initiated, Optim Database Administrator does the hard work by handling data and dependency preservation along with providing a comparison mapping to help ensure that database changes are built as intended. Automating these scripts can help save time and also help reduce errors inherent in this environment due to complex sets of dependencies often found in relational databases. Use Optim Database Administrator with InfoSphere Data Architect for more seamless development from logical models through to physical databases.


 
Back to topBack to top
 
Top rule
Program number
Bottom rule

Program
number     VRM                          Program name
 
5724-X85   2.2.0                        IBM Optim Database
                                         Administrator for DB2 for
                                         Linux, UNIX, and Windows
5724-X83   2.2.0                        IBM Optim Development
                                         Studio
5724-X84   2.2.0                        IBM Optim pureQuery
                                         Runtime for Linux, UNIX,
                                         and Windows

 
Back to topBack to top
 
Top rule
Education support
Bottom rule

IBM training provides education to support many IBM offerings. Descriptions of courses for IT professionals and managers are on the IBM training Web site

http://www.ibm.com/services/learning/

Call IBM training at 800-IBM-TEACH (426-8322) for catalogs, schedules, and enrollments.

Available from IBM training, the newest offerings to support your training needs, enhance your skills, and boost your success with IBM software.

IBM offers a range of training options from traditional classroom to Instructor-Led Online to meet your demanding schedule. Instructor-Led Online (ILO) is an innovative learning format where students get the benefit of being in a classroom with the convenience and cost savings of online training.

Go green with IBM Onsite training for groups as small as three or as large as 14. Choose from the same quality training delivered in classrooms, or customize a course or a selection of courses to best suit your business needs.

Enjoy further savings when you purchase training at a discount with an IBM Education Pack - online account -- a flexible and convenient way to pay, track, and manage your education expenses online.

The following education resources are currently available. Check your local Information Management Training and Education Web site or with your training representative for the most recent training schedule.

Course
code                   Course title           Course type
 
3E06                   IBM Optim Development  Instructor Led
                       Studio Basics          Online

Descriptions of courses for IT professionals and managers are available at

http://www.ibm.com/services/learning/ites.wss/tp/en?pageType=tp_search

Visit ibm.com/training or call IBM training at 800-IBM-TEACH (426-8322) for scheduling and enrollment.


 
Back to topBack to top
 
Top rule
Offering Information
Bottom rule

Product information is available via the Offering Information Web site

http://www.ibm.com/common/ssi

Also, visit the Passport Advantage® Web site

http://www.ibm.com/software/passportadvantage

 
Back to topBack to top
 
Top rule
Publications
Bottom rule

No hardcopy publications are shipped with these products.

The IBM Publications Center

http://www.ibm.com/shop/publications/order

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.

IBM Redbooks® offer deep technical insight from IBM and industry experts. These books highlight real-time experiences, and include sample code, typical scenarios, and step-by-step, "how-to" guidelines.

IBM Form No.                      Title
 
SG24-6899-01                      Up and Running with DB2 on
                                   Linux
REDP-4510-00                      IBM Data Studio V2.1: Getting
                                   Started with Web Services on
                                   DB2 for z/OS
SG24-7688-00                      DB2 9 for z/OS: Packages
                                   Revisited

For additional Redbooks, refer to

http://www.redbooks.ibm.com/

 
Back to topBack to top
 
Top rule
Technical information
Bottom rule

Specified operating environment

Hardware requirements

Memory and disk requirements: The following table shows applicable recommended minimum memory and disk requirements. The actual requirements depend on the applications you intend to run. These requirements do not include any additional memory or disk requirements for other software that is running on your system. The numbers below are for reference only.

Product                Memory                 Disk
 
IBM Optim Development  1 GB                   750 MB
 Studio
IBM Optim pureQuery    128 MB                 80 MB
 Runtime
IBM Optim Database     2 GB                   750 MB
 Administrator
Software requirements

The operating system support level of various IBM Data Studio products is frequently updated. To obtain the current information for supported software levels, including recommended maintenance levels, refer to

http://www.ibm.com/software/data/studio

Minimal requirements for operating systems at the time of announcement are listed as follows. (Refer to the Web site previously listed for further details and Service Pack requirements.)

IBM Optim Development Studio and IBM Optim Database Administrator support the following desktop operating systems:

  • Red Hat Desktop 4.0 x86-32
  • Red Hat Enterprise Linux 4.0 AS/ES x86-32
  • Red Hat Enterprise Linux 5.0 AS/ES x86-32
  • Red Hat Enterprise Linux 5.0 AS/ES x86-64 (in 32-bit compatibility mode)
  • SUSE Linux Enterprise Desktop 10 x86-32
  • SUSE Linux Enterprise Server 10 x86-32
  • SUSE Linux Enterprise Server 9.0 x86-32
  • Windows Vista Business, Enterprise, Ultimate 32 and 64 bit (in 32-bit compatibility mode)
  • Windows XP Professional 32 and 64 bit (Service Pack 2 (SP2)) (in 32-bit compatibility mode)
  • Windows Server 2003 Standard, Enterprise x86-32 and x86-64 (in 32-bit compatibility mode)
  • Windows Server 2008 Standard, Enterprise x86-32

IBM Optim pureQuery Runtime supports the following application server operating systems:

  • AIX® 5.2, 5.3, or 6.1
  • HP-UX 11i v3 IA64
  • Solaris SPARC 10 64 bit
  • Red Hat Enterprise Linux 4.0 AS/ES x86-32 bit
  • Red Hat Enterprise Linux 4.0 AS/ES x86-64 bit
  • Red Hat Enterprise Linux 5.0 AS/ES x86-32 bit
  • Red Hat Enterprise Linux 5.0 AS/ES x86-64 bit
  • Red Hat Enterprise Linux 5.0 AS/ES for IBM System z®
  • SUSE Linux 9.0 Enterprise Server x86-32 bit
  • SUSE Linux 9.0 Enterprise Server x86-64 bit
  • SUSE Linux 10.0 Enterprise Server x86-32 bit
  • SUSE Linux 10.0 Enterprise Server x86-64 bit
  • SUSE Linux 10.0 Enterprise Server for IBM System z
  • Windows XP 32 and 64 bit (SP2)
  • Windows Vista Business Edition 32 and 64 bit
  • Windows Vista Enterprise Edition 32 and 64 bit
  • Windows Vista Ultimate Edition 32 and 64 bit
  • Windows Server 2003 Enterprise 32 and 64 bit
  • Windows Server 2003 Standard 32 and 64 bit
  • Windows Server 2008 Enterprise 32 and 64 bit
  • Windows Server 2008 Standard 32 and 64 bit

Other technical information

Data Studio pureQuery Runtime requires one of the following to be installed as a prerequisite for IBM data server support:

  • IBM Data Server Driver for JDBC and SQLJ V3.57, or later (or corresponding DB2 Connect™ version level) for JDBC 3.0 applications and IBM Data Server Driver for JDBC and SQLJ V4.7, or later, for JDBC 4.0 applications.
  • IBM Data Server Clients for ODBC, CLI, .NET V9.5.3, or later

IBM Optim pureQuery Runtime and Development Studio require the following Oracle JDBC Drivers for Oracle support:

  • Oracle Database 11g Release 1 (11.1.0.7.0) JDBC Drivers
    • odbcj5.jar
    • odbcj6.jar
    • datadirect 4.0
  • Oracle Database 10g Release 2 (10.2.0.4) JDBC Drivers
    • odbcj5.jar
    • datadirect 4.0

IBM Data Studio Administrator supports:

  • DB2 for Linux, UNIX, and Windows (LUW) V8.2 FP 11, or later, DB2 LUW V9.1, V9.5, and V9.7

IBM Data Studio Developer and IBM Data Studio pureQuery Runtime support:

  • DB2 for LUW V8.2 FP 11, or later, DB2 for LUW V9.1, V9.5, and V9.7
  • DB2 for System i® V5R3 or V5R4
  • DB2 for z/OS V8, or later
  • Informix Dynamic Server V10, V11.10, or V11.50
  • Oracle 10g, 11g

The program's specifications and specified operating environment information may be found in documentation accompanying the program, if available, such as a readme file, or other information published by IBM, such as an announcement letter. Documentation and other program content may be supplied only in the English language.

Planning information

Customer responsibilities

Software Subscription and Support (also referred to as Software Maintenance) is included with licenses purchased through Passport Advantage and Passport Advantage Express. Product upgrades and technical support are provided by the Software Subscription and Support offering as described in the Agreements. Product upgrades provide the latest versions and releases to entitled software, and technical support provides voice and electronic access to IBM support organizations, worldwide.

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

Packaging

IBM Optim Development Studio

  • IBM Optim Development Studio V2.2 for Windows DVD
  • IBM Optim Development Studio V2.2 for Linux DVD
  • IBM Optim Development Studio V2.2 License Enablement Kit - Multiplatform CD
  • Quick Start CD
  • Quick Start Guide

IBM Optim pureQuery Runtime for Linux, UNIX, and Windows

  • IBM Optim pureQuery Runtime V2.2 - Multiplatform DVD

IBM Optim Database Administrator for DB2 for Linux, UNIX, and Windows

  • IBM Optim Database Administrator V2.2 for Windows DVD
  • IBM Optim Database Administrator V2.2 for Linux DVD
  • IBM Optim Database Administrator V2.2 License Enablement Kit - Multiplatform CD
  • Quick Start CD
  • Quick Start Guide

Security, auditability, and control

The products in this announcement use the security and auditability features of the host hardware or software.

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


 
Back to topBack to top
 
Top rule
Software Services
Bottom rule

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 extensive portfolio of capabilities. Together, we provide the global reach, intellectual capital, industry insight, and technology leadership to support a wide range of critical business needs.

To learn more about IBM Software Services or to contact a Software Services sales specialist, visit

http://www.ibm.com/software/sw-services/

 
Back to topBack to top
 
Top rule
Ordering information
Bottom rule

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

Product information

                                                    Product
Licensed function title             Product group   category
 
IBM Data Studio Administrator for   IBM Database 2™ DB2 Tools
 DB2 Linux, UNIX, Windows
IBM Data Studio Developer           IBM Database 2  Data Studio
IBM Data Studio pureQuery Runtime   IBM Database 2  Data Studio
                                      PID        Charge unit
Program name                          number     description
 
IBM Data Studio Administrator for     5724-X85   Per Value Unit
 DB2 Linux, UNIX, Windows
IBM Data Studio Administrator for     5724-X85   Per Concurrent
 DB2 Linux, UNIX, Windows                         User
IBM Data Studio Administrator for     5724-X85   PROCESSOR-Day(s)
 DB2 Linux, UNIX, Windows
IBM Data Studio Administrator for     5724-X85   Per Authorized
 DB2 Linux, UNIX, Windows                         User
IBM Data Studio Developer             5724-X83   Per Authorized
                                                  User
IBM Data Studio Developer             5724-X83   Per Authorized
                                                  User for System
                                                  z
IBM Data Studio pureQuery Runtime     5724-X84   Per Processor
                                                  Value Unit for
                                                  System z
IBM Data Studio pureQuery Runtime     5724-X84   Per Processor
                                                  Value Unit (PVU)

Charge metrics definitions

Processor Value Unit (PVU)

PVU is the unit of measure by which this program is licensed. PVU entitlements are based on processor families (vendors and brands). A Proof of Entitlement (PoE) must be obtained for the appropriate number of PVUs based on the level or tier of all processor cores activated and available for use by the program on the server. Some programs allow licensing to less than the full capacity of the server's activated processor cores, sometimes referred to as sub-capacity licensing. For programs which offer sub-capacity licensing, if a server is partitioned utilizing eligible partitioning technologies, then a PoE must be obtained for the appropriate number of PVUs based on all activated processor cores available for use in each partition where the program runs or is managed by the program. Refer to the International Passport Advantage Agreement Attachment for Sub-Capacity Terms or the program's License Information to determine applicable sub-capacity terms. The PVU entitlements are specific to the program and may not be exchanged, interchanged, or aggregated with PVU entitlements of another program.

For general overview of PVUs for processor families (vendors and brands), go to

http://www-306.ibm.com/software/lotus/passportadvantage/ pvu_licensing_for_customers.html

To calculate the exact PVU entitlements required for the program, go to

https://www-112.ibm.com/software/howtobuy/passportadvantage/ valueunitcalculator/vucalc.wss

Concurrent User

Concurrent User is the unit of measure by which this program is licensed. A Concurrent User is a shared user access to the program within or outside of your enterprise. The program may be installed only on one computer or one server. The total number of Concurrent Users simultaneously accessing the program at any moment in time may not exceed the highest number of Concurrent Users authorized by the Proof of Entitlement (PoE). You must have an entitlement for each Concurrent User simultaneously accessing the program or any program component in any manner directly or indirectly (for example, via a multiplexing program, device, or application server) through any means.

Authorized User

Authorized User is the unit of measure by which this program is licensed. An Authorized User is an individual (named or unnamed) within or outside of your enterprise. The program may be installed on one or more computers or servers and accessed by the number of users authorized by the Proof of Entitlement (PoE). You must have an entitlement for each Authorized User accessing the program or any program component in any manner directly or indirectly (for example, via a multiplexing program, device, or application server) through any means.

Passport Advantage program licenses

IBM Optim DBAdm for DB2 for LUW

                                                         Part
Part description                                         number
 
IBM Data Studio Administrator for DB2 Linux, UNIX,
 Windows
Optim DB Administrator for DB2 for LUW AU Annual SW S&S  E045ULL
 Rnwl
Optim DB Administrator for DB2 for LUW AU Lic + SW S&S   D61RTLL
 12 Mo
Optim DB Administrator for DB2 for LUW AU SW S&S         D61RULL
 Reinstate 12 Mo
Optim DB Administrator for DB2 for LUW CU Annual SW S&S  E045VLL
 Rnwl
Optim DB Administrator for DB2 for LUW CU Lic + SW S&S   D61RVLL
 12 Mo
Optim DB Administrator for DB2 for LUW CU SW S&S         D61RWLL
 Reinstate 12 Mo
Optim DB Administrator for DB2 for LUW PVU Annual SW     E02T6LL
 S&S Rnwl
Optim DB Administrator for DB2 for LUW PVU Lic + SW S&S  D590YLL
 12 Mo
Optim DB Administrator for DB2 for LUW PVU SW S&S        D591YLL
 Reinstate 12 Mo

IBM Optim Development Studio

                                                         Part
Part description                                         number
 
IBM Data Studio Developer
Optim Development Studio Authorized User Annual SW S&S   E048XLL
 Rnwl
Optim Development Studio Authorized User License + SW    D61YILL
 S&S 12 Mo
Optim Development Studio Authorized User SW S&S          D61YJLL
 Reinstate 12 Mo

IBM Optim pureQuery RT LUW

                                                         Part
Part description                                         number
 
IBM Data Studio pureQuery Runtime
Optim pureQuery RT for LUW PVU License & SW S&S 12 Mo    D61YKLL
Optim pureQuery RT for LUW PVU SW S&S Reinstate 12 Mo    D61YLLL
Optim pureQuery RT for LUW Processor Value Unit (PVU)    E048YLL
 Annual SW S&S Rnwl

Passport Advantage supply

                                                         Part
Program name/description                                 number
 
IBM Optim Development Studio V2.2.0
IBM Optim Development Studio Red Hat Enterprise Linux    BB118ML
 ES,Windows Vista Bus
Optim DB Admin for DB2 V2.2.0
Optim DB Admin for DB2 Red Hat Enterprise Linux ES,SUSE  BB11AML
 Linux Enterprise S
Optim pureQuery RT V2.2.0
Optim pureQuery RT Windows Vista Business,Solaris SPARC  BB119ML
 Platform Edition (

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.

Optim pureQuery RT V2.2.0

Entitled maintenance                                    Part
offerings description       Media packs description     number
 
Data Studio pureQuery       Optim pureQuery RT Windows  BB119ML
 Runtime Processor Value     Vista Business,Solaris
 Unit                        SPARC Platform Edition (
IBM Data Studio pureQuery   Optim pureQuery RT Windows  BB119ML
 Runtime per Processor       Vista Business,Solaris
 Value Unit for System z     SPARC Platform Edition (

Optim DB Admin for DB2 V2.2.0

Entitled maintenance                                    Part
offerings description       Media packs description     number
 
IBM Data Studio             Optim DB Admin for DB2 Red  BB11AML
 Administrator for DB2 LUW   Hat Enterprise Linux
 Authorized User             ES,SUSE Linux Enterprise S
IBM Data Studio             Optim DB Admin for DB2 Red  BB11AML
 Administrator for DB2 LUW   Hat Enterprise Linux
 Concurrent User             ES,SUSE Linux Enterprise S
IBM Data Studio             Optim DB Admin for DB2 Red  BB11AML
 Administrator for DB2 LUW   Hat Enterprise Linux
 Value Unit                  ES,SUSE Linux Enterprise S

IBM Optim Development Studio V2.2.0

Entitled maintenance                                    Part
offerings description       Media packs description     number
 
IBM Data Studio Developer   IBM Optim Development       BB118ML
 Authorized User             Studio Red Hat Enterprise
                             Linux ES,Windows Vista Bus
IBM Data Studio Developer   IBM Optim Development       BB118ML
 Authorized User for System  Studio Red Hat Enterprise
 z                           Linux ES,Windows Vista Bus

Cross-platform products

Cross-platform product for use on System z

Order the part numbers that follow when the product is used for either the development of code that will be deployed on System z servers or when the product will be communicating or transferring data between a distributed server and a System z server. Otherwise, order from the other set of part numbers in this announcement. This set of part numbers provides the identical supply and authorization as the other set in this announcement

IBM Optim Development Studio

                                                         Part
Part description                                         number
 
IBM Data Studio Developer
Optim Development Studio for Sys z Authorized User       D04MFLL
 License + SW S&S 12 Mo
Optim Development Studio for Sys z Authorized User SW    D04MGLL
 S&S Reinstate 12 Mo
Optim Development Studio for System z Authorized User    E055NLL
 Annual SW S&S Rnwl

IBM Optim pureQuery RT LUW

                                                         Part
Part description                                         number
 
IBM Data Studio pureQuery Runtime
DS pureQuery RT for System z Processor Value Unit        D04QBLL
 License & SW S&S 12 Mo
Optim pureQuery RT for LUW for Sys z PVU Annual SW S&S   E0571LL
 Rnwl
Optim pureQuery RT for LUW for Sys z PVU SW S&S          D04QCLL
 Reinstate 12 Mo
Cross-platform product for use on System z Integrated Facility for Linux (IFL) engines:

Order the part numbers that follow when the product is intended to run on the Linux operating system on System z Integrated Facility for Linux (IFL) engines. If the product is not intended to run on the Linux operating system on System z IFL engines, order from the other set of part numbers in this announcement. This set of part numbers provides the identical supply and authorization as the other set in this announcement.

On/Off CoD

IBM Data Studio Administrator for DB2 Linux, UNIX, Windows

                                                         Part
Part description                                         number
 
Optim DB Administrator for DB2 for LUW Processor Day     D57SXLL
Per Use-Day OOCoD

 
Back to topBack to top
 
Top rule
Terms and conditions
Bottom rule

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

The IBM International Program License Agreement including the License Information document and Proof of Entitlement (PoE) govern your use of the program. 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 Subscription and Support.

License Information form numbers
                                          Program
Program name                              number     Form number                                          
 
IBM Optim DBAdm for DB2 for LUW           5724-X85   L-DNAA-7PL27W
IBM Optim Development Studio              5724-X83   L-MLOY-7PKSZW
IBM Optim pureQuery RT LUW                5724-X84   L-SRAN-7PJ64G

The program's License Information will be available for review on the IBM Software License Agreement Web site

http://www.ibm.com/software/sla/sladb.nsf
Limited warranty applies

Yes

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 Handbook for further information at

http://www.ibm.com/support/handbook

IBM will maintain this information for at least one year after the original licensee acquires the program (warranty period).

Program technical support

Technical support of a program product will be available for a minimum of five years from the general availability date, as long as your Software Maintenance is in effect. This technical support allows you to obtain assistance (via telephone or electronic means) from IBM for product-specific, task-oriented questions regarding the installation and operation of the program product. Software Maintenance also provides you with access to updates, releases, and versions of the program. You will be notified, via announcement letter, of discontinuance of support with 12 months' notice. If you require additional technical support from IBM, including an extension of support beyond the discontinuance date, contact your IBM representative or IBM Business Partner. This extension may be available for a fee.

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

The program may be stored on the primary machine and another machine, provided that the program is not in active use on both machines at the same time. You may not copy and use this program on another computer without paying additional license fees.

Product name
 
IBM Optim DBAdm for DB2 for LUW                               No
IBM Optim Development Studio                                  No
IBM Optim pureQuery RT LUW                                    No
Volume orders (IVO)

No

Passport Advantage applies

Yes, and through the Passport Advantage Web site at

http://www.ibm.com/software/passportadvantage

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

Usage restriction

Yes.

For additional information, refer to the License Information document that is available on the IBM Software License Agreement Web site

http://www.ibm.com/software/sla/sladb.nsf
Software Subscription and Support (also referred to as Software Maintenance) applies

Yes. Software Subscription and Support (also referred to as Software Maintenance) is included with licenses purchased through Passport Advantage and Passport Advantage Express. Product upgrades and technical support are provided by the Software Subscription and Support offering as described in the Agreements. Product upgrades provide the latest versions and releases to entitled software and Technical Support provides voice and electronic access to IBM support organizations, worldwide.

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

While your Software Subscription and Support 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, to your information systems (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, 7 days a week. For additional details, consult your IBM Software Support Handbook at

http://www.ibm.com/support/handbook

Software Subscription and Support 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 the applicable agreements.

For additional information about the International Passport Advantage Agreement and the IBM International Passport Advantage Express Agreement, visit the Passport Advantage Web site at

http://www.ibm.com/software/passportadvantage
System i 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 to topBack to top
 
Top rule
IBM Electronic Services
Bottom rule

IBM has transformed its delivery of hardware and software support services to help you achieve higher system availability. Electronic Services is a Web-enabled solution that offers an exclusive, no-additional-charge enhancement to the service and support available for IBM servers. These services are designed to provide the opportunity for greater system availability with faster problem resolution and preemptive monitoring. Electronic Services comprises two separate, but complementary, elements: Electronic Services news page and Electronic Services Agent.

The Electronic Services news page is a single Internet entry point that replaces the multiple entry points traditionally used 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 Electronic Service Agent™ is no-additional-charge software that resides on your server. It monitors events and transmits system inventory information to IBM on a periodic, client-defined timetable. The Electronic Service Agent automatically reports hardware problems to IBM. Early knowledge about potential problems enables IBM to deliver proactive service that may result in higher system availability and performance. In addition, information collected through the Service Agent is made available to IBM service support representatives when they help answer your questions or diagnose problems. Installation and use of IBM Electronic Service Agent for problem reporting enables IBM to provide better support and service for your IBM server.


 
Back to topBack to top
 
Top rule
Prices
Bottom rule

Passport Advantage

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

http://www.ibm.com/software/passportadvantage

Business Partner information

If you are an IBM Business Partner -- Distributor for Workstation Software acquiring products from IBM, you may link to Passport Advantage Online for resellers where you can obtain Business Partner pricing information. An IBM ID and password are required.

https://www.ibm.com/software/howtobuy/passportadvantage/paoreseller

 
Back to topBack to top
 
Top rule
Order now
Bottom rule

To order, contact the Americas Call Centers or 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
 
For IBM Business Partner: pwswna@us.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: 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

DB2 Connect, Database 2 and Electronic Service Agent are trademarks of IBM Corporation in the United States, other countries, or both.

IBM, DB2, Informix, z/OS, Rational, ClearCase, Passport Advantage, Redbooks, AIX, System z, System i, iSeries, pSeries and ibm.com are registered trademarks of IBM Corporation in the United States, other countries, or both.

Java and all Java-based trademarks are trademarks of Sun Microsystems, Inc. in the United States, other countries, or both.

Linux is a registered trademark of Linus Torvalds in the United States, other countries, or both.

UNIX is a registered trademark of The Open Group in the United States and other countries.

Windows is a registered trademark of Microsoft Corporation in the United States, other countries, or both.

Other company, product, and service names may be trademarks or service marks of others.

Terms of use

IBM products and services which are announced and available in your country can be ordered under the applicable standard agreements, terms, conditions, and prices in effect at the time. IBM reserves the right to modify or withdraw this announcement at any time without notice. This announcement is provided for your information only. Additional terms of use are located at

http://www.ibm.com/legal/us/en/

For the most current information regarding IBM products, consult your IBM representative or reseller, or visit the IBM worldwide contacts page

http://www.ibm.com/planetwide/us/

 

Back to topBack to top
 
Bottom grey rule
 
Printable version Printable version