IBM delivers IBM Data Studio Developer V1.1 and IBM Data Studio pureQuery Runtime V1.1

IBM United States Software Announcement 207-302
November 13, 2007

 

 ENUS207302.PDF (31KB)

 

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

 
At a glance

IBM Data Studio pureQuery Runtime V1.1:

  • Bridges the gap between data and Java technology by harnessing the power of SQL within an easy-to-use Java data access platform
  • Improves the security and performance of characteristics of your Java applications
  • Deploys applications to query in-memory collections and databases using one single API
  • Deploys advanced pureQuery applications using static SQL to improve application performance and management to deliver predictable response

IBM Data Studio Developer V1.1:

  • Develops database applications faster with integrated query editor for SQL and XQuery
  • Optimizes your applications and queries with ease
  • Builds and tests your stored procedures (Java and SQL) with the interactive routine debugger
  • Accelerates Java developer productivity with pureQuery
  • Rapidly develops or customizes the SQL inside Java applications
  • Auto-generates test applications for your pureQuery applications

 
Back topBack to top
 
Overview

IBM Data Studio Developer V1.1, a new offering for database developers, revolutionizes the way databases and database applications are built, tested and deployed. Built on the flexible and expandable IBM Data Studio platform, IBM Data Studio Developer provides complete development environment for building database objects, queries, and database logic including stored procedures and user-defined functions. It also introduces significant XML development capabilities including the ability to use XQuery and the ability to deliver access to data via services oriented architecture (SOA) technologies such as SOAP and XML and RESTfull Web services. IBM Data Studio Developer also expands development choices for Java™ programmers working with relational database systems. It introduces IBM Data Studio pureQuery Runtime, an innovative approach to building higher quality, better performing database applications, while greatly improving Java programmer productivity.

IBM Data Studio pureQuery Runtime provides a runtime environment that accelerates performance of Java application code. When deployed on the popular Java application server platforms such as IBM WebSphere® Application Server, IBM Data Studio pureQuery Runtime provides a more manageable, more secure environment for connecting Java applications to DB2 for Linux™, UNIX®, and Windows®, DB2 for z/OS® (DB2 Connect® required), and IDS data servers.
 
Back topBack to top
 

Key prerequisites

Refer to the Hardware requirements and Software requirements sections.


 
Back topBack to top
 

Planned availability dates
  • December 14, 2007: Electronic software delivery
  • January 18, 2008: Media and documentation

 
Back topBack to top
 
Description

IBM Data Studio pureQuery Runtime, when deployed to popular Java application servers, provides the capability to:

  • Deploy advanced pureQuery applications using static SQL to improve application performance and management to deliver predictable response
  • Improve the security and manageability of your Java applications

IBM Data Studio Developer provides an integrated and comprehensive database development environment to:

  • Develop and test pureQuery applications for Java
  • Develop, debug, and test SQL and Java stored procedures
  • Perform object management tasks to create, alter, and drop database objects
  • Build, execute, and analyze SQL and XQuery using a common integrated query editor
  • Perform data management tasks to edit, browse, import, and export data

Key benefits:

  • Accelerate Java development productivity with new pureQuery data access
  • Slash development time up to 50% with an integrated data management environment
  • Simplify development of applications implementing industry-specific XML standards
  • Comprehensive IBM data server support including all DB2® platforms and Informix™ Dynamic Server
  • Can install IBM Data Studio Developer on top of an existing Eclipse 3.2 environment or will install its own Eclipse 3.2 instance

For additional information, refer to

Accessibility by people with disabilities

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

Section 508 of the U.S. Rehabilitation Act

IBM Data Studio Developer is capable as of January 18, 2008, 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 at

IPLA and Subscription and Support considerations

IPLA licenses can be transferred from one machine to another within, but not limited to an enterprise. You may aggregate the capacity for all the processors the product is operated on to achieve a more economic price. This will result in a single Proof of Entitlement (PoE). It is your responsibility to manage the distribution of Value Units within the limits of the entitlement of the product license.

Subscription and Support must cover the same capacity as the product license entitlement. Subscription and Support will be available in the country in which the agreement is made.

Trademarks

 
Informix is a trademark of International Business Machines Corporation in the United States or other countries or both.
 
WebSphere, DB2 Connect, z/OS, and DB2 are registered trademarks of International Business Machines Corporation in the United States or other countries or both.
 
Windows is a registered trademark of Microsoft Corporation.
 
Java is a trademark of Sun Microsystems, Inc.
 
UNIX is a registered trademark of the Open Company in the United States and other countries.
 
Linux is a trademark of Linus Torvalds in the United States, other countries or both.
 
Other company, product, and service names may be trademarks or service marks of others.

 
Back topBack to top
 
Offering Information

Product information is available via the Offering Information Web site

Also, visit the Passport Advantage® Web site


 
Back topBack to top
 
Publications

No hard copy publications are shipped with these products.

The IBM Publications Center

The Publications Center is a worldwide central repository for IBM product publications and marketing material with a catalog of 70,000 items. Extensive search facilities are provided. Payment options for orders are via credit card (in the U.S.) or customer number for 20 countries. A large number of publications are available online in various file formats, and they can all be downloaded by all countries.
 
Back topBack to top
 

Technical information

Specified operating environment

Hardware requirements

Memory requirements: The following table shows applicable recommended minimum memory for installation prerequisite in megabytes. The actual requirement depends on the applications you intend to run. These requirements do not include any additional memory requirements for other software that is running on your system. The numbers below are for reference only.

                     Windows(R)           Linux(TM)
 
IBM Data Studio      512 MB               512 MB
 Developer
 
IBM Data Studio      Varies by platform   Varies by platform
 pureQuery Runtime    being used           being used

Disk space requirements: The following table shows applicable recommended minimum disk space for a typical install in megabytes. The actual space required may vary depending on your file system and the components installed. The numbers below are for reference only.

                       Windows              Linux
 
IBM Data Studio        680 MB               620 MB
 Developer
 
IBM Data Studio        5 (all supported     5 (all supported
 pureQuery Runtime      platforms)           platforms)

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

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 Data Studio Developer

Windows

  • Windows Vista® Business, Enterprise, Ultimate
  • Windows 2000 Professional x86-32 bit (SP3 and SP4)
  • Windows 2000 Advanced Server x86-32 bit (SP4)
  • Windows 2003 Enterprise Edition x86-32 bit, x86-64 bit (SP1)
  • Windows 2003 Standard Edition x86-32 bit, x86-64 bit (SP1)
  • Windows XP Professional x86-32 bit (SP1 and SP2)
  • Windows XP Professional x86-64 bit (SP1 and SP2)

Linux

  • Red Hat Desktop Linux 4.0 x86-32 bit
  • Red Hat Enterprise Linux 4.0 AS/ES x86-32 bit
  • SUSE Linux 9.0 Enterprise Server x86-32 bit (SP1-SP4)
  • SUSE Linux 10.0 Enterprise Server x86-32 bit

IBM Data Studio pureQuery Runtime

Windows

  • Windows Vista Business, Enterprise, Ultimate
  • Windows 2000 Professional x86-32 bit (SP3 and SP4)
  • Windows 2000 Advanced Server x86-32 bit (SP4)
  • Windows 2003 Enterprise Edition x86-32 bit, x86-64 bit (SP1)
  • Windows 2003 Standard Edition x86-32 bit, x86-64 bit (SP1)
  • Windows XP Professional x86-32 bit (SP1 and SP2)
  • Windows XP Professional x86-64 bit (SP1 and SP2)

Linux

  • 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
  • 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

AIX®

  • AIX V5.2 64 bit
  • AIX V5.3 64 bit

Solaris

  • Sun Solaris SPARC 10 64 bit

To obtain the current information for IBM Data Studio Developer and IBM Data Studio pureQuery Runtime supported platforms refer to

For more information, refer to Installation Prerequisites in the documentation accompanying the product.

Planning information

Packaging

IBM Data Studio Developer

  • IBM Data Studio Developer for Windows DVD
  • IBM Data Studio Developer for Linux DVD
  • IBM Data Studio Developer License Enablement Kit — Multiplatform CD

IBM Data Studio pureQuery Runtime

  • IBM Data Studio pureQuery Runtime — Multiplatform DVD

Security, auditability, and control

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

Software Services

IBM Software Services has the breadth, depth, and reach to manage your services needs. You can leverage the deep technical skills of our lab-based, software services team and the business consulting, project management, and infrastructure expertise of our IBM Global Services team. Also, we extend our IBM Software Services reach through IBM Business Partners to provide an unmatched portfolio of capabilities. Together, we provide the global reach, intellectual capital, industry insight, and technology leadership to support any critical business need.

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

To locate an IBM Business Partner, visit


 
Back topBack to top
 
Ordering information

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

Product information

                                                 Product
Licensed function title     Product group        category
 
IBM Data Studio Developer   IBM Database 2(TM)   Data Studio
IBM Data Studio pureQuery   IBM Database 2       Data Studio
 Runtime

                              PID           Charge unit
Program name                  number        description
 
IBM Data Studio Developer     5724-U15      Authorized Users
IBM Data Studio pureQuery     5724-U16      Processor Value
 Runtime                                     Unit (PVU)

Charge metrics definitions

Value Unit

A Value Unit is a pricing charge metric for program license entitlements which is based upon the quantity of a specific designated measurement used for a given program. Each program has a designated measurement. The most commonly used designated measurement is a processor core. However, for select programs, there are other designated measurements such as users, client devices, and messages. The number of Value Unit entitlements required for a program depends on how the program is deployed in your environment and must be obtained from a Value Unit table. You must obtain a PoE for the calculated number of Value Unit entitlements for your implementation. The Value Unit entitlements are specific to a program and may not be exchanged, interchanged, or aggregated with Value Unit entitlements of another program.

Processor (Value Unit)

A processor core is a functional unit within a computing device that interprets and executes instructions. A processor core consists of at least an instruction control unit and one or more arithmetic or logic unit. With multicore technology, each core is considered a processor. Not all processor cores require the same number of Value Unit entitlements. To calculate the number of Value Unit entitlements required, refer to the Value Unit table on the following Web site

With full capacity licensing, a PoE must be acquired for the appropriate number of Value Units based on all activated processor cores available for use on the server.

Authorized user

An authorized user is one and only one individual (named or unnamed) within or outside your enterprise. A PoE must be obtained for each individual user accessing the program in any manner. A program licensed under an authorized user PoE may be installed on a single computer or server, and accessed by multiple users, provided that a PoE has been obtained for each individual user accessing the program either directly or indirectly (via a multiplexing program, device, or application server) through any means on behalf of the user.

Passport Advantage program licenses

IBM Data Studio Developer

                                                     Part
Part description                                     number
 
IBM Data Studio Developer
Data Studio Developer Authorized Users               D61YILL
 License and SW Maintenance 12 Months
Data Studio Developer Authorized Users               E048XLL
 SW Maintenance Annual Renewal
Data Studio Developer Authorized Users               D61YJLL
 SW Maintenance Reinstatement 12 M

IBM Data Studio pureQuery Runtime

                                                     Part
Part description                                     number
 
IBM Data Studio pureQuery  Runtime
Data Studio pureQuery RT Processor Value             D61YKLL
 Unit (PVU) License and SW Maintenance
Data Studio pureQuery RT Processor Value             E048YLL
 Unit (PVU) SW Maintenance Annual
Data Studio pureQuery RT Processor Value             D61YLLL
 Unit (PVU) SW Maintenance Reinstatement

Passport Advantage supply

                                                     Part
Program name/description                             number
 
Data Studio Developer V1.1.1
Data Studio Developer Windows 2000, Windows          BB00BML
 Vista Business, Windows Vista En
 
Data Studio pureQuery RT V1.1.1
Data Studio pureQuery RT Windows 2000, Windows       BB001EN
 Vista Business, Windows Vista

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.

Data Studio pureQuery Runtime V1.1.1

Entitled maintenance                                 Part
offerings description    Media packs description     number
 
Data Studio pureQuery    Data Studio pureQuery       BB001EN
 Runtime Processor        RT Windows 2000,
 Value Unit               Windows Vista
                          Business, Windows
                          Vista

Data Studio Developer V1.1.1

Entitled maintenance                                 Part
offerings description    Media packs description     number
 
Data Studio Developer    Data Studio Developer       BB00BML
 Authorized User          Windows 2000, Windows
                          Vista Business,
                          Windows Vista En

 
Back topBack to top
 
Terms and conditions

The information provided in this announcement letter is for reference and convenience purposes only. The terms and conditions that govern any transaction with IBM are contained in the applicable contract documents such as the IBM International Program License Agreement, IBM International Passport Advantage Agreement, and the IBM Agreement for Acquisition of Software Maintenance.

Licensing: IBM International Program License Agreement including the License Information document and 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.

License Information form numbers

                                Program
Program name                    number         Form number
 
IBM Data Studio Developer       5724-U15       L-SMKE-78FL2M
IBM Data Studio pureQuery       5724-U16       L-SMKE-78FLC7
 Runtime

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

Limited warranty applies: Yes

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.

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 Data Studio Developer                    Yes
IBM Data Studio pureQuery Runtime            Yes

Usage restriction: Yes

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

International Passport Agreement

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

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

Agreement for Acquisition of Software Maintenance

The following agreement applies for maintenance and does not require customer signatures:


    IBM Agreement for Acquisition of Software Maintenance (Z125-6011)

Volume orders (IVO): No

IBM operational support services — SoftwareXcel: No

System i™ Software Maintenance applies: No

Educational allowance available: Not applicable
 
Back topBack to top
 

Prices

Passport Advantage

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

Business Partner information

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

Trademarks

 
Database 2 and System i are trademarks of International Business Machines Corporation in the United States or other countries or both.
 
Passport Advantage, AIX, Lotus, and PartnerWorld are registered trademarks of International Business Machines Corporation in the United States or other countries or both.
 
Windows and Windows Vista are registered trademarks of Microsoft Corporation.
 
Linux is a trademark of Linus Torvalds in the United States, other countries or both.
 
Other company, product, and service names may be trademarks or service marks of others.

Back to topBack to top
 

 
Printable version Printable version