Database Report functions, which correspond to selected functions of the Adabas ADAREP utility, provide both general and specific information in either table or report format.
14:43:26 ***** A D A B A S BASIC SERVICES ***** 2002-05-29
- Database Report - PDR0002
Code Service
---- -------------------------------------
* List files with crit. no. of extents
* Display field description table (FDT)
F Display file(s)
G General database layout
* List VOLSER distribution of database
* Display ASSO/DATA block (RABN)
* Display unused storage
? Help
. Exit
---- -------------------------------------
Code ......... _
File No ...... 0_____ Password ..
Database ID .. 1955 (WIS1955)
VOLSER ....... ______
Command ==>
PF1----- PF2------ PF3------ PF4------ PF6----- PF7----- PF8----- PF12-----
Help Exit Menu |
Options available to the AOS demo version allow you to view database-level general information and tables of database files, and file-specific information for any file:
| Code | Function |
| F | Display file(s), either a list of all files in the specified database or detailed information about a specific file. |
| G | Display the general layout of the specified database. |
This document covers the following topics:
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.
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:
09:24:38 ***** A D A B A S BASIC SERVICES ***** 1997-02-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 1993-06-15 1110 5511 1111 3 3 NNISNNN 68 88
2 MISCELLANEOUS 1993-06-15 1779 5511 1111 3 3 NNISNNN 32 88
4 AUTOMOBILES 1993-06-15 1000 5511 1111 3 3 NNISNNN 34 36
5 PERSONNEL 1993-06-15 1000 5511 1111 3 3 NNISNNN 38 52
6 FINANCE 1993-06-15 1000 5511 1111 3 3 NNISNNN 52 52
7 GDMUSIC 1992-05-01 3292 16535 1111 3 3 NNNSNNN 81 95
8 SAMPC-REV311DATA 1992-05-01 44679 100593 1111 3 3 NNNSNNN 79 99
9 RD-NAT217-FUSER 1993-09-23 163272 175005 1111 3 3 NNISNNN 76 99
10 RD-PRD314-FDIC 1992-05-01 60016 63387 1111 3 3 NNNSNNN 73 90
11 REV320-DBFILE 1992-05-01 4442 11023 1111 10 10 NNNSNNN 42 82
12 REV340-DBFILE 1993-02-15 52008 63387 1111 10 10 NNNSNNN 6 13
13 SASRM-ZAP-TEST 1992-05-01 11 1377 1111 3 3 NNNSNNN 93 4
14 SASRM-ZAPSYS 1992-05-01 5 1377 1111 3 3 NNNSNNN 28 4
16 SAGDT-PRD-FDIC 1992-05-01 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.
When a valid system file number is specified on the Database Report menu, the following Display File Layout information is displayed for that file:
18:27:37 ***** A D A B A S BASIC SERVICES ***** 1999-01-28 DBID 105 - Display File Layout - PDRF012 **************** * File 75 * UES-FILE **************** Records loaded ..... 1107 Date loaded .......... 1999-01-26 12:18:17 Top ISN ............ 1107 Max ISN expected ... 1502 Max Compr Rec Lngth .. 4816 Minimum ISN ........ 1 Asso/Data Padding .... 3%/3% Size of ISN ........ 3 Bytes Highest Index Level .. 3 Number of Updates .. 0 ISN Reusage ........ NO USERISN .............. NO Space Reusage ...... YES MIXDSDEV ............. NO ADAM File .......... NO PGMREFRESH ........... NO Ciphered File ...... NO NOACEXTENSION ........ NO Coupled Files ...... NONE Universal Encoding ... YES Blk per DS Extent .. 0 Blk per UI Extent .. 0 Blk per NI Extent .. 0 Length of Owner ID ... 0 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 space allocations by pressing ENTER .
The Display File Layout screen displays the following 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 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;
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.
whether universal encoding support (UES) is being used.
Pressing ENTER from the initial Display File Layout screen displays the following space allocation and usage information:
18:33:41 ***** A D A B A S BASIC SERVICES ***** 1999-01-28
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 |
Option G displays general database information on the Display General DB-Layout screen:
18:43:07 ***** A D A B A S BASIC SERVICES ***** 1999-01-28 DBID 105 - Display General DB-Layout - PDRG002 Isolated Database Name ............ RD-105 Database Number .......... 105 Database Version ......... 7.1 Database Load Date ....... 1998-10-21 14:40:47 System Files ............. 19 , 0 , 0 , 0 , 0 , 0 , 0 , 0 Maximum Number of Files .. 100 Number of Files Loaded ... 5 Highest File Loaded ...... 75 Trigger File Number ...... 14 Size of RABN ............. 4 Bytes Current Log Tape Number .. 5 Delta Save Facility ...... Inactive Recovery Aid Facility .... Inactive Universal Encoding Sup. .. Yes PF1----- PF2------ PF3------ PF4------ PF6----- PF7----- PF8----- PF12----- Help Exit Menu |
You can display additional information about UES codes, coupling, and space allocations by pressing ENTER.
The Display General DB Layout screen displays the following information for the file:
the name and number of the database;
the version level of the Adabas database software;
the date and time the database was loaded;
the numbers of Adabas system files allocated to the database;
the maximum number of files permitted for the database; the total number of files currently loaded; and the highest file number currently in use;
whether 3- or 4-byte RABNs are being used for the file;
the number of the most recent data protection log tape for the database;
whether the Adabas Delta Save Facility and/or the Adabas Recovery Aid (ADARAI) are active or inactive for the database.
whether universal encoding support (UES) is being used.
When universal encoding support (UES) is being used, pressing ENTER from the initial Display File Layout screen lists the current code values:
18:51:22 ***** A D A B A S BASIC SERVICES ***** 1999-01-28 DBID 105 - Display General DB-Layout - PDRG002 Universal Encoding Support Enabled UES Encoding Keys: Alpha File Encoding ......... 37 Wide File Encoding .......... 4095 Alpha ASCII Encoding ........ 437 Wide User Encoding .......... 4095 |
In any case, pressing ENTER from the initial Display File Layout screen displays the following space allocation and usage information:
18:52:01 ***** A D A B A S BASIC SERVICES ***** 1999-01-28
DBID 105 - Display General DB-Layout - PDRG002
IDeviceI Total Number of I Extents in Block I DD-Names I
I Type I Blocks / Cyls. I From To I I
------I------I----------------------I -------------------------I----------I
I I I I I
ASSO I 3380 I 14231 50 I 1 14231 I DDASSOR1 I
I I I I I
DATA I 3380 I 6741 50 I 1 6741 I DDDATAR1 I
I I I I I
WORK I 3380 I 3592 30 I 1 3592 I DDWORKR1 I
PF1----- PF2------ PF3------ PF4------ PF6----- PF7----- PF8----- PF12-----
Help Exit Menu |
