IBM DB2 Row Archive Manager: Save Money by Archiving Aged DB2 Data
June 9, 1998
Announcement Letter Number: 298-184
Table of Contents:
- At a Glance
- SUPPLEMENTAL INFORMATION
- TECHNICAL INFORMATION
- ORDERING INFORMATION
- TERMS AND CONDITIONS
- CALL NOW TO ORDER
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?
- 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
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?
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.
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
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
- 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
- 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.
- Storage Management
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.
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.
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
- 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)
- OS PL/I Compiler, Library, and Interactive Test Facility Version 2 Release 3 (5668-909)
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.
Orders for new licenses are accepted now.
Shipment will begin on Jul7 10, 1998.
New users of DB2 Row Archive Manager should specify:
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
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
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)
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)
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.
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
Licensed Program Materials Availability
- Restricted Materials of IBM: None
- Non-Restricted Source Materials: None
- Object Code Only (OCO): All
- Support Center applies: Yes. Access is available through the IBM
- Available until discontinued: 12-months' written notice
- APAR Mailing Address:
555 Bailey Ave
San Jose, CA 95141
- Services for DSLO Licenses: Provided through basic license location
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.
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: firstname.lastname@example.org 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.
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.