IBM Optim distributed products Version 7.3 offer new database and operating system support, extract and archive performance improvements, and deeper Optim Designer supportIBM United States Software Announcement 210-279
September 21, 2010
|Table of contents|
(Corrected on December 1, 2010)The Ordering information section was revised.
(Corrected on November 24, 2010)The Ordering information section was revised.
|At a glance|
Version 7.3 of the Optim Test Data Management, Data Growth, and Application Retirement solutions offers the following enhancements:
- Added support for the following applications
- SQL Server 2008
- DB2® LUW 9.5 and 9.7
- Oracle 11gR2
- DB2 z/OS® V10.1
- Unicode support on Informix®
- DB2 9.7
- Oracle 11g
- Performance improvements
- Improved ODM performance: Improved response times of long-running ODM queries
- Resource estimator
- Loader enhancements
- Load Zero Row: Optim supports data load of empty table (from archive or extract file) to databases on DB2 LUW, Informix, Oracle, Sybase, and SQL Server.
- Load DB2 LUW statistics.
- Remote client loading.
- Teradata Loading - Named Pipe: Optim provides a single-step Load flow using named pipes. Reduces I/O and hard drive space requirements.
- Oracle Loader performance enhancement (parallel and no recovery).
- Teradata expanded datatype support: Optim supports LOBs (Locator OBject) data load to teradata database.
- Lift 256-byte Rel and PK limit.
- Support Import on UNIX®
- Delete Impact Analysis: Optim reports on database storage savings for DB2 LUW and Oracle as a result of delete process.
- Upgrade to Centera SDK 3.2.
For ordering, contact your IBM® representative, an IBM Business Partner, or IBM Americas Call Centers at 800-IBM-CALL (Reference: YE001).
Back to top
Optim Data Growth Solution enables you to archive historical transaction records from mission-critical database applications. Application data is more safely relocated to a secure archive, thereby helping to streamline the production database to aid your efforts to reduce processing overhead. You retain universal access to archived information. The Optim Data Growth Solution can help you improve application performance and support data-retention compliance programs and efforts to lower IT costs.
Optim Data Growth Solution - Open Data Manager is an optional, chargeable component that can help improve access to archived data. Optim Open Data Manager allows Optim Data Growth clients standard SQL support to more easily access, serve, and report on archived files using standard mechanisms such as ODBC or JDBC.
Optim Data Growth Solution - Non Relational Connectors adds data growth support for many nonrelational and legacy data sources and applies it to the proven capabilities to archive historical transaction records from mission-critical applications. Application data is more safely relocated to a secure archive, thereby helping to streamline the production database to aid your efforts to reduce processing overhead.
Optim Solution for Application Retirement provides application retirement/de-commissioning capabilities that enable organizations to retire applications and associated hardware environments, while still retaining access to the application data, helping reduce ongoing maintenance costs of these environments.
Optim Test Data Management Solution allows you to create realistic, right-sized test databases, edit data to force error and boundary conditions, and compare baseline data against successive test results to pinpoint application errors that could otherwise go undetected. By streamlining your test data management process, the Optim Test Data Management Solution can help you improve quality, speed iterative testing tasks, and accelerate revenue generation.
Optim Test Data Management Solution - Data Privacy Option is an optional, chargeable component that will allow Optim Test Data Management customers to mask and transform sensitive test data as part of their efforts to avoid severe consequences. Optim's masking techniques include using arithmetic expressions, sub-strings, random or sequential number generation, date aging, and more. Most importantly, you can propagate masked values from a parent table to related tables at all levels essential for maintaining the referential integrity of the data.
Optim Test Data Management Solution - Non Relational Connectors adds test data management and data privacy support for many additional nonrelational and legacy data sources to privatize or create right-sized test databases, edit data to force error and boundary conditions, and compare baseline data against successive test results to pinpoint application errors that could otherwise go undetected.
For more information on the IBM Optim family of products, visit
Back to top
The announced products run on a variety of Windows®, UNIX, and Linux® platforms.
Back to top
|Planned availability date|
September 24, 2010
Accessibility by people with disabilities
A U.S. Section 508 Voluntary Product Accessibility Template (VPAT) containing details on accessibility compliance can be requested at
Back to top
Program Program number VRM name 5724-U38 V7.3 Optim Data Growth Solution 5724-U38 V7.3 Optim Data Growth Solution - Open Data Manager 5724-U38 V7.3 Optim Data Growth Solution - Non Relational Connectors 5724-U48 V7.3 Optim Test Data Management Solution 5724-U48 V7.3 Optim Test Data Management Solution - Data Privacy Option 5724-U48 V7.3 Optim Test Data Management Solution - Non Relational Connectors 5724-U39 V7.3 Optim Solution for Application Retirement
Back to top
Product information is available via the Offering Information website
Also, visit the Passport Advantage® website
Back to top
All product publications are provided in softcopy format on the product CD-ROMs and DVDs.
In addition, a hardcopy license document is shipped with some of the products.
Back to top
Specified operating environment
For information on hardware requirements, refer to
For information on software requirements, refer to
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.
The media pack for each of the announced products includes:
- Product code, documentation and Quick Start Guide on CD-ROM or DVD
- Optim Quick Start Guide in hardcopy form
In addition, a hardcopy license document is shipped with some of the products.
Security, auditability, and control
The Optim family of products 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
Back to top
Ordering information for license and Subscription and Support part numbers is unchanged from previous announcements. Refer to Software Announcements 209-404, dated November 24, 2009, and 210-191, dated July 06, 2010 for ordering details.
Part Number Program name/Description Optim Data Growth Solution (5724-U38): BB14WEN Optim Data Growth Solution V7.3 Multiplatform English Media Pack Optim Data Growth Solution - Open Data Manager (5724-U38): BB14XEN Optim Data Growth Solution - Open Data Manager V7.3 Multiplatform English Media Pack Optim Data Growth Solution - Non Relational Connectors (5724-U38): BB14YEN Optim Data Growth Solution - Non Relational Connectors V7.3 Multiplatform English Media Pack Optim Test Data Management Solution (5724-U48): BB14ZEN Optim Test Data Management Solution V7.3 Multiplatform English Media Pack Optim Test Data Management Solution - Data Privacy Option (5724-U48): BB150EN Optim Test Data Management Solution - Data Privacy Option V7.3 Multiplatform English Media Pack Optim Test Data Management Solution - Non Relational (5724-U48): BB151EN Optim Test Data Management Solution - Non Relational Connectors V7.3 Multiplatform English Media Pack Optim Solution for Application Retirement (5724-U39): BB152EN Optim Solution for Application Retirement V7.3 Multiplatform English Media Pack
Back 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.
This product is only available via Passport Advantage. It is not available as shrinkwrap.
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 (also referred to as Software Maintenance).
These programs are licensed under the IBM Program License Agreement (IPLA) and the associated Agreement for Acquisition of Software Maintenance, which provide for support with ongoing access to releases and versions of the program. IBM includes one year of Software Subscription and Support with the initial license acquisition of each program acquired. The initial period of Software Subscription and Support can be extended by the purchase of a renewal option, if available. These programs have a one-time license charge for use of the program and an annual renewable charge for the enhanced support that includes telephone assistance (voice support for defects during normal business hours), as well as access to updates, releases, and versions of the program as long as support is in effect.
License Information form numbers
License Information Product number number Product name L-TDEN-87VNFT 5724-U38 Optim Data Growth Solution L-TDEN-87VNVB 5724-U38 Optim Data Growth Solution - Open Data Manager L-TDEN-87VNZQ 5724-U38 Optim Data Growth Solution - Non Relational Connectors L-TDEN-87VP65 5724-U48 Optim Test Data Management Solution L-TDEN-87VPAW 5724-U48 Optim Test Data Management Solution - Data Privacy Option L-TDEN-87VPEB 5724-U48 Optim Test Data Management Solution - Non Relational Connectors L-TDEN-87VSC3 5724-U39 Optim Solution for Application Retirement
These programs' License Information documents will be available for review on the IBM Software License Agreement website
Limited warranty applies
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. For further information, consult the IBM Software Support Handbook found at
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 three years from the general availability date, as long as your Software Subscription and Support (also referred to as 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 Subscription and Support 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.
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 clarification, note that (1) for programs acquired under the IBM International Passport Advantage offering, this term applies only to your first acquisition of the program and (2) for programs acquired under any of IBM's On/Off Capacity on Demand (On/Off CoD) software offerings, this term does not apply since these offerings apply to programs already acquired and in use by you.
Authorization for use on home/portable computer
You may not copy and use this program on another computer without paying additional license fees.
Volume orders (IVO)
Passport Advantage applies
Yes, and through the Passport Advantage website at
Software Subscription and Support 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, only 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
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 website at
System i Software Maintenance applies
Variable charges apply
Educational allowance available
Back to top
|IBM Electronic Services|
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.
To learn how Electronic Services can work for you, visit
Back to top
For additional information and current prices, contact your local IBM representative.
For Passport Advantage information and charges, contact your IBM representative or authorized IBM Business Partner for Software ValueNet®. Additional information is also available at
IBM Global Financing
IBM Global Financing offers competitive financing to credit-qualified customers to assist them in acquiring IT solutions. Offerings include financing for IT acquisition, including hardware, software, and services, from both IBM and other manufacturers or vendors. Offerings (for all customer segments: small, medium, and large enterprise), rates, terms, and availability can vary by country. Contact your local IBM Global Financing organization or visit
IBM Global Financing offerings are provided through IBM Credit LLC in the United States, and other IBM subsidiaries and divisions worldwide to qualified commercial and government customers. Rates are based on a customer's credit rating, financing terms, offering type, equipment type, and options, and may vary by country. Other restrictions may apply. Rates and offerings are subject to change, extension, or withdrawal without notice.
Financing from IBM Global Financing helps you preserve cash and credit lines, enables more technology acquisition within current budget limits, permits accelerated implementation of economically attractive new technologies, offers payment and term flexibility, and can help match project costs to projected benefits. Financing is available worldwide for credit-qualified customers.
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) For IBM representative: firstname.lastname@example.org For IBM Business Partner: email@example.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
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.
IBM Software ValueNet
These products are available under IBM Software ValueNet, either directly from IBM or through authorized Business Partners who invest in skills and high-value solutions. IBM customers may benefit from the industry-specific or horizontal solutions, skills, and expertise provided by these Business Partners.
Additions to Software ValueNet will be communicated through standard product announcements. For a current list of IBM software available under Software ValueNet, visit
Questions regarding IBM Software ValueNet may be sent to AskSoftwareValueNet@us.ibm.com
Optim and Electronic Service Agent are trademarks of IBM Corporation in the United States, other countries, or both.
DB2, z/OS, Informix, IBM, Passport Advantage, ValueNet and ibm.com are registered trademarks of IBM Corporation 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.
Linux is a registered 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.
For the most current information regarding IBM products, consult your IBM representative or reseller, or visit the IBM worldwide contacts page