This document is organized as follows:
To list the files associated with a database:
Select an Adabas database in tree-view and expand it.
Select Database Files in tree-view.
The files are listed in a file list display table in detail-view. By default, the following information about each file is provided:
the file number
the file name
Optionally, additional information about each file can also be listed, if you change the columns in the file list display, as described in Changing the Columns in the File List Display.
Links are also available for each file listed from which you can review the file properties and the Field Definition Table (FDT) for the file.
Note:
To view a specific file which may be displayed on another page of
the file list, enter the file number in the text box above the table and click
.
You can change the columns shown in the file list display. Specifically, you can indicate whether the following information appears in the file list display table:
the percentage of the Associator area used by the file (Asso Used %)
the percentage of the Data storage area used by the file (Data Used %)
the lowest ISN that can be assigned to a record in the file (Min ISN)
the highest ISN that can be assigned to a record in the file (Max ISN)
the highest ISN currently assigned to a record in the file (Top ISN)
the padding factor for the Associator (ASSO Padding Factor)
the padding factor for Data Storage (DATA Padding Factor)
the date the file was loaded
the date of the last update
the number of records loaded
Note:
Depending on the number of records, the determination of this
value may cause longer response times.
the number of updates since the file was last loaded
the extent list saturation (%, for Adabas for mainframes version 8 databases only)
the number of logical extents currently assigned by Associator: normal index (NI Extent), upper index (UI Extent), address converter (AC Extent)
the number of logical extents currently assigned by Data Storage (DATA Extent)
To change the columns in the file list display:
Access the file list display, as described in Displaying the List of Files.
In the upper left corner of the display, click
(
).
The File Properties panel appears.
On the File Properties panel, select columns for the file list 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 file list display, select the order in which they should appear in the file list display table. The topmost column in the Selected Columns list will appear immediately to the right of the Fields column in the table. Use and to move the column headings up and down in the Selected Columns list.
When the columns you want are listed in the order you want in the Selected Columns list, click or to save the column setting definition.
Or:
Click to cancel the column setting
definition.
If you click or , you are prompted for the unique name of the column setting definition. Continue with the next step.
If you click , the column setting definition is cancelled and you can ignore the remaining steps in this section.
Type in a unique name for the column setting definition and click to save the definition or to cancel the definition.
You can also rename or delete an existing column setting definition. Select the definition name in the selection box and click or .
If you click the column setting definition will be deleted.
If you click , you will be prompted to enter a new name for the definition. Enter the name you have chosen and click .
When you refresh the file list display, the column settings you selected will appear. The selected column settings appear in all file list displays for all databases registered until you change the column settings with a new definition.
If more than one column setting definition is created, you can select the one you want using the drop-down list on the upper right side of the file list display.
To display locked files of a database:
Select an Adabas database in tree-view and expand it.
Right-click Database Files in tree-view and choose in the dropdown menu.
The locked files of the databases are displayed in detail.view. You can unlock a file by marking it and clicking .
