ADAREORG is a software utility designed to simplify and accelerate the reorganization of Adabas database files. It enables database administrators to change the physical structure of Adabas files—including inserting, deleting, or reordering fields—without the need for decompressed intermediate datasets. ADAREORG supports operations on both compressed and decompressed files, and can join two files, convert data formats, and manipulate data at the sub-field level. The tool is compatible with z/OS, UNIX, and Windows systems and is typically used to implement design changes, prepare test data, or respond to evolving application requirements with minimal effort and risk.

Key Features

File Structure Modification Allows for insertion, deletion, and reordering of fields, even within periodic groups (PE).

• Insert or delete fields anywhere in a file.
• Reorder fields to optimize access and decompression.

Data Conversion and Manipulation Supports data format conversions and sub-field level manipulation.

• Convert field types, lengths, and attributes.
• Move fields into or out of periodic or multi-valued groups.

Efficient Processing Performs decompression, reorganization, and compression in a single job step.

• No need for intermediate decompressed datasets.
• Reduces disk space usage during reorganization.

File Joining and Subset Creation Can join two files or create subsets based on field comparisons.

• Join compressed or decompressed files.
• Select records using Boolean field value combinations.

Interactive and Scripted Operation Can be run interactively or via scripts for batch processing.

• Supports standard ADABAS utility input formats.
• Output can be redirected to files for further processing.

Benefits

Reduced Administrative Effort Simplifies and accelerates database restructuring tasks.

• Minimizes manual intervention and risk.
• Enables quick adaptation to changing application requirements.

Optimized Resource Usage Decreases disk space and processing time.

• Eliminates need for decompressed intermediate files.
• Improves performance by optimizing record layouts.

Data Integrity and Flexibility Maintains data integrity during structural changes.

• Automatically converts existing data to new formats.
• Supports test data preparation and migration scenarios.