mike conena, database administrator commonwealth of ... data archiving at... · adabas file...

Mike Conena, Database Administrator

Commonwealth of Massachusetts

Adabas Archiving

Get There Faster.29 June 2010 | ProcessWorld 2010 | 2

Data Archiving for Adabas

• What is it?� A tool to archive Data from Adabas Files

• What are the benefits?� Minimizes only necessary data on primary databases

� Smaller Files

� Less Disk Space

� Faster Job Execution (both Batch and Adabas Utility)

� Faster Online System

� Savings in Data Center Chargeback Costs



•Example:

•MA21 Adabas File SVES-REQUEST

•Records Loaded = 220,159,118 as of 6/2/10

•Occupies 67,929 DATA cylinders and 24,603 ASSO cylinders

•Total: 92,532 cyl. (over 28 volumes)



• Example Continued…..

• DASD chargeback from ITD is .0761 per 1000 tracks/day

• There are 50,085 tracks per volume

• $3.81 per volume per day

• Times 28 volumes equals $106.68/day

• $38,938.20 a year

• MA21 has about 20 big files in PROD that could be archive candidates



•Features:� Data can be recalled at any time

� Archiving Vaults can be Flat-file or Adabas Files

� Archived Data can be searched

� Archived Options: Copy or Delete

� Expiration dates for Archived Data to be Discarded



•Features Continued….� Define Plans to Archive data

�Add Actions such as Extraction and Filtering Criteria

�Set Transfer settings for scheduling action

�Set Accumulator settings for retention of data

�Monitor Archiving Services and Activities

�View Archiving History



•How does it work?

•Easy User Interface using the SMH

�Configure Environment

�Setup and Run Extracts manually

�Schedule Extracts to run automatically

�Recall Archived Data

�Search Archived Data (returned to UI)

�Retain Search results to reuse later


Data Archiving for AdabasComponents



• Browser User Interface � All Archive operations and Monitoring is performed here

• Configuration � Adabas File configured at install time that contains configuration information and Plans

• Archive Services� Manage the archive operations

• Extractor� Extracts data that you want archived

• Accumulators� Receives the Archived data and places it into the Vault or Archived File

• Vaults� Flat-file stores to place Archived Data

• Adabas Archived Files� Files used to store Archived Data


User Interface

2 Frames: Navigation on left, Content on right




Adding an Action


Extraction Criteria



Adabas Archiving for Adabas

Accumulator Settings



• Installation Prerequisites� Supported Operating Systems (Windows, Solaris, z/OS)

� Adabas v6.1.7 or above on Open Systems

� Adabas v8.1 or above on mainframe z/OS

� Adabas System Coordinator v8.2 or higher required

� System Management Hub v8.1 or higher required



• z/OS Installation� Create site-based Adabas Link Routine (ADALNKR)

� Activate OMVS in TSO

� Establish Access to the Browser User Interface

�Prepare (COR and ADR) Directories

�Run the COR install script

�Run the ADR install script

�Load Assembler code into COR directory

�Edit the SAG.NEW Environment script

�Establish Configuration File (Adabas File)

�Start COR Launch Control (starts SAGAUTO daemon)

� Install UI on Workstation


• Starting the Services� Via Unix commands or by batch jobs



• Log files created each day



Definition of Vaults and/or Archiving Files



Defining Archiving Plans


Thank You!

mike conena, database administrator commonwealth of ... data archiving at... · adabas file...

Documents