When you select to manage, you are first presented with a list of databases to choose from.
Database entries listed in the tree-view are preceded by a stoplight icon:
Green indicates that the database is active.
Yellow indicates that this mainframe database is protected or not supported.
Red indicates that the database is inactive.
When Adabas Databases is highlighted in tree-view and you have not grouped your databases, a table is displayed in the detail window providing in addition to the stoplight icon, the database ID, database name, and Adabas version of each database registered to Adabas Manager, and for which mainframe databases a login with password is required.
If you have grouped your databases, click Mainframe or Open Systems to display the databases information.
Note:
Protected mainframe databases can be accessed from both these tables;
mark the checkbox for the database, enter your user ID and password in the
resulting Security Login window, and click
, or to return to the
overview of databases display.
If a database is currently not reachable due to network problems, it will also be preceded by a red stoplight icon; the information "Target not responding" is displayed.
The information is organized under the following headings:
To select an Adabas mainframe database to
work with:
Select and expand Adabas Databases in tree-view.
Select the database entry in tree-view under Adabas Databases If the mainframe database you want to access is preceded by a yellow stoplight sign, i.e., is protected, a Security Login window is displayed in detail view; enter your user ID and password and click , or to see the overview of databases display.
Note:
If you have logged in to a protected mainframe database, the
drop-down menu will offer you an additional menu item; will display the authorizations you have with this
particular database.
Once a database is selected, the following property default information about that database appears in detail-view:
| Property | Description |
|---|---|
| Database ID | The number of the database. |
| Database Name | The name of the database. |
| Database Load Date | The date and time the database was loaded. |
| Maximum Number of Files | The maximum number of files permitted for the database. |
| Number of Files Loaded | The total number of files currently loaded in the database. |
| Lowest File Loaded | The lowest file number currently in use in the database. |
| Highest File Loaded | The highest file number currently in use in the database. |
| System File(s) | The number of Adabas system files allocated to the database. |
| Universal Encoding Support (UES) | Indicates whether Universal Encoding Support (UES) is active or inactive for the database. |
| Current Log Tape Number | The number of the most recent data protection log tape for the database. |
| RABN Size (RABNSIZE) | Indicates whether 3- or 4-byte RABNs are being used for the database. |
| Database Version | The version of the database. |
You can change the columns shown in the Database Overview display. Specifically, you can indicate whether the following information appears in the database overview display table:
| Asso used | percentage of the Associator area used by the file |
| Data used | percentage of the Data storage area used by the file |
| Work used | percentage of the Work storage area used by the file |
| ASSO | Associator |
| DATA | Data storage |
| WORK | Work dataset |
| PLOG Statistics | Protection Log statistics |
| Logical Reads | Number of logical reads |
| Buffer Efficiency | Percentage of buffer efficiency |
| Format Translations | Number of format translations |
| Format Overwrites | Number of format overwrites |
| Throwbacks | Number of throwbacks |
| Thread Switches | Number of thread switches |
| Number of Calls | Number of calls |
| Internal Autorestarts | Number of internal autorestarts |
| PLOG Switches | Number of PLOG switches |
| Buffer Flushes | Number of buffer flushes |
| Attached Buffer | Percentage of attached buffer space used |
| Command Queue | Percentage of the command queue used |
| Format Pool | Percentage of the format pool space used |
| Hold Queue | Percentage of the hold queue space used |
| ISN-List Table | Percentage of the ISN list table queue space used |
| Seq. Cmd Table | Percentage of the seq. command queue space used |
| User Queue | Percentage of the user queue space used |
| Unique Descriptor Pool | Percentage of the unique descriptor pool queue space used |
| Security Pool | Percentage of the security pool space used |
| User File List Pool | Percentage of the user file list pool space used |
| DTP Transaction ID Pool | Percentage of the DTP transaction ID pool space used |
| Work Pool | Percentage of the work pool space used |
| Redo Pool | Percentage of the redo pool space used |
To change the columns in the database overview display:
In the upper left corner of the database overview display, click
(
).
The Database Overview panel appears.
On the panel, select columns for the database overview display by moving them into and out of the Selected Columns list. To move a column into the Selected Columns list, select the column name in the Available Columns list and click the right arrow button. To move a column out of the Selected Columns list, select the column name in the Selected Columns list and then click the left arrow button.
Once you have selected the columns for the database overview display, select the order in which they should appear in the database overview display table. Use and to move the column headings up and down in the Selected Columns list.
A number of separators is available, allowing you to partition the tables as you wish.
When the columns you want are listed in the order you want in the Selected Columns list, click to save the column setting definition and return to the main database overview display, which will show the column settings you selected.
Or:
Click to cancel the column setting
definition.
To restore the default database overview display:
In the upper left corner of the database overview display, click
().
The Database Overview panel appears.
Click .
The non-default columns you have previously selected will move immediately from the Selected Columns list into the Available Columns list.
Click to save the column setting definition and return to the main database overview display, which will show the default column settings again.
When you select to manage, you are first presented with a list of databases to choose from.
Database entries listed in the tree-view are preceded by a stoplight icon:
Green indicates that the database is active.
Red indicates that the database is inactive.
When Adabas Databases is highlighted in tree-view and you have not grouped your databases, a table is displayed in the detail window providing in addition to the stoplight icon, the database ID, database name, and Adabas version of each database that can be administered with Adabas Manager, and for which databases a login with password is required.
If you have grouped your databases, click Open Systems to display the databases information.
To select an Adabas database to work
with:
Select and expand Adabas Databases in tree-view.
Select the database entry in tree-view under Adabas Databases.
Once a database is selected, the following property default information about that database appears in detail-view:
| Property | Description |
|---|---|
| Database ID | The number of the database. |
| Database Name | The name of the database. |
| Database Load Date | The date and time the database was loaded. |
| Highest File Loaded | The highest file number currently in use in the database. |
| Lowest File Loaded | The lowest file number currently in use in the database. |
| Number of Files Loaded | The total number of files currently loaded in the database. |
| System File(s) | The number of Adabas system files allocated to the database. |
| Current PLOG | The number of the most recent data protection log for the database. |
You can change the columns shown in the Database Overview display to include the database version and the maximum number of files.
To change the columns in the database overview display:
In the upper left corner of the database overview display, click
().
The Database Overview panel appears.
On the panel, select columns for the database overview display by moving them into and out of the Selected Columns list. To move a column into the Selected Columns list, select the column name in the Available Columns list and click the right arrow button. To move a column out of the Selected Columns list, select the column name in the Selected Columns list and then click the left arrow button.
Once you have selected the columns for the database overview display, select the order in which they should appear in the database overview display table. Use and to move the column headings up and down in the Selected Columns list.
A number of separators is available, allowing you to partition the tables as you wish.
When the columns you want are listed in the order you want in the Selected Columns list, click to save the column setting definition and return to the main database overview display, which will show the column settings you selected.
Or:
Click to cancel the column setting
definition.
To restore the default database overview display:
In the upper left corner of the database overview display, click
().
The Database Overview panel appears.
Click .
The non-default columns you have previously selected will move immediately from the Selected Columns list into the Available Columns list.
Click to save the column setting definition and return to the main database overview display, which will show the default column settings again.
