With extensive experience in the large system environment, Bateleur Software understands the six steps required:
- Unload the file
- Decompress the file
- Program the selection criteria
- Apply the program to split out the selected data to one output file and the non-required data to another
- Recompress the selected output file and load it back into the database
- And finally recompress the unwanted data and send it to the archive
We also understand that you seldom have the time or the space to do all this, so we developed ADASPLIT,
an archive tool which splits output files by selected criteria. A South African Government Department has used ADASPLIT to archive data in less than
30 hours which was estimated would have taken 511 days and cost millions of Rands.
How does it work?
ADASPLIT separates records from an unloaded ADABAS file in ADAULD or ADACMP compressed format.
This is done in two files according to user-specified criteria, and without decompressing the files.
The output file matching the selection criteria is then reloaded into the database and the unwanted records are archived in either compressed or decompressed format.
Files can include PE's or MUs.
Benefits
With ADASPLIT, DBAs have more time for strategic issues. Since ADASPLIT doesn't need decompressed files at any time during the process, ADASPLIT also saves on disk space usage. Also, there are noticeable savings in CPU usage, with a 50% run-time reduction. For example, if a standard ADAULD application processes 1 million records in three minutes,
ADASPLIT will process the same number of records in one minute.
for more information on this product.
