This document gives an overview of the Adabas utilities, which provide all of the functions necessary to manage an Adabas database.
Start the database nucleus (for Windows only)
This utility starts the database nucleus with the required environment.
Backup and restore database or files
The Adabas backup utility dumps/restores the contents of the database (or a specific file or files) to/from a sequential data file. The utility can also be used to copy an Adabas backup copy.
Command log report
This utility prints the command log.
Compression of data
The compression utility compresses user data. The compressed data is used as input for the mass update utility ADAMUP. The input for this utility is the raw data together with the data definitions that describe the structure of the data provided.
DBA Workbench
This utility provides functionality for operating and maintaining Adabas databases and files via a graphical user interface.
Database modification
The ADADBM utility consists of the following functions which can be used to make modifications to the database:
The ADD_CONTAINER function adds a new container file to the Associator or Data Storage data set;
The ADD_FIELDS function appends one or more new fields to the end of a file's FDT;
The ALLOCATE functions increase the Normal Index, Upper Index, Address Converter or Data Storage space assigned to a file. The DEALLOCATE functions are the inverse;
The CHANGE function changes the standard length of a field in the FDT;
The CHANGE_FIELDS function changes a field definition;
The DEFINE_REFINT function defines a new referential constraint;
The DELCP function deletes old checkpoint records from the checkpoint file in the specified range of dates;
The DELETE function deletes an Adabas file or a range of files from the database;
The DISPLAY function displays the UCB;
The DROP_FIELDS function marks the specified fields as not existing, which means that they can no longer be accessed;
The DROP_LOBFILE function is the inverse function of ADAFDU ADD_LOBFILE;
The DROP_REFINT function drops an existing referential constraint;
The EXTEND_CONTAINER function extends the last container file defined for the database;
The NEW_DBID function changes the identifier of the database in use;
The NEWWORK function allocates and formats a new Adabas WORK data set;
The PGM_REFRESH function is used to disable or enable refreshing an Adabas file inside an application program with an E1 command;
The RECOVER function returns lost space to the FST;
The REDUCE_CONTAINER function reduces the size of the last container file defined for the database;
The REFRESH function resets a file or a range of files to the state of zero records loaded;
The REMOVE_CONTAINER function deletes a container file;
The REMOVE_DROP function, used in conjunction with a subsequent REFRESH, removes dropped fields from the FDT;
The REMOVE_REPLICATION function stops all replication processing and deletes the replication system files;
The RENAME function changes the database name or the name of a loaded file;
The RENUMBER function renumbers a loaded file or exchanges the numbers of loaded files;
The REPLICATION_FILES function creates the systems files required for Adabas - Adabas replication;
The RESET function removes entries from the UCB;
The RESET_REPLICATION_TARGET function resets the replication target flag of Adabas files;
The REUSE function controls the reuse of data storage space or ISNs by Adabas;
The SYFMAX function specifies the maximum number of values generated for a system generated multiple-value field in the file specified.
Decompression of data
The ADADCU utility decompresses records to be used with a non-Adabas application program, or as input for the compression utility ADACMP. The file to be decompressed must be unloaded from the database (unload utility ADAULD) before it can be used as input for this utility. With ADADCU, complete records can be decompressed, fields can be rearranged within a record, default lengths can be changed, some types of fields can be truncated, formats can be changed and space can be allocated for the addition of new fields.
Disk space management (UNIX only)
This utility consists of several functions for managing the disk space to be used by Adabas. It can be used to preallocate space for a database.
Error file report
The ADAERR utility displays the contents of the error files generated by various utilities.
File definition
The file definition utility ADAFDU defines a file in the database. It only loads the FCB and the FDT into the database and allocates the requested space for ASSO and DATA for the specified file.
File information report
The ADAFIN utility displays information about one or more files, e.g. FDT, descriptor statistics and the fill percentage of blocks in the Data Storage, Normal Index and Upper/Main Index.
Format and create a new database
The formatting utility ADAFRM allocates and formats the files that are used by Adabas (Associator, Data Storage, WORK, TEMP and SORT). It can also format files which have been preallocated by ADADEV.
Creating, removing and verifying inverted lists
The invert utility ADAINV creates, reinverts or removes inverted lists for a loaded file in a database or validates specified descriptors.
This utility monitors the performance of an Adabas nucleus and displays statistics on a terminal.
Mass add and delete
The ADAMUP utility adds or deletes large numbers of records to/from a file in the database.
Starting the database, defining nucleus parameters
The ADANUC utility starts the database for online operations and defines the runtime environment.
Operator utility
The operator utility is used to operate the Adabas nucleus.
Reorder database or files, export/import files
The reorder utility ADAORD provides functions to reorganize a database or files within a database (REORDER function) and to migrate files between databases (EXPORT and IMPORT functions).
Protection log printout
This utility prints the protection log.
Print Adabas blocks
The ADAPRI utility prints the contents of a block or a range of blocks in the Associator, Data Storage, WORK, TEMP or SORT for maintenance or auditing purposes.
Recovery of database or files
This utility reapplies updates made to the database (REGENERATE function).
Database report
The ADAREP utility produces the database status report. This report contains information about the current physical layout and logical contents of the database.
The information in this report includes the following: the amount and location of the space currently allocated for the Associator and Data Storage; the amount and location of unused space available for Associator and Data Storage; database file summary; checkpoint information; information about each file in the database (space allocation, space available, number of records loaded, MAXISN setting, field definitions).
Security functions
The security utility ADASCR creates, modifies and deletes file protection levels and user passwords, and enables the record locking capabilities of individual passwords (by using value criteria for individual database files) to be set or modified. Additionally, the utility is used to display file and password security information.
Issuing Adabas commands
This utility issues commands to an Adabas nucleus.
File unloading
The unload utility ADAULD unloads a file from a database or an Adabas backup copy and produces compressed records with the same format as those produced by the compression utility ADACMP. Unloaded records may be used as input for the decompression utility ADADCU or with the mass update utility ADAMUP. Records can be unloaded from a database in the sequence in which they are currently stored in Data Storage, in the sequence of a descriptor or in ISN sequence. However, records can only be unloaded from a backup copy in the order in which they were stored by the utility.
Database consistency check
This utility checks the consistency of the database. The General Control Block (GCB) is validated together with each File Control Block (FCB) and each Field Definition Table (FDT) of the loaded files. The index structure and Data Storage are validated. If specified, ADAVFY also looks for lost RABNs.
