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)
|
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 top
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 top
Refer to the Hardware requirements and Software requirements sections.
Back to top
June 19, 2009 (electronic software delivery).
July 17, 2009 (media and documentation).
Back to top
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 top
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 top
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 top
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 top
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 top
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 top
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 top
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 top
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 top
The information provided in this announcement letter is for reference and convenience purposes only. The terms and conditions that govern any transaction with IBM are contained in the applicable contract documents such as the IBM International Program License Agreement, IBM International Passport Advantage Agreement, and the IBM Agreement for Acquisition of Software Maintenance.
Licensing
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 top
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 top
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 top
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 top
Printable version
