Release notes - IBM Data Studio Administrator for DB2 Linux, UNIX and Windows Version 1.2

Data Studio Administrator V1.2 is available. These release notes contain information about Data Studio Administrator V1.2. Known limitations, installation, and other getting-started issues are addressed.

Contents

Description

Data Studio Administrator V1.2 is a powerful and flexible tool that simplifies the process of identifying, analyzing, and managing database schema changes for DB2® for Linux®, UNIX®, and Windows®. You can also use Data Studio Administrator to visualize your changes before you make them.

Announcement

The Data Studio Administrator V1.2 announcement is available at www.ibm.com/common/ssi/OIX.wss. See the announcement for the following information:
  • Detailed product description, including a description of new function
  • Product-positioning statement
  • Packaging and ordering details
  • International compatibility information

New in this release

This release adds support for:
Process Flows
  • Change In Place
  • Migrate Objects
  • Migrate Data
  • Apply Another Deployment Script
Enhanced Command Generation Wizard
  • External data preservation options: HPU, LOAD
  • Maintenance commands: REORG, SET INTEGRITY
  • Auto cast data types
  • Rename table
  • Added support for Multi dimensional clustered tables
  • Added functionality to generate commands that enforce RI or reload data without constraints (establishing constraints once the data is loaded)
  • Added forward engineering support for COMMENT ON TABLE and identity columns
  • Added support for internal data preservation where data is preserved internally.
  • Added support for CURSOR FROM LOAD
Deployment Script Updates
  • Added deployment states
  • Added the ability to reset and reuse deployment scripts
  • Undo, partial undo, and restart capabilities
  • Added a new method of updating the deployment script when the database has been changed
Three different types of reports that help you analyze and manage your changes
  • Summary of Changes reports
  • Deployment reports
  • Database Unit Test reports
Editors
Improvements to the Data Model Editor
Added support for new objects during impact analysis
  • Packages
  • Stored procedures
  • User-defined functions
  • Triggers
Migration
  • The ability to migrate objects from scripts or the database in addition to physical data models
  • The ability to migrate data within an environment or between environments
  • New functionality to mask and ignore objects when you migrate objects
Visual Explain
Integration with Visual Explain to view helpful information for SQL statements
Authorizations
  • Authorization Preservation (in the model)
  • Added support for authorizations to reverse engineering, and forward engineering
Other
New database unit test functionality that allows you to test the changes that were deployed to your database. Data Studio Administrator performs row counting tests, database object validity checking, and missing object checking.
Corrected known problems
  • APAR PK55711 LOBS TO statement in EXPORT for undo is fixed in Data Studio Administrator V1.2.
  • APAR PK54601 Forward engineering is changed so that an index that is being used as the primary key index is destructively altered correctly in Data Studio Administrator V1.2.

System requirements

For information about hardware and software requirements, see the detailed installation requirements document at http://publib.boulder.ibm.com/infocenter/dstudio/v1r1m0/index.jsp?topic=/com.ibm.admin.doc/chxuinstallmst.html.

Compatibility with other products

For the most up to date information about compatibility with other products, see the Installation Guide in the Data Studio Information Center at: http://publib.boulder.ibm.com/infocenter/dstudio/v1r1m0/index.jsp?topic=/com.ibm.admin.doc/chxuinstallmst.html

Installing Data Studio Administrator V1.2

For step-by-step installation instructions, see the Installation Guide in the Data Studio Information Center:

Known problems

Known problems are documented in the form of individual technotes in the Support knowledge base at http://www.ibm.com/software/data/studio/support.html. As problems are discovered and resolved, the IBM® Support team updates the knowledge base. By searching the knowledge base, you can quickly find workarounds or solutions to problems.

The following link launches a customized query of the live Support knowledge base: http://www.ibm.com/support/search.wss?rs=3504&tc=SS4RSW&rankprofile=8&dc=DB520+D800+D900+DA900+DA800&dtm.

See the Data Studio Administrator User's Guide for additional restrictions and troubleshooting information for common problems that you might encounter when using Data Studio Administrator.

Notices

This information was developed for products and services offered in the U.S.A.

IBM may not offer the products, services, or features discussed in this document in other countries. Consult your local IBM representative for information on the products and services currently available in your area. Any reference to an IBM product, program, or service is not intended to state or imply that only that IBM product, program, or service may be used. Any functionally equivalent product, program, or service that does not infringe any IBM intellectual property right may be used instead. However, it is the user's responsibility to evaluate and verify the operation of any non-IBM product, program, or service.

IBM may have patents or pending patent applications covering subject matter described in this document. The furnishing of this document does not grant you any license to these patents. You can send license inquiries, in writing, to: IBM Director of Licensing IBM Corporation North Castle Drive Armonk, NY 10504-1785 U.S.A.

For license inquiries regarding double-byte (DBCS) information, contact the IBM Intellectual Property Department in your country or send inquiries, in writing, to: IBM World Trade Asia Corporation Licensing 2-31 Roppongi 3-chome, Minato-ku Tokyo 106-0032, Japan

The following paragraph does not apply to the United Kingdom or any other country where such provisions are inconsistent with local law: INTERNATIONAL BUSINESS MACHINES CORPORATION PROVIDES THIS PUBLICATION "AS IS" WITHOUT WARRANTY OF ANY KIND, EITHER EXPRESS OR IMPLIED, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF NON-INFRINGEMENT, MERCHANTABILITY OR FITNESS FOR A PARTICULAR PURPOSE. Some states do not allow disclaimer of express or implied warranties in certain transactions, therefore, this statement may not apply to you.

This information could include technical inaccuracies or typographical errors. Changes are periodically made to the information herein; these changes will be incorporated in new editions of the publication. IBM may make improvements and/or changes in the product(s) and/or the program(s) described in this publication at any time without notice.

Any references in this information to non-IBM Web sites are provided for convenience only and do not in any manner serve as an endorsement of those Web sites. The materials at those Web sites are not part of the materials for this IBM product and use of those Web sites is at your own risk.

IBM may use or distribute any of the information you supply in any way it believes appropriate without incurring any obligation to you.

Licensees of this program who wish to have information about it for the purpose of enabling: (i) the exchange of information between independently created programs and other programs (including this one) and (ii) the mutual use of the information which has been exchanged, should contact:

IBM Corporation
J46A/G4
555 Bailey Avenue
San Jose, CA 95141-1003
U.S.A.

Such information may be available, subject to appropriate terms and conditions, including in some cases, payment of a fee.

The licensed program described in this document and all licensed material available for it are provided by IBM under terms of the IBM Customer Agreement, IBM International Program License Agreement or any equivalent agreement between us.

Information concerning non-IBM products was obtained from the suppliers of those products, their published announcements or other publicly available sources. IBM has not tested those products and cannot confirm the accuracy of performance, compatibility or any other claims related to non-IBM products. Questions on the capabilities of non-IBM products should be addressed to the suppliers of those products.

All statements regarding IBM's future direction or intent are subject to change or withdrawal without notice, and represent goals and objectives only.

This information contains examples of data and reports used in daily business operations. To illustrate them as completely as possible, the examples include the names of individuals, companies, brands, and products. All of these names are fictitious and any similarity to the names and addresses used by an actual business enterprise is entirely coincidental.

COPYRIGHT LICENSE:

This information contains sample application programs in source language, which illustrate programming techniques on various operating platforms. You may copy, modify, and distribute these sample programs in any form without payment to IBM, for the purposes of developing, using, marketing or distributing application programs conforming to the application programming interface for the operating platform for which the sample programs are written. These examples have not been thoroughly tested under all conditions. IBM, therefore, cannot guarantee or imply reliability, serviceability, or function of these programs.

(C) Copyright IBM Corporation 2005, 2008. All rights reserved. Note to U.S. Government Users Restricted Rights -- Use, duplication, or disclosure restricted by GSA ADP Schedule Contract with IBM Corp.

Trademarks

The following terms are trademarks or service marks of the IBM Corporation in the United States or other countries or both:
  • AIX®
  • DB2
  • IBM
  • Java™
  • Linux
  • Microsoft®
  • UNIX
  • Windows
  • Windows NT®
  • pSeries®
  • xSeries®
  • zSeries®

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

Microsoft, Windows, Windows NT, and the Windows logo are trademarks of Microsoft 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.

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

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