IBM DB2 Row Archive Manager: Save Money by Archiving Aged DB2 Data

Software Announcement
June 9, 1998
Announcement Letter Number: 298-184


Table of Contents:



At a Glance

Do you have questions like these?

  • How can I save storage required by my DB2 data?

  • How can I improve my DB2 performance?

  • Do I have aged data that is no longer frequently accessed?

  • How can I simplify maintenance of my DB2 data?

  • Can I lower the overall costs of my DB2 environment?
Now, get answers with DB2 Row Archive Manager. It provides you with the capability to:
  • Archive aged DB2 data at the granularity of a table row. This gives you the control you need to only archive specific data no longer required on an immediate basis and allows you to save its associated storage costs.

  • Improve DB2 performance. Removal of aged data from the rows processed by DB2 will improve the performance of table scans.

  • Archive aged data to reduce the amount of data processed by costly maintenance activities, such as reorgs, image copies, runstats, and recoveries of large DB2 tables.

  • Save money. Less storage, better performance, and simplified maintenance can mean dollar savings.
-----------------------------------------
For ordering, contact:
  Your IBM representative, an IBM
  Business Partner, or IBM North America
  Sales Centers at
    800-IBM-CALL  Reference: LE010



Overview

The DB2 (R) Row Archive Manager program can help you save storage, improve performance, simplify maintenance, and reduce overall costs of your DB2 environment. As data ages, its access patterns can change. For example, over time, accesses can change from daily to monthly to hardly ever. DB2 Row Archive Manager gives you a facility for separating aged data from active data, and archiving the aged data onto a less costly storage medium. The archived data can be selectively retrieved on demand. Archiving aged data results in less active storage requirements and less active data for DB2 to process. This can mean lower cost and better performance for your DB2 environment.

DB2 Row Archive Manager implements a set of rules specified by the administrator to determine what data is eligible to be archived. It allows data to be selected at a low level of granularity, for example, at a row level. This allows the administrator to precisely control which aged data is archived. Only selected rows are archived at any specified time and not all columns of a row need be archived. Rows from related tables can be archived as a unit. Individual tables or systems of related tables can be archived.

DB2 Row Archive Manager archives selected aged data into archive table spaces. It manages a catalog used to determine how to retrieve the aged data if it is needed by an application.

DB2 Row Archive Manager gives you control over the cost of your aged data. Can you afford to be without it?



Intended Customers

DB2 Row Archive Manager should be of interest to all DB2 customers who have a need to save storage and associated dollar savings, and have the ability to archive aged DB2 data.



Key Prerequisites

DB2 Row Archive Manager can be used with DB2 for MVS (TM) Version 3 (5685-DB2), or later releases. DB2 Row Archive Manager is installed by System Modification Program (SMP/E).



Planned Availability Date

July 10, 1998

------------------------------

This announcement is provided for your information only. For additional information, contact your IBM representative, call 800-IBM-4YOU, or visit the IBM home page at: http://www.ibm.com



DESCRIPTION

The DB2 Row Archive Manager program gives you control over separating aged data from your active DB2 data. It archives selected aged data to less costly storage media and retrieves the data when needed by your application.

Before DB2 Row Archive Manager, maintaining efficient control over large DB2 tables was a more difficult job. As data grows older, the database grows larger because new rows are continually added to it. A large database ultimately affects system performance by increasing system response time, requiring more maintenance, and using more high-cost storage. DB2 Row Archive Manager provides a solution to this problem by allowing you to control the size of your active databases, thereby demanding less of the system to meet your needs.

The data supporting many of your DB2 applications naturally ages with time. As it ages, you probably have less need to access it; however, you may occasionally need to access it. DB2 Row Archive Manager offers a way to separate and archive your aged data. It also provides the ability to retrieve this aged data when needed in a reasonable amount of time.

DB2 Row Archive Manager provides the following capabilities:

  • Control over data to be archived
      DB2 Row Archive Manager selects aged data to be archived at a low level of granularity, for example, at a row level. This gives you control over which aged data should be eligible for archival. Only selected rows are archived at any specified time, and not all columns of a row need be archived. Rows from related tables can be archived as a unit. Individual tables or systems of connected or related tables can be archived.
  • Data archival
      The DB2 Row Archive Manager administrator uses an ISPF panel interface to specify what data should be archived. These specifications are then saved in the DB2 Row Archive Manager catalog. The archival execution, which usually runs as a batch job overnight, uses the archival specification to determine which data to archive. Selected aged data is then removed from the current DB2 table spaces and moved to the archive table spaces.
  • Management of archived data
      The DB2 Row Archive Manager catalog is used to keep track of archived table spaces and used to determine how to retrieve archived data when needed.
  • Data Retrieval
      Usually applications will only need to access current data. If a situation occurs where an application tries to access archived data, the application will be unable to do so. The DB2 Row Archive Manager can use the ISPF panel interface to build a retrieval request specification. Retrievals are usually run as a batch job overnight. The retrieval execution will use the DB2 Row Archive Manager catalog to retrieve the needed data.
  • Plus:
    • Storage Management
        DB2 Row Archive Manager performs storage management functions to effectively manage the physical storage used by the archived table spaces.
    • Maintenance Utilities
        DB2 Row Archive Manager also includes additional utilities such as the REMOVE utility, which can remove erroneous or obsolete archive specifications from the system.
DB2 Row Archive Manager is a complete solution for selecting, archiving, managing, and retrieving aged data. By applying appropriate judgement on the access needs of your aged data, you can use DB2 Row Archive Manager to save DASD storage, improve your DB2 performance, and reduce the cost of your overall DB2 environment.



Year 2000

This product does not have date dependencies and is therefore Year 2000 ready.



HARDWARE AND SOFTWARE SUPPORT SERVICES



SmoothStart (TM)/Installation Services

SmoothStart or Installation Services will not be provided for DB2 Row Archive Manager.

Trademarks

      MVS and SmoothStart are trademarks of International Business
      Machines Corporation in the United States or other countries or
      both.
      DB2 is a registered trademark of International Business
      Machines Corporation in the United States or other countries or
      both.
      Other company, product, and service names may be trademarks or
      service marks of others.



SUPPLEMENTAL INFORMATION



TECHNICAL INFORMATION



Specified Operating Environment

Hardware Requirements: DB2 (R) Row Archive Manager for OS/390 (TM) operates on any hardware supporting DB2 for MVS (TM) Version 3 (5685-DB2), or later.

Software Requirements: DB2 Row Archive Manager for OS/390 requires the following minimum software versions:

  • DB2 for MVS Version 3 Release 1 (5685-DB2)

  • Data Facility Data Set Services (DFDSS) Version 2 Release 5 (5665-327)

  • Data Facility Sort (DFSORT (TM)) Version 1 Release 13 (5740-SM1)

  • Any one of the following:
    • OS PL/I Compiler, Library, and Interactive Test Facility Version 2 Release 3 (5668-909)

    • OS PL/I Compiler and Library Version 2 Release 3 (5668-910)

    • IBM Language Environment/370 (LE/370) Version 1 Release 5 (5688-198) plus IBM PL/I Compiler for MVS & VM Version 1 Release 1 Modification 1 (5688-235)
Compatibility: DB2 Row Archive Manager is upwardly compatible with IBM DB2 Data Archive Retrieval Manager/MVS (5764-012).

User Group Requirements: REQ00034697 (GBDB2X90057) Establish DB2 Archival and Retrieval System



Security, Auditability, and Control

The announced program uses the security and auditability features of the supported DB2 and/or MVS systems.

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



ORDERING INFORMATION



New Licensees

Orders for new licenses are accepted now.

Shipment will begin on Jul7 10, 1998.

New users of DB2 Row Archive Manager should specify:

                       Type               Model

5655 A31

Basic License: To order a basic license, specify the program number and feature number 9001 for asset registration. For a graduated one-time charge (OTC) or graduated monthly license charge (MLC), specify one of the following feature numbers as applicable and corresponding to the group that contains the designated machine.

Also, specify the feature number of the desired distribution medium.

                      Basic               Basic
                    Graduated           Graduated
                       OTC                 MLC
Group             Feature Number      Feature Number

18 0017 0002 20 0018 0003 25 0019 0004 28 0020 0005 29 0021 0006 30 0022 0007 31 0023 0008 32 0024 0009 35 0025 0010 38 0026 0011 40 0027 0012 50 0028 0013 60 0029 0014 70 0030 0015 80 0031 0016

Multiple Operating System -- PR/SM (TM) (MOSP): For a graduated OTC or graduated MLC, specify the following feature number corresponding to the group that contains the designated machine.

                    MOSP Basic          MOSP Basic
                    Graduated           Graduated
                       OTC                 MLC
Group             Feature Number      Feature Number

18 0047 0032 20 0048 0033 25 0049 0034 28 0050 0035 29 0051 0036 30 0052 0037 31 0053 0038 32 0054 0039 35 0055 0040 38 0056 0041 40 0057 0042 50 0058 0043 60 0059 0044 70 0060 0045 80 0061 0046

Note: The group can be determined by referring to either the Exhibit for IBM System/390 (R) Machines (Z125-3901) or the Exhibit for Non-IBM Machines (Z125-3902) associated with the IBM Customer Agreement (Z125-4575).

Entry Support License (ESL): To order an ESL license, specify the program number, feature number 9001 for asset registration, and the applicable ESL OTC feature number. Also specify the feature number of the desired distribution medium.

                                                ESL OTC
                              Product           Feature
Description                   Number             Number

DB2 Row Archive 5655-A31 0001 Manager

Note: ESL machines can be determined by referring to the IBM Entry End User/390 Attachment (Z125-4379).

Parallel Sysplex (R) License Charge (PSLC) Basic License: To order a basic license, specify the program number and feature number 9001 for asset registration. Specify the PSLC Base feature and applicable PSLC Level A and PSLC Level B features and quantity.

In a Parallel Sysplex, if there is more than one program copy, the charge for all copies should be associated with one copy by specifying the applicable PSLC feature numbers and quantity represented by the sum of the Service Units in Millions (MSUs) in your Parallel Sysplex. For all other program copies, specify the PSLC No Charge (NC) Identifier feature.

Also, specify the feature number of the desired distribution medium.

PSLC Basic License
MLC Feature                        PSLC Machine    Feature
Description                        MSU Capacity     Number

PSLC Base, 1 MSU 1 0126 PSLC Base, 2 MSUs 2 0127 PSLC Base, 3 MSUs 3 0128

PSLC Level A, 1 MSU 4 to 45 0129 PSLC Level A, 42 MSUs 0130

PSLC Level B, 1 MSU 46 or more 0131 PSLC Level B, 10 MSUs 0132 PSLC Level B, 50 MSUs 0133

PSLC NC Identifier Not Applicable 0134

Example 1: A single machine with 11 MSU PSLC program features is 0128, quantity 1 and 0129, quantity 8

Example 2: Two machines with 60 aggregate MSUs in a Parallel Sysplex PSLC program features are:

  • PSLC Chargeable Program 1 -- 0128, quantity 1, 0130, quantity 1, 0131, quantity 5, and 0132, quantity 1.

  • PSLC No-Charge Program 2 -- 0134, quantity 1
Indexed Monthly License Charge (IMLC) Basic License: To order a basic license, specify the program number and feature number 9001 for asset registration. Specify the IMLC Base 80 MSUs feature, the applicable additional IMLC MSU features, and quantity corresponding to the MSU rating of the designated machine.

Also, specify the feature number of the desired distribution medium.

IMLC Basic License                         IMLC
MLC Feature                              Feature
Description                               Number

IMLC BASE 80 MSUs 0122 IMLC 1 MSU 0123 IMLC 10 MSUs 0124 IMLC 50 MSUs 0125

Single Version Charging: To elect single version charging, the customer must notify and identify to IBM the prior program and replacement program and the designated machine the programs are operating on.

Version-to-Version Upgrade Credit: To upgrade from a prior program acquired for an OTC to a replacement program using a version-to-version upgrade credit, the customer must notify and identify to IBM the applicable prior program and replacement program participating in the upgrade credit.

Basic Machine-Readable Material: To order, select the feature number of the desired distribution medium:

                             Feature         Distribution
Environment                   Number         Medium

DB2 Row Archive Manager 5801 9/6250 bpi tape DB2 Row Archive Manager 5802 3480 cartridge DB2 Row Archive Manager 5700 4-mm cartridge

Customization Options: Select the appropriate feature numbers to customize your order to specify the delivery options desired. These features can be specified on the initial or MES orders.

Example: If publications are not desired for the initial order, specify feature number 3470 to ship media only. For future updates, specify feature number 3480 to ship media updates only. If, in the future, publication updates are required, order an MES to remove feature number 3480; then, the publications will ship with the next release of the program.

                                                    Feature
Description                                         Number

Initial Shipments

Serial Number Only (suppresses shipment 3444 of media and documentation)

Ship Media Only (suppresses initial 3470 shipment of documentation)

Ship Documentation Only (suppresses 3471 initial shipment of media)

Update Shipments

Ship Media Updates Only (suppresses 3480 update shipment of documentation)

Ship Documentation Only (suppresses 3481 update shipment of media)

Suppress Updates (suppresses update 3482 shipment of media and documentation)

Expedite Shipments

Local IBM Office Expedite 3445 (for IBM use only)

Customer Expedite Process Charge 3446 ($30 charge for each product)

Expedite shipments will be processed to receive 72-hour delivery from the time IBM Software Manufacturing Solutions (SMS) receives the order. SMS will then ship the order via overnight air transportation.

DSLO License: To order a DSLO license, specify the program number, feature number 9901 for asset registration, and the feature number for a graduated OTC or graduated MLC that corresponds to the group containing the designated machine.

                       DSLO                DSLO
                    Graduated           Graduated
                       OTC                 MLC
Group             Feature Number      Feature Number

18 0077 0062 20 0078 0063 25 0079 0064 28 0080 0065 29 0081 0066 30 0082 0067 31 0083 0068 32 0084 0069 35 0085 0070 38 0086 0071 40 0087 0072 50 0088 0073 60 0089 0074 70 0090 0075 80 0091 0076

Multiple Operating System -- PR/SM (MOSP): For a graduated OTC or graduated MLC, specify the following feature number corresponding to the group that contains the designated machine.

                    MOSP DSLO           MOSP DSLO
                    Graduated           Graduated
                       OTC                 MLC
Group             Feature Number      Feature Number

18 0107 0092 20 0108 0093 25 0109 0094 28 0110 0095 29 0111 0096 30 0112 0097 31 0113 0098 32 0114 0099 35 0115 0100 38 0116 0101 40 0117 0102 50 0118 0103 60 0119 0104 70 0120 0105 80 0121 0106

Ordering a DSLO feature will result in IBM maintaining a record of this customer location as a DSLO user only. All material for the DSLO license will be provided through the basic license location. If a user selects DSLO, no other feature numbers are valid for this order and no program materials or updates will be shipped.

Unlicensed Documentation: A program directory and one copy of the following publications are supplied automatically with the basic machine-readable material:

                                                  Order
Title                                             Number

DB2 Row Archive Manager GC26-8952 Customization and Administration Guide DB2 Row Archive Manager Messages GC26-8953 and Codes DB2 Row Archive Manager Application GC26-8954 Programming Guide DB2 Row Archive Manager GC26-8955 Licensed Program Specifications

Additional copies of unlicensed publications are available for a fee immediately. These copies can be ordered from your IBM representative, through the System Library Subscription Service (SLSS), or by direct order.

Subsequent updates (technical newsletters or revisions between releases) to the publications shipped with the product will be distributed to the user of record for as long as a license for this software remains in effect. A separate publication order or subscription is not needed.



TERMS AND CONDITIONS

Licensing: IBM Customer Agreement

Variable Charges Apply: Yes

Installation License or Location License Applies: No

Usage Restriction Applies: No

Educational Allowance: Yes, to qualified education customers.

Volume Discount: Not applicable

Version-to-Version Upgrade Credits Apply: Yes

                                                  Single
                                                 Version
Replaced Program       Replacement Program       Charging
 Number   Name         Number      Name          Applies

5655-A31 DB2 RAM To a follow-on if any Yes

Warranted: Yes

Licensed Program Materials Availability

  • Restricted Materials of IBM: None
  • Non-Restricted Source Materials: None
  • Object Code Only (OCO): All
Testing Period: Two months (Basic license only)

Program Services

  • Support Center applies: Yes. Access is available through the IBM Support Center.

  • Available until discontinued: 12-months' written notice

  • APAR Mailing Address:
      IBM Corporation 555 Bailey Ave San Jose, CA 95141
  • Services for DSLO Licenses: Provided through basic license location
Support Line: S/390 (R)



CHARGES

Contact your IBM representative for charges information for this announcement.

OTC: Customers who pay an OTC for a licensed program receive enhancements and future releases, if any, at no additional charge. Significant new function may be offered as an optional feature and charged for separately. If a replacement program is announced and the customer elects to license the replacement program, a time-based upgrade credit may apply.

Variable Charges: The applicable graduated OTC or graduated MLC will be based on the group of the designated machine on which the licensed program is licensed for use. If the program is designated to a processor in a group for which no charge is listed above, the charge of the next higher group listed applies.

For upgrades of OTC licenses to a machine in a higher group, the upgrade charge will be the difference in the then current charges between the two groups. For downgrades of OTC licenses to a machine in a lower group, there will be no adjustment or refund of OTCs paid.

For upgrades or downgrades of MLC licenses, the MLC applicable to the higher or lower group will apply.

Entry Support License OTC: OTC authorizes use only on IBM Entry End User/390 Machines.



CALL NOW TO ORDER

To order, contact the IBM North America Sales Centers, your local IBM representative, or your IBM Business Partner.

IBM North America Sales Centers, our national direct marketing organization, can add your name to the mailing list for catalogs of IBM products.

 Phone:     800-IBM-CALL (TM)
 Fax:       800-2IBM-FAX
 Internet:  ibm_direct@vnet.ibm.com
 Mail:      IBM North America Sales Centers
            Dept. LE010
            P.O. Box 16848
            Atlanta, GA  30321-0848
 Reference: LE010

To identify your local IBM Business Partner or IBM representative, call 800-IBM-4YOU.

Note: Shipments will begin after the planned availability date.

Trademarks

      OS/390, MVS, DFSORT, PR/SM, and 800-IBM-CALL are trademarks of
      International Business Machines Corporation in the United
      States or other countries or both.
      DB2, System/390, Parallel Sysplex, and S/390 are registered
      trademarks of International Business Machines Corporation in
      the United States or other countries or both.
      Other company, product, and service names may be trademarks or
      service marks of others.