ADAMAGIC

The ADABAS/NATURAL product offerings from Treehouse Software, Inc. (TSI), include ADAMAGIC, a data extraction utility for ADABAS.

Not surprisingly, converting ADABAS files to a UNIX or Linux format is not a popular task with DBAs. Too many steps. Too much time. Too much overhead.

ADAMAGIC turns this time-consuming, costly process into a simple and efficient one.

Fast, Convenient Processing

ADAMAGIC can be used to convert all application data files from an EBCDIC ADABAS database to equivalent files on a UNIX ASCII database. It does this by using an OS/390, Z/OS, or VSE ADABAS ADASAV to load ADABAS C databases on UNIX.

ADAMAGIC also reads UNIX ADABCK backup tapes to create subsets of data for testing or reporting.

Therefore, ADAMAGIC is useful to DBAs who need to convert from mainframe to UNIX, easily access historical data from ADABAS backups, or populate test databases.

How Does it Work?

ADAMAGIC reads ADASAV (mainframe) or ADABCK (UNIX) backup tape(s) to extract data for one or more selected files. ADAMAGIC uses this data to create compressed files in the same format as the compressed data (DTA) and Descriptor Value Table (DVT) files written by UNIX ADACMP or as flat ASCII files in a variety of formats, including CSV format.

Corresponding to each pair of DTA and DVT files, an ASCII text file is written containing input parameters suitable for the UNIX file definition utility ADAFDU.

ADAMAGIC can be optionally run to extract the ADAFDU information without extracting the actual data, or to extract ADAFDU information and DTA but not DVT.

Files output from ADAMAGIC can be loaded into ADABAS on UNIX, can be decompressed and used as input for an application program, or can be input to ADAREORG, a file restructuring utility also available from Treehouse Software.

Automated Control

To automate control of ADAMAGIC, a UNIX script can be invoked at the end of each output file (e.g., to execute ADAFDU to create a new file or ADAMUP to load the data into ADABAS).

System Requirements

ADAMAGIC operates under HP/UX, IBM/AIX, Sun Solaris, Linux, or Windows.

ADAMAGIC Literature and Presentations:

ADAMAGIC Fact Sheet ADAMAGIC Release Notes	ADAMAGIC Manual