ADASTRIP - ADABAS File Data Extraction Utility
ADASTRIP enables efficient off-line operation after selectively extracting data by reading either the database direct or the ADASAV backup file. PE/MU normalisation option.
ADASTRIP offers an efficient alternative to DBAs performing unloads outside normal working hours, saving your company costly overtime expenses.
It is essential that ADABAS DBAs have exclusive control over the files they wish to unload. Ordinarily this risks a loss of productivity because applications which access those files must be unavailable to users; the usual solution is for DBAs to perform unloads outside of normal working hours.
With ADASTRIP, DBAs can perform unloads from ADABAS at any time, without inconvenience to on-line users. ADASTRIP extracts data from an ADABAS backup dataset or an on-line ADABAS database. Comprehensive user-defined selection criteria allow users to create output files that contain almost any desired subset of ADABAS records.
Output reports provide full statistical details on all the ADASTRIP extracts, as well as reports on the file definition tables (FDTs) being used. You can access historical data quickly and easily, export defined sets of data to other databases and transmit to remote sites, as well as select large amounts of data for inexpensive, overnight batch processing.
- Efficiency. Extracting desired ADABAS data, rather than unloading the database, saves computer resources.
- Improved Productivity. Batch processes can be converted to work on ADASTRIP extract files instead of ‘live’ production files, avoiding conflict with on-line users.
- Deferred Processing. ADASTRIP extracts data from the backup, so processing can be deferred for as long as the backup is kept.
- Fast data extraction. Multi-tasking allows multiple backup tapes to be read in parallel.
- Ability to build multiple sequential output files.
- User-exit facility which provides additional flexibility in record selection and processing.
- Normalize option. Repeating groups such as PEs and MUs can be ‘flattened out’. This is useful when migrating data to an RDBMS.
- Support of ADASAV backups, as well as QDUMP incremental backups. (QDUMP, available from BLENHEIM SOFTWARE INTERNATIONAL LTD, is an incremental backup utility for ADABAS.)
ADASTRIP operates under MVS, MVS/XA, and MVS/ESA.