If no particular file is specified, option "F" lists all files in the specified database. If a file is specified, option "F" provides detailed layout information for the file. Physical device and file layout information is available only for a specific file.
This document covers the following topics:
When no file number or "0" (zero) is specified in the File No field on the Database Report menu, a list of the files in the specified database is displayed:
15:24:38 ***** A D A B A S BASIC SERVICES ***** 2006-07-20
DBID 105 - Display Files - PDRF002
Fnr File Name Loaded Top-ISN Max-ISN Ext. Pad % Ind. %Used
NUAD A D ACISEXU A D
---- ---------------- ---------- ---------- ---------- ---- -- -- ------- -----
1 EMPLOYEES 2006-07-20 1110 5511 1111 3 3 NNISNNN 68 88
2 MISCELLANEOUS 2006-07-20 1779 5511 1111 3 3 NNISNNN 32 88
4 AUTOMOBILES 2006-07-20 1000 5511 1111 3 3 NNISNNN 34 36
5 PERSONNEL 2006-07-20 1000 5511 1111 3 3 NNISNNN 38 52
6 FINANCE 2006-07-20 1000 5511 1111 3 3 NNISNNN 52 52
7 GDMUSIC 2006-07-20 3292 16535 1111 3 3 NNNSNNN 81 95
8 SAMPC-REV311DATA 2006-07-20 44679 100593 1111 3 3 NNNSNNN 79 99
9 RD-NAT217-FUSER 2006-07-20 163272 175005 1111 3 3 NNISNNN 76 99
10 RD-PRD314-FDIC 2006-07-20 60016 63387 1111 3 3 NNNSNNN 73 90
11 REV320-DBFILE 2006-07-20 4442 11023 1111 10 10 NNNSNNN 42 82
12 REV340-DBFILE 2006-07-20 52008 63387 1111 10 10 NNNSNNN 6 13
13 SASRM-ZAP-TEST 2006-07-20 11 1377 1111 3 3 NNNSNNN 93 4
14 SASRM-ZAPSYS 2006-07-20 5 1377 1111 3 3 NNNSNNN 28 4
16 SAGDT-PRD-FDIC 2006-07-20 25649 30315 1111 3 3 NNISNNN 57 85
PF1----- PF2------ PF3------ PF4------ PF6----- PF7----- PF8----- PF12-----
Help Repos Exit -- - + Menu |
The PF2 (Reposition) key displays a window in which you can enter a new starting value for the file list. When you enter a file number, the Display Files list begins with that file.
The Display Files screen provides the following information for each file:
file number and file name;
date the file was loaded into the database;
highest ISN currently in use in the file and the highest ISN allowed in the file;
number of logical extents currently assigned: by Associator ( N ormal index; U pper index; A ddress converter) and D ata Storage. A maximum of five logical extents may be allocated to a file.
block padding factor percentage defined for the Associator and for Data Storage;
indicators as follows:
| A | ADAM option: A = ADAM ISN- or descriptor-selected file; N = non-ADAM file. |
| C | coupled (C) or non-coupled (N) file. |
| I | ISNs are reusable (I) or not (N). |
| S | Data Storage blocks are reusable (S) or not (N). |
| E | data files are ciphered/encrypted (E) or not (N). |
| X | files are expanded (X) or normal (N). |
| U | USERISN option: U = option is in effect for the file; N = option is not in effect. |
percentage of allocated space currently used by the file in the Associator and in Data Storage.
The equivalent direct command is
DISPLAY FILE
When a valid file number is specified on the Database Report menu, the following Display File Layout information is displayed for that file (some of the items shown on the following sample screen only appear if those features are activated or used):
13:35:52 ***** A D A B A S BASIC SERVICES ***** 2009-06-12
DBID 1955 - Display File Layout - PDRF042
****************
* File 11 * NAT-SYSTEM
****************
Records loaded ..... 60754 Date loaded .......... 2009-02-17 19:17:04
TOP ISN ............ 60841 Date of last update .. 2009-06-08 03:34:25
Max ISN expected ... 80559 Max Compr Rec Lngth .. 5060
Minimum ISN ........ 1 Asso/Data Padding .... 10%/10%
Size of ISN ........ 3 Bytes Highest Index Level .. 3
Number of Updates .. 82862 RPLUPDATEONLY. No Indx Comp ...... Yes
ISN Reusage ........ Yes USERISN ...... Yes PGMREFRESH ..... No
Space Reusage ...... Yes MIXDSDEV ..... No NOACEXTENSION .. No
ADAM File .......... No Spanned rec .. No MU/PE indices .. 1
Ciphered File ...... No Replication .. No Privileged Use . No
Coupled Files ...... None Universal Encoding ... Yes
Blk per DS Extent .. 0 Logged DSF Changes ... DS AC Index
Blk per UI Extent .. 0 Total Changed Blks ... 28756
Blk per NI Extent .. 0 Multi Client File .... 0
Free space available for file extents: At least 134 Extents
PF1----- PF2------ PF3------ PF4------ PF6----- PF7----- PF8----- PF12-----
Help Exit Refresh Menu
|
The information for the file can be refreshed by pressing PF4.
You can display additional information about UES codes, coupling, LOB file/fields and space allocations by pressing ENTER.
The equivalent direct command is
DISPLAY FILE file-number
The Display File Layout screen displays the following kinds of information for the file:
the file number and name;
the number of records currently contained in the file;
ISN information: the highest ISN currently used in the file; the highest ISN planned for the file (see the ADALOD utility's MAXISN parameter); the lowest ISN that can be assigned to a record in the file (see the ADALOD utility's MINISN parameter); whether 3- or 4-byte ISNs are used for the file; and whether ISNs can be reused.
the total number of updates since the file was last loaded;
other file option settings: whether Data Storage space can be reused; whether the file was loaded with the ADAM option, the cipher option, the USERISN option; whether the file is physically coupled to another file; whether Data Storage extents can be on different device types; whether the file can be refreshed using the E1 command; whether the file permits the MAXISN setting to be increased.
the number of blocks allowed per Data Storage, upper index, and normal index extent;
the date and time the file was last loaded;
the date and time of the last update to the file;
the maximum compressed record length permitted for the file (see the ADALOD utility's MAXRECL parameter);
the padding factor for the Associator and for Data Storage;
the highest index level currently active for the file;
whether the file may be updated only by the Event Replicator Server as part of Adabas-to-Adabas replication or by other means as well (RPLUPDATEONLY);
whether or not index compression is turned on for the file;
whether universal encoding support (UES) is being used;
whether the file contains spanned records;
the number of MU/PE indices in the file;
Whether replication has been activated for the file;
The DSF changes being logged for the file;
the total number of blocks in the file that have been changed by updates since the file was last loaded;
the length of the owner ID for multiclient files.
When universal encoding support (UES) is being used, pressing ENTER from the initial Display File Layout screen lists the current code values:
15:33:00 ***** A D A B A S BASIC SERVICES ***** 2006-07-20 DBID 105 - Display File Layout - PDRF012 Universal Encoding Support enabled for this file Encoding Keys: File Alpha Code .............. 37 File Wide Code ............... 4095 User Wide Code ............... 4095 |
In any case, pressing ENTER from the initial Display File Layout screen displays the following space allocation and usage information:
15:33:41 ***** A D A B A S BASIC SERVICES ***** 2006-07-20
DBID 105 - Display File Layout - PDRF022
File 75
IDeviceIListI Space allocated I From To I Unused I
I Type ITypeI Blocks / Cyls. I RABN RABN I Blocks / Cyls.I
-----I------I----I-------------------I --------------------I----------------I
I I I I I I
ASSO I 3380 I AC I 3 0 I 724 - 726 I 0 0 I
I 3380 I UI I 15 0 I 747 - 761 I 0 0 I
I 3380 I NI I 20 0 I 727 - 746 I 0 0 I
I 3380 I NI I 56 0 I 762 - 817 I 2 0 I
I I I I I I
DATA I 3380 I DS I 116 0 I 216 - 331 I 29 0 I
PF1----- PF2------ PF3------ PF4------ PF6----- PF7----- PF8----- PF12-----
Help Exit Refresh Menu |
If LOB flags are set, the following information will be displayed:
16:52:35 ***** A D A B A S BASIC SERVICES ***** 2006-08-25 DBID 1956 - Display File Layout - PDRF042 LOB File, Related file number 15 |
or
16:54:23 ***** A D A B A S BASIC SERVICES ***** 2006-08-25 DBID 1956 - Display File Layout - PDRF042 File has LOB Fields, Related file number 16 |
