Comparing Adabas Databases

This document covers the following topics:

Prerequisites

Adabas Online Services must be available if a database of Adabas Version 6 or above is to be compared.

If Natural Security function protection for Predict is activated, permission is required to compare Adabas databases.

See also General Prerequisites for Comparison Functions.

Calling the Function

The Compare DD Objects with Adabas DBs screen is called with code C and object code AD in any Predict main menu or with the command COMPARE ADABAS-DATABASE. 

10:53:02             *****  P R E D I C T  *****              2007-05-31
Plan   0           - Compare DD Objects with Adabas DBs -           Profile HNO

Current VM ............... HOME

Database ID ..............
Database number ..........
Belongs to VM ............



List options                         Update options
  DB attributes ....* D                DB attributes .... N (Y/N)
  File list ........* D                File list
                                         Unlink files ... N (Y/N)



Restrictions .......*   Profile HNO ,used

Parameters

Parameters
Current VM ID of the virtual machine object identifying the current environment. A read-only field. This value can be changed in the Maintenance options of the Modify User Defaults function or with the command SET VM<virtual machine ID>. If no current VM is specified in the session profile, the Default current virtual machine parameter in the Miscellaneous section of the General Defaults is used.
Database ID ID of the Predict database object to be compared. Asterisk notation can be used.
Database number The number of the Adabas database to be compared.
Belongs to VM Limits the function to databases linked to this virtual machine via association "Contains DA". Asterisk notation can be used.
List Options
DB attributes
How attributes of the Predict database object are to be displayed.
Y All attributes
N No attributes
D Different: only database attributes whose values differ.
File list
How files contained in the file list of the Predict database object are to be displayed:
Y All files
N No files
D Different: only files that are either not implemented in the Adabas database or are not linked to a Predict documentation object.
Update options
DB attributes
Y The attributes of the Predict database object are to be updated.
File list: Unlink files
Y Files that are not implemented in the Adabas database are to be removed from the file list of the Predict database object.

Comparing Adabas Databases in Batch Mode

Command: COMPARE ADABAS-DATABASE

Enter parameters on next line in the positional or keyword form.

Field Keyword Position
Database ID DATABASE-ID 1
Database number DBNR 2
Belongs to VM PARENT 3
List options
DB attributes LIST-DB 4
File list LIST-FILE 5
Update options
DB attributes UPD-DB 6
Unlink files UNLINK-FILE 7

Example

To compare all databases of type A with prefix "TEST" and to display the file lists code the command: 

COMPARE ADABAS-DATABASE
DATABASE-ID=TEST*,LIST-FILE=Y

or

COMPARE ADABAS-DATABASE
TEST*,,,,,Y

The above example uses the Natural parameter ID=, and IA==.