Scenario: Archive data

Sharon Jones, the system administrator at the JKL Toy Company, wants to archive older data currently stored on one of the systems to media. You can use this example to plan and configure archive policies using BRMS.

Situation

The JKL Toy Company stores large monthly sales invoices in an Accounts database on their JKLPROD system. Unfortunately these records have been kept on the system for several years and the large volume of data is negatively impacting the performance of the application. JKL wants to archive any records that are older than two years old. For this older data, the company wants to save it off the system to media, but ensure that it can be accessed, if necessary. Although this data is not current, employees occasionally need to access payment histories and other account information for these accounts. Users will typically be responding to a customer inquiries into this data, such as validating payment or addresses. Accounts that are younger than two years are considered active. Data in these accounts are updated regularly and are saved as part of the backup policy for JKLPROD system.

For data that is older than two years, they would like to save it to media but retain it in case it is needed. Using the BRMS archive function, Sharon plans to save these monthly sales records to write once, read many (WORM) media and set criteria on what objects will be saved. She plans to create an archive policy for this data.

Objectives

JKL Toy Company has the following objectives for this scenario:
  1. To improve application performance by removing older data from the system.
  2. To allow the access to data that has been archived.

Prerequisites and assumptions

This scenario assumes that several prerequisite steps have been completed and tested prior to beginning any steps. These prerequisites are assumed to have been completed for this scenario:

Ensure that the following requirements have been installed on your server:
  • i5/OS Version 5 Release 4 (5722-SS1)
  • Media and Storage Extensions (5722-SS1 Option 18)
  • Backup, Recovery and Media Services (5722-BR1 *BASE)
  • BRMS -- Network feature (5722-BR1 Option 1)
  • BRMS -- Advanced feature (5722-BR1 Option 2)
  • IBM® iSeries™ Access for Windows® (5722-XE1) and iSeries Navigator
  • Ensure that you have the latest PTFs installed on your system.
Ensure that the requirements have been installed on the client:
  • IBM iSeries Access for Windows and iSeries Navigator
  • BRMS iSeries Navigator plug-in
Ensure that these planning tasks have been completed:
  • All backup and recovery planning has been conducted and documented.
  • All storage planning has been conducted and documented.

Configuration details

  1. Start of changePrepare mediaEnd of change
  2. Start of changeAdd mediaEnd of change
  3. Start of changeCreate archive policy for older dataEnd of change
  4. Start of changeView archive policy reportEnd of change
  5. Start of changeSchedule archive policyEnd of change
Parent topic: Scenarios: How one company uses BRMS