Data and Database Management Software
Software helps archive and retrieve DB2 data objects.
Press Release Summary:
With support for DB2 UDB on Linux, UNIX, and Microsoft Windows, DB2® Data Archive Expert for Multiplatforms v2.1 enables user to move seldom-used data to less expensive media, without programming. It supports archiving sets of rows representing application objects, and offers callable API for running archive and retrieve operations by using units of work. DB2 Grouper Component discovers relationships between tables from definitional and access sources.
Original Press Release:
New Database Archiving Tool for Multiplatforms and Other Enhanced Tools Enrich IBM DB2
DB2 Data Archive Expert for Multiplatforms V2.1 is an autonomic tool that offers a fast, flexible, and efficient way to archive and retrieve DB2 data objects. With support for DB2 UDB on Linux, UNIX, and Microsoft Windows, DB2 Data Archive Expert can help:
Increase the performance of your IBM DB2 UDB environment
Lower disk storage costs by moving seldom-used data to less expensive media
Reduce database administration costs through improved application efficiency
DB2 Test Database Generator for Multiplatforms V2.2 helps safeguard confidential production data needed in test environments. V2.2 helps companies:
Easily create DB2 test data for new and existing applications
Respond with confidence to today's data privacy regulations
DB2 Performance Expert V2.2 includes support for Linux on xSeries 64-bit.
For ordering, contact:
Your IBM representative or IBM Americas Call Centers at 800-IBM-CALL (Reference: YE001).
Overview
DB2® Data Archive Expert for Multiplatforms
DB2 Data Archive Expert for Multiplatforms is a comprehensive data archiving tool that enables you to move seldom-used data to a less costly storage medium, without any programming. Using this tool, you can save storage space and associated costs, while improving the performance of your DB2 Universal Database® (UDB) environment.
Key features include:
Facilitates moving inactive DB2 data to both table archives and flat file archives.
Archiving helps you lower storage costs and reclaim disk space. It can also help improve performance when accessing active data.
Exploits less expensive media for archived data, and can access archived data concurrently with minimal changes to applications.
Provides a Web-based user interface (UI) that helps you configure and use the tool. This Web UI also works with DB2 Data Archive Expert for z/OS®.
Supports archiving sets of rows representing application objects, not just entire tables.
Offers a callable API for running archive and retrieve operations by using units of work called specifications.
Provides easy creation of specifications and allows the development of job profiles through Web-based UI panels.
Lets you do "table-grouping" using the DB2 Grouper Component feature, which discovers relationships between tables from definitional as well as access sources, making it easy to include tables related to those being archived.
Supports archiving cross-platform within the DB2 DAE product family (z/OS, UNIX®, Microsoft(TM) Windows(TM), and Linux(TM)), between entitled installed products.
DB2 Test Database Generator for Multiplatforms
With data privacy regulations expanding worldwide, companies are more focused than ever on safeguarding production data that is used in development and test environments. DB2 Test Database Generator for Multiplatforms V2.2 lets you easily create subsets of DB2 production data while masking out any sensitive or confidential data like identification numbers, salaries, addresses, or financial information. DB2 Test Database Generator helps you quickly meet testing needs, while protecting private data and avoiding unnecessary liability.
Key enhancements in DB2 Test Database Generator V2.2 include the ability to:
Compare and synchronize DB2 tables
Update existing data without deleting it and re-creating it
Leverage additional DB2 Load Format options
Support the DB2 JDBC type 4 driver
Support the DB2 Test Database Generator Server on Linux operating environments
DB2 Performance Expert
DB2 Performance Expert for Multiplatforms V2.2 adds support for Linux on xSeries® 64-bit.
For detailed information about previously announced DB2 Performance Expert for Multiplatforms V2.2 and DB2 Performance Expert for Workgroups V2.2, refer to Software Announcement, 205-140 , dated June 7, 2005.
Planned availability dates
December 9, 2005, electronic software delivery for all products
December 9, 2005, media and documentation for DB2 Performance Expert for Multiplatforms V2.2 and DB2 Performance Expert for Workgroups V2.2
January 20, 2006, media and documentation for DB2 Data Archive Expert for Multiplatforms V2.1 and DB2 Test Database Generator for Multiplatforms V2.2
