This section of the documentation describes the functionality of Adabas Manager and introduces the new functionality for administering open systems databases in addition to Adabas mainframe databases.
The following topics are covered:
Adabas Manager replaces the Basic Services component of the Adabas Online System and includes functions comparable to the Adabas operator commands and utilities.
Version 7.7 of Adabas Manager also provides the full functionality of the DBA Workbench tool and supports the administration and monitoring of Adabas databases on mainframes as well as on open systems platforms.
Adabas Manager 7.7 also supports Adabas Caching Facility and Adabas Delta Save Facility.
Adabas Manager allows the DBA to interactively monitor and change aspects of an Adabas database while an Adabas session is active. Its web-based graphical user interface (GUI) allows the DBA to easily view resource status and user queues; display and revise space allocation; change file and database parameters; define a new file online; and stop a selected user or current Adabas session.
DBA tasks directly affecting the database (designing, selecting tuning aids, predicting changes, deciding and enforcing database rules, organizing and administering file conversions, measuring database use, and tuning for best database performance) can all be done using Adabas Manager.
For analyzing performance and monitoring database operation, Adabas Manager allows you to see the system from the viewpoint of either a user or a particular system resource. For example, you can perform the following user-related tasks:
monitor the operation of a particular user or all users
check user and command queue status
change user priority
stop a user from using a particular file, or stop all inactive users
Some of the resource-related tasks you can perform are
view and update nucleus parameters
monitor command and file usage and system performance information
list file layout and extent status; and
list file distribution of the database by VOLSER
For controlling the overall Adabas session, Adabas Manager provides you with ways to
change file parameters
define new files and rename, renumber, refresh, uncouple, or delete files
create new FDTs, fields, and change field lengths
switch ISN and Data Storage reuse on and off by file, and release descriptors
terminate an Adabas nucleus session (ADAEND, HALT, CANCEL)
enable better use of the available operating system facilities through the Adabas Caching Facility, in that valuable virtual memory resources are not monopolized.
enhance ADASAV utility processing by backing up and restoring only the changed (delta) portions of Adabas databases through the Adabas Delta Save Facility.
The Adabas Manager Enterprise Edition supports a range of functionality which is not available in the Standard Edition for mainframe databases; the functionality for open systems databases is not restricted in this way (this may change in future versions of Adabas Manager).
For mainframe databases, the following functionality is supported by the Adabas Manager Enterprise Edition only:
Caching Facility:
enables better use of the available
operating system facilities, in that valuable virtual memory resources are not
monopolized.
Delta Save Facility:
enhances ADASAV utility processing by
backing up and restoring only the changed (delta) portions of
Adabas databases.
Checkpoints:
allows the administrator to review the
checkpoint list for an Adabas database and to delete
checkpoints.
Disk Storage:
allows the administrator to modify or add
Associator and Data Storage datasets and to recover unused storage.
Space Calculation:
is a planning tool for adding new
components or recalculating existing space requirements.
System Status (extended):
provides a comprehensive overview
of Adabas operation:
CLOG/PLOG Statistics
Command Queue
Command Usage
File Usage
High Water Marks
Nucleus File Status
Online Status
PPT (Parallel Participant Table)
Resource Statistics
User Profiles
User Queue
Work Status
Work Pool Usage
Adabas Manager version 7.7 is able to administer and monitor Adabas databases on open systems platforms. It replaces the DBA Workbench tool; Adabas Manager offers the same functionality previously available though the workbench and has been designed to handle different versions of Adabas in parallel. Adabas 6.1.11 for Open Systems is the minimum version supported.
Important:
Although it is possible to run Adabas
Manager and the DBA Workbench in
parallel, Software AG does not recommend this under any circumstances. In cases
where a parallel use cannot be avoided, the DBA
Workbench must never be active while Adabas
Manager is running.
The following tables explain the DBA Workbench functions which can now be executed with Adabas Manager and refers to the information in this documentation.
Note:
Where a target can be reached by right-clicking on a node, the
character ¦ is displayed; for example, "DBnnn ¦
Nucleus Log" asks you to right-click on the database name and choose
from the dropdown menu.
DBA Workbench | Adabas Manager | Documentation |
---|---|---|
General Information | ||
Contents | DBnnn > Database Files > File Name | Reviewing File Properties in Database Files |
Summary | DBnnn and DBnnn > Disk Storage > Containers |
Listing
Databases in Adabas Databases and Disk Storage in Session Monitoring |
Layout | DBnnn > Utilities > Show Layout | Show Layout in Database-related Long Running Utilities for Open Systems |
Free Space | DBnnn > Utilities > Unused Storage | Unused Storage in Database-related Long Running Utilities for Open Systems |
Nucleus Log | DBnnn ¦ Nucleus Log | Nucleus Log in Listing Databases |
File Information | ||
Status | DBnnn > Database
Files > File Name and DBnnn > Disk Storage |
Reviewing File
Properties in Database Files and Disk Storage in Session Monitoring |
Descriptor | DBnnn > Utilities > Display Descriptors | |
Usage | DBnnn > Utilities > File Usage | File Usage in Database-related Long Running Utilities for Open Systems |
Session | ||
Command Queue | DBnnn > System Status > Command Queue | Reviewing Command Queue in System Status |
Full User Queue | DBnnn > System Status > User Queue | User Queue and User Queue Elements (UQEs) for Databases in System Status |
Hold Queue | DBnnn > System Status > Hold Queue | Reviewing Hold Queue in System Status |
Internal Command Queue | DBnnn > System Status > Command Queue ¦ Internal CMDQ | Reviewing Command Queue in System Status |
Thread Table | DBnnn > System Status > Threads | Reviewing Thread Status in System Status |
User Files | DBnnn > System Status > User Queue | User Queue and User Queue Elements (UQEs) for Databases in System Status |
User Queue | DBnnn > System Status > User Queue | User Queue and User Queue Elements (UQEs) for Databases in System Status |
User Time Limits | DBnnn > System Status > User Queue | User Queue and User Queue Elements (UQEs) for Databases in System Status |
Utility Communication Block | DBnnn ¦ Utility Communication Block | Reviewing Adabas Open Systems Database UCBs in System Status |
Session Parameters | ||
Dynamic | DBnnn > Active Parameters | Active Parameters in Session Monitoring |
Static | DBnnn > Active Parameters | Active Parameters in Session Monitoring |
Statistics | ||
High Water Marks | DBnnn > System Status > High Water Marks | Reviewing High Water Marks in System Status |
Command | DBnnn > System Status > Command Usage | Reviewing Command Usage in System Status |
Activities | DBnnn > System Status | System Status in Session Monitoring |
File IO | DBnnn > System Status > File Usage | Reviewing File Usage in System Status |
Set List of Files | DBnnn > System Status > File Usage > Define Files | Reviewing File Usage in System Status |
Buffer Pool | DBnnn > System Status | System Status in Session Monitoring |
Format Pool | DBnnn > System Status | System Status in Session Monitoring |
Protection Log | DBnnn > System Status > CLOG/PLOG Statistics | CLOG/PLOG Statistics in System Status |
Checkpoints | DBnnn > Checkpoints | Checkpoints |
Command Log | DBnnn > System Status > CLOG/PLOG Statistics | CLOG/PLOG Statistics in System Status |
Error Log | DBnnn > Utilities > Error Log | Error Log in Database-related Long Running Utilities for Open Systems |
List Protection Log | DBnnn > Utilities > List Protection Log | List Protection Log in Database-related Long Running Utilities for Open Systems |
DBA Workbench | Adabas Manager | Documentation |
---|---|---|
Containers | DBnnn > Disk Storage | Disk Storage in Session Monitoring |
Nucleus Parameters | DBnnn > Active Parameters | Active Parameters in Session Monitoring |
Start as Service | DBnnn ¦ Enable Start as Service | Starting and Stopping Databases in Adabas Databases |
Environment Extensions | DBnnn > Active Parameters ¦ Environment Extensions | Environment Extensions in Active Parameters |
Operations | ||
Node Parameters | DBnnn > Active Parameters ¦ Node Parameters | Node Parameters in Active Parameters |
Database Actions | DBnnn > Active Parameters ¦ Database Actions | Database Actions in Active Parameters |
Action Users | DBnnn > Active Parameters ¦ Action Users | Action Users in Active Parameters |
Add Existing Database | Adabas Databases ¦ Add Existing DB | Add Existing Open Systems Databases in Listing Databases |
DBA Workbench | Adabas Manager | Documentation |
---|---|---|
New | DBnnn > Database Files ¦ New File | Creating New Files in Database Files |
Delete | DBnnn > Database Files > | Deleting Files in Modifying Files |
Refresh | DBnnn > Database Files > | |
Add LoB File | DBnnn > Database Files ¦ New LOB File | Creating New LOB Files in Database Files |
Backup | DBnnn > Database Files > Utilities > Backup (dropdown list) | Backup in File-related Long Running Utilities for Open Systems |
Restore | DBnnn > Database Files > Utilities > Restore (dropdown list) | Restore in File-related Long Running Utilities for Open Systems |
Load | DBnnn > Database Files > Utilities > Load (dropdown list) | Load in File-related Long Running Utilities for Open Systems |
Unload | DBnnn > Database Files > Utilities > Unload (dropdown list) | Unload in File-related Long Running Utilities for Open Systems |
Compress | DBnnn > Database Files > Utilities > Compress (dropdown list) | Compress in File-related Long Running Utilities for Open Systems |
Decompress | DBnnn > Database Files > Utilities > Decompress (dropdown list) | Decompress in File-related Long Running Utilities for Open Systems |
Export | DBnnn > Database Files > Utilities > Export (dropdown list) | Export in File-related Long Running Utilities for Open Systems |
Import | DBnnn > Database Files > Utilities > Import (dropdown list) | Import in File-related Long Running Utilities for Open Systems |
Verify | DBnnn > Database Files > Utilities > Verify (dropdown list) | Verify in File-related Long Running Utilities for Open Systems |
DBA Workbench | Adabas Manager | Documentation |
---|---|---|
Allocate | DBnnn > Database Files > Alloc. > | Allocating/Deallocating File Space in Database Files |
Deallocate | DBnnn > Database Files > Alloc. > | Allocating/Deallocating File Space in Database Files |
Reusage | ||
Data Storage | DBnnn > Database Files > File Name > | Modifying Files in Database Files |
ISNs | DBnnn > Database Files > File Name > | Modifying Files in Database Files |
Lock | DBnnn > Database Files > | Locking/Unlocking Files in Modifying Files |
Unlock | DBnnn > Database Files > | Locking/Unlocking Files in Modifying Files |
Enable PGM_REFRESH | DBnnn > Database Files ¦ New File > Enable PGM_REFRESH | Creating New Files in Database Files |
Disable PGM_REFRESH | DBnnn > Database Files > File Name > | Modifying Files in Database Files |
Modify FDT | DBnnn > Database Files > Fields > | Adding New Fields in the Field Definition Table (FDT) in Field Definition Table (FDT) |
Rename | DBnnn > Database Files > | Renaming Files in Modifying Files |
Renumber | DBnnn > Database Files > | Renumbering Files in Modifying Files |
DBA Workbench | Adabas Manager | Documentation |
---|---|---|
Invert | DBnnn > Database Files > Utilities > Invert Descriptor (dropdown list) | Invert Descriptor in File-related Long Running Utilities for Open Systems |
Reinvert | DBnnn > Database Files > Utilities > Reinvert Descriptor (dropdown list) | Reinvert Descriptor in File-related Long Running Utilities for Open Systems |
Release | DBnnn > Database Files > Fields > Name | Setting and Releasing Descriptors in Field Definition Table (FDT) |
Unique | ||
Set | DBnnn > Database Files > Fields > Name | Setting and Releasing Descriptors in Field Definition Table (FDT) |
Reset | DBnnn > Database Files > Fields > Name | Setting and Releasing Descriptors in Field Definition Table (FDT) |
Verify | DBnnn > Database Files > Utilities > Verify Descriptor (dropdown list) | Verify Descriptor in File-related Long Running Utilities for Open Systems |
Summary | DBnnn > Database Files > Utilities > Descriptor Summary (dropdown list) | Descriptor Summary in File-related Long Running Utilities for Open Systems |
DBA Workbench | Adabas Manager | Documentation |
---|---|---|
Display FDT | DBnnn > Database Files > Fields | Field Definition Table (FDT) in Database Files |
File Information | ||
Descriptor | DBnnn > Database Files > Utilities > Display Descriptors (dropdown list) | Display Descriptors in File-related Long Running Utilities for Open Systems |
Usage | DBnnn > System Status > File Usage | Reviewing File Usage in System Status |