Skip to main content

Software > Information Management > IBM DB2 and IMS Tools >

DB2 Data Archive Expert


Information Management software
Overview

Do you need to lower data storage costs and reclaim disk space?

  • Are government compliance and auditing regulations requiring you to maintain more data than ever before?
  • Is performance being impacted because data volumes are increasing?
  • Are transactions timing out because there are too many records to search through?
  • Is it getting too expensive to maintain growing data volumes?
  • Do you need to archive data cross-platform?

Keeping production systems trim and responsive are key focuses for most DBAs in today's business environment, especially with regulatory compliance laws like Sarbanes-Oxley (SOX) requiring that DBAs retain more data than ever before. DB2 Data Archive Expert, part of IBM's suite of regulatory compliance tools, helps you meet these requirements as well as improve the performance of your DB2 environment by enabling you to move seldom-used data to a less costly storage medium without additional programming.

Buy DB2 Data Archive Expert as part of the DB2 Toolkit, which offers six Tools at a significant cost savings
Visit the DB2 Multiplatform Tools website

Customer Experiences

"The combination of System z9 and DB2 Data Archive Expert has reduced the time it takes to run an average query up to 10 percent. The main advantages of the new solution are the increased speed of computation and the greater control over archived data. But we also expect considerable cost savings."

-Judith Weigel, DB2 Administrator
Stadtsparkasse Munchen


Key Features
  • Discovers relationships between tables from definitional as well as access sources using the IBM DB2 Grouper Component, making it easy to include tables related to those being archived.
  • Lets you move DB2 data to table or flat-file archives on either DASD or tape
  • Archives sets of rows representing application objects, not just entire tables.
  • Lets you write archive specifications only once and then automatically replicates the specifications from test to production systems.
  • Using a Web-based interface, lets you access archived data cross platform on z/OS as well as Linux, UNIX and Windows (licensed separately).
  • Automatically recognizes when a column has been added to a source table and updates the existing specification definition and the archive target tables after data has been archived.
  • Helps you save storage space and the associated costs while adhering to regulatory compliance requirements.
  • Available for DB2 on z/OS, Linux, UNIX and Microsoft Windows.

Program numbers:
DB2 Data Archive Expert for z/OS (5697-J22)
DB2 Data Archive Expert for Multiplatforms (D570TLL)
DB2 Toolkit for Multiplatforms (D57UKLL)

DB Application Management


Related Tools
DB2 Administration Tool
DB2 Audit Management Expert
DB2 Object Restore Tool
DB2 Test Database Generator
IBM Application Recovery Tool for IMS and DB2
IBM Data Encryption for IMS and DB2 Databases

System Requirements

IBM DB2 Data Archive Expert for z/OS, V2.1 requires:

  • DB2 Universal Database for z/OS, Version 7 or later
  • z/OS operating system, Version 1.4 or later
  • DB2 Utilities Suite for z/OS, Version 7 or later
  • SDK for OS/390 Java 2 Technology Edition V1.3, or later
  • Remote archiving from DB2 V7 to DB2 V8 requires APAR PK07076 be applied on DB2 V8.
  • For client support, DB2 UDB Administration Client is required.
  • Integrated Solutions Console (ISC) component requires one of the following: AIX 5.2 64-bit, Windows 2000 or later 32-bit ; Linux for xSeries 32-bit; or Solaris 8 32-bit

DB2 Data Archive Expert for Multiplatforms, V2.1 supports DB2 UDB Enterprise Server Edition V8.1 with Fix Pack 9 or later.

For more information on the system requirements for DB2 Data Archive Expert on z/OS, see the Program Directory on the Library page.

For more information on the system requirements for DB2 Data Archive Expert for Multiplatforms, see the announcement letter dated December 06, 2005.


Offsite link Get Adobe® Reader®


Ready to buy?

View pricing & buy


We're here to help
Easy ways to get the answers you need.
Request a quote
E-mail IBM

or call us at
877-426-3774
Priority code:
104CBW60


Highlights

Customer success story: Stadtsparkasse Munchen bank increases productivity and improves customer service

Analyst Report: Meeting Regulatory Compliance Challenges

Article: "Simplify regulatory compliance with DB2 Tools for z/OS"

Article: Regulatory Compliance and Your Data

Regulatory Compliance Tools Suite (PDF 96KB)


Technical details

Fact Sheet (PDF)

Product Life Cycle


Publications

Library

See analyst report on test data and archiving.

DB2 Magazine Article: "Take a Load Off: Archive Inactive Data"