Selecting Database report (option R) from the displays the menu:
Options on the menu provide information only; none of the displayed information can be changed. However, direct commands can be entered on this menu to invoke other Adabas Online System (AOS) functions for making changes.
functions provide both general and specific information in either table or report format. They correspond to selected functions of the Adabas ADAREP utility.
16:11:48 ***** A D A B A S BASIC SERVICES ***** 2014-05-02
- Database Report - PDR0002
Code Service
---- -------------------------------------
C List files with crit. no. of extents
D Display field description table (FDT)
F Display file(s)
G General database layout
L List VOLSER distribution of database
R Display ASSO/DATA block (RABN)
U Display unused storage
V Display used storage (DSPACE)
? 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 allow you to view database-level general information and tables of database files, files whose extents are at or near the allowable maximum, file-specific information for any file, physical database distribution by volume/serial number (VOLSER), and available space that is not currently being used. Additional displays are available using direct commands.
The provided in AOS includes the following information, selected using the appropriate option code, as follows:
| Option | Function |
|---|---|
| C | Displaying Files with Critical Number of Extents shows a list of the files that have a critical number of extents. |
| D | Displaying Field Definition Table (FDT) shows the field definition table (FDT) and special descriptor table (SDT) for the specified file. |
| F | Displaying Files shows file(s), either a list of all files in the specified database or detailed information about a specific file. |
| G | Displaying General Database Layout shows the general layout of the specified database. |
| L | Displaying Volume/Serial Numbers for Database shows the volume/serial number layout of the specified database. |
| R | Displaying ASSO/DATA/WORK Block (RABN) shows Associator / Data Storage blocks (RABNs). |
| U | Displaying Unused Storage shows unused storage. |
| V | Displaying Used Storage shows how much space is defined and used for the Associator (ASSO) and Data Storage (DATA) areas of your databases. |
Option (List files with crit. no. of extents) on the menu provides a list of the files in the database that are at the critical number of extents. If no such files exist in the database, a message is displayed.
Note:
The exact extent count is provided in the general
Display File(s)
() option by table type (AC, NI, UI, or
DS).
Option (Display field description table (FDT)) on the menu provides a list of the field definitions in the FDT. The Display FDT screen appears.
Note:
For more detailed information about field definitions, read
your Adabas ADACMP utility documentation; for more information about
interpreting FDTs, read your Adabas ADAREP utility documentation. Both are
available in the Adabas Utilities documentation.
16:12:15 ***** A D A B A S BASIC SERVICES ***** 2014-05-02
DBID 1955 - Display FDT - PDRD032
Field Description Table: File 1 (EMPLOYEES)
======================== Total Fields without SDT ... 30
*************** T o p of F D T ***************
Lev I Name I Leng I Form I Options I Predict Fld Name or DT / SY
-----I------I-------I-------I----------------- I-----------------------------
1 I AA I 008 I A I DE I
1 I AB I I I I
2 I AC I 020 I A I NU I
2 I AE I 020 I A I DE I
2 I AD I 020 I A I NU I
1 I AF I 001 I A I FI I
1 I AG I 001 I A I FI I
1 I AH I 006 I P I DE NC I
1 I A1 I I I I
2 I AI I 020 I A I MU NU I
2 I AJ I 020 I A I DE NU I
2 I AK I 010 I A I NU I
PF1----- PF2------ PF3------ PF4------ PF6----- PF7----- PF8----- PF12-----
Help Disp SDT Exit -- - + Menu |
For a specified file, option displays the field definition table (FDT), which includes:
the total number of fields in the file;
the level number of each field;
the two-character name of each field;
the length of each field in bytes;
the data type (format) of each field: Alphanumeric, Binary, Fixed point, floatinG point, Packed decimal, Unpacked decimal, or Wide-character;
data definition options for each field: CK for untranslatable characters, DEscriptor, FIxed storage, Long Alphanumeric, MUltiple-value field, Null/not Counted (that is, SQL null representation), Null/Not allowed, NUll value suppression, NV no conversion, PEriodic group (the fields that compose the periodic group are those that follow and have a higher level number), UniQue descriptor value;
Note:
If an online inversion of a field is in process, this
information is noted in the Options column. In
addition, if the field has been deleted online, this information in noted in
the Options column.
equivalent Predict names, if any, for each field or, if the field is a date or time, the edit mask used for the field. A complete description of edit masks can be found in your Adabas documentation.
On the Display FDT screen, press PF2 to access the special descriptor table (SDT) for the file on the Display SDT screen:
16:12:50 ***** A D A B A S BASIC SERVICES ***** 2014-05-02
DBID 1955 - Display SDT - PDRD012
SUB-/SUPER Table: File 1 (EMPLOYEES)
=================
Type I Name I Length I Format I Options I Structure I
------I------I--------I--------I-----------------I-------------------I
SUPER I H1 I 4 I B I DE NU I AU ( 1 - 2 )I
I I I I I AV ( 1 - 2 )I
PHON I PH I I I DE I PHON( AE ) I
SUB I S1 I 4 I A I DE I AO ( 1 - 4 )I
SUPER I S2 I 26 I A I DE I AO ( 1 - 6 )I
I I I I I AE ( 1 - 20 )I
SUPER I S3 I 12 I A I DE NU PE I AR ( 1 - 3 )I
I I I I I AS ( 1 - 9 )I
PF1----- PF2------ PF3------ PF4------ PF6----- PF7----- PF8----- PF12-----
Help Disp FDT Exit -- - + MENU |
The SDT provides field information about all sub-/super-/hyperdescriptors, collation descriptors, phonetic descriptors, and sub-/superfields for the file.
In addition to the field's special descriptor type, two-character name, length, format (data type), and data definition options, the SDT identifies the structure of the special descriptor; that is, the component fields and field bytes of sub-/super-/hyperdescriptors and sub-/superfields; the equivalent alphanumeric elementary fields of phonetic descriptors; and the associated user exit of collation descriptors.
The equivalent direct commands are:
DISPLAY FDT file-number
If no particular file is specified, option (Display file(s)) on the menu lists all files in the specified database. If a file is specified, option provides detailed layout information for the file. Physical device and file layout information is available only for a specific file.
This section covers the following topics:
When no file number or "0" (zero) is specified in the File No field on the menu, a list of the files in the specified database is displayed on the Display Files screen:
Note:
If a file was unsuccessfully loaded (ADALOD) , stored
(ADAORD) or restored (ADASAV) and the file number of the file is higher than
the previous highest-loaded file number, then this file will not be shown until
the next time the database is started. If you want to see the file specifics,
run an ADAREP report.
16:13:21 ***** A D A B A S BASIC SERVICES ***** 2014-05-02
DBID 1955 - Display Files - PDRF032
Fnr File Name Loaded Top-ISN Max-ISN Extents Ind. %Used
YY-MM-DD NI UI AC DA ACISEXU A D
----- ---------------- -------- ---------- ---------- -- -- -- -- ------- -----
1 EMPLOYEES 09-02-17 1107 1695 1 1 1 1 NNISNNN 77 92
2 SECURITY 12-09-12 2 2543 1 1 1 1 NNNSNNN 12 5
3 MISCELLANEOUS 09-02-17 1779 2543 1 1 1 1 NNISNNN 86 53
6 EXPANDED 09-02-17 1107 1600 1 1 1 1 NNISNXN 74 46
7 EXPANDED 09-02-17 3107 3600 1 1 1 1 NNISNXN 74 46
9 TEST-9 10-08-06 0 1695 1 1 1 1 NNNSNNN 0 0
10 TRIGGER-FILE 09-02-17 1 1695 1 1 1 1 NNISNNN 23 10
11 NAT-SYSTEM 09-02-17 99317 100063 1 1 1 1 NNISNNU 52 74
12 NAT-USER 09-02-17 940 30527 1 1 1 1 NNISNNN 80 43
13 NAT-FDIC 09-02-17 47 5087 1 1 1 1 NNISNNN 33 14
14 SPAN-TEST-14 13-08-30 1 1695 1 1 1 1 NNNSNNN 55 5
19 CHECKPOINT 10-12-14 25334 26287 1 1 1 2 NNNSNNN 2 86
20 FILE-1955-20 09-03-04 16 1695 1 1 1 1 NNNSNNN 0 20
21 FILE-1955-21 09-03-04 7 1695 1 1 1 1 NNNSNNN 0 10
PF1----- PF2------ PF3------ PF4------ PF6----- PF7----- PF8----- PF12-----
Help Repos Exit Extents -- - + 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.
If the extents (NI, UI, AC, and DA) listed on this screen exceed 99 and you want to see their actual values or if you would like to see the value of any secondary AC extent, press the PF4 (Extents) key. The window changes slightly to show the expanded values of the extents, although, due to screen space, the indicators are removed.
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.
block padding factor percentage defined for the Associator and for Data Storage;
indicators as follows:
| Indicator | Description |
|---|---|
| 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 menu, the following Display File Layout screen appears for that file (some of the items shown on the following sample screen only appear if those features are activated or used):
16:17:01 ***** A D A B A S BASIC SERVICES ***** 2014-05-02
DBID 1955 - Display File Layout - PDRF043
****************
* File 3 * MISCELLANEOUS
****************
Records loaded ..... 1779 Date loaded .......... 2009-02-17 19:08:00
TOP ISN ............ 1779 Date of last update .. 2010-12-14 11:30:19
Max ISN expected ... 2543 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 .. 0 RPLUPDATEONLY. No
ISN Reusage ........ Yes USERISN ...... No 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
Blk per DS Extent .. 0 Logged DSF Changes ... DS AC Index
Blk per UI Extent .. 0 Total Changed Blks ... 87
Blk per NI Extent .. 0 Multi Client File .... 0
Press Enter to display more information
PF1----- PF2------ PF3------ PF4------ PF6----- PF7----- PF8----- PF12-----
Help Exit Refresh Menu |
16:17:18 ***** A D A B A S BASIC SERVICES ***** 2014-05-02
DBID 1955 - Display File Layout - PDRF043
**************** Page 2
* File 3 * MISCELLANEOUS
****************
Last format AC ISN .. 2543
File readonly mode .. No Date FDT modified .... 2009-08-25 02:05:08
FDT deleted field ... No
File has l/c fields . No
FDT has F,8 field ... No
FDT w/datetime mask . No
FDT w/system fields . No SYFMAXUV value ....... 0
Free space available for file extents: At least 134 Extents
PF1----- PF2------ PF3------ PF4------ PF6----- PF7----- PF8----- PF12-----
Help Exit Refresh Menu |
16:17:40 ***** A D A B A S BASIC SERVICES ***** 2014-05-02
DBID 1955 - Display File Layout - PDRF043
File has LOB Fields, Related file number 0
PF1----- PF2------ PF3------ PF4------ PF6----- PF7----- PF8----- PF12-----
Help Exit Refresh Menu |
16:17:57 ***** A D A B A S BASIC SERVICES ***** 2014-05-02
DBID 1955 - Display File Layout - PDRF052
File 3
I Dev LiI Space allocated I From To I Unused
I Type TyI Blocks / Cyls. I RABN RABN I BLOCKS / Cyls.
----I--------I-------------------I ------------------------I------------------
I I I I
ASSOI 3390 ACI 3 0 I 5227 - 5229 I 0 0
ASSOI 3390 UII 5 0 I 5261 - 5265 I 0 0
ASSOI 3390 NII 31 0 I 5230 - 5260 I 5 0
I I I I
DATAI 3390 DSI 100 0 I 71 - 170 I 47 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 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.
the maximum number of occurrences of MU system fields that can be stored in the file.
If the file is a spanned file, the following additional information will be displayed in the sequence of Display File Layout screens:
19:03:36 ***** A D A B A S BASIC SERVICES ***** 2014-05-02
DBID 1955 - Display File Layout - PDRF043
TOP AC2 ISN .............. 4
Max AC2 ISN .............. 1695
Min AC2 ISN .............. 1
Last formatted AC2 ISN ... 1695
PF1----- PF2------ PF3------ PF4------ PF6----- PF7----- PF8----- PF12-----
Help Exit Refresh Span cnt Menu |
When universal encoding support (UES) is being used, the following additional information will be displayed in the sequence of Display File Layout screens:
15:33:00 ***** A D A B A S BASIC SERVICES ***** 2009-08-25 DBID 1955 - 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 |
If LOB flags are set, the following additional information will be displayed in the sequence of Display File Layout screens:
16:52:35 ***** A D A B A S BASIC SERVICES ***** 2009-08-25
DBID 1955 - Display File Layout - PDRF042
LOB File, Related file number 29
PF1----- PF2------ PF3------ PF4------ PF6----- PF7----- PF8----- PF12-----
Help Exit Refresh Menu |
or
16:17:40 ***** A D A B A S BASIC SERVICES ***** 2014-05-02
DBID 1955 - Display File Layout - PDRF043
File has LOB Fields, Related file number 29
PF1----- PF2------ PF3------ PF4------ PF6----- PF7----- PF8----- PF12-----
Help Exit Refresh Menu |
If the file is part of an expanded file chain, the following information will be displayed at the top of the first Display File Layout screen:
>> Part of Expanded File Chain << >> Anchor file = 6 << >> Last file of Expanded File Chain << |
Option (General database layout) on the menu displays general database information on the Display General DB-Layout screen.
The equivalent direct command is
DISPLAY DBLAYOUT
19:14:01 ***** A D A B A S BASIC SERVICES ***** 2014-05-02
DBID 1955 - Display General DB-Layout - PDRG012
Database Name ............ WIS1955
Database Number .......... 1955
Database Version ......... 8.3
Database Load Date ....... 2010-12-14 11:29:33
System Files ............. 19 , 2 , 10 , 0 , 0 , 0 , 0
Maximum Number of Files .. 1000
Number of Files Loaded ... 33
Highest File Loaded ...... 400
Trigger File Number ...... 10
Size of RABN ............. 3 Bytes
Current Log Tape Number .. 429
Delta Save Facility ...... Inactive Replication Facility ..... Yes
Recovery Aid Facility .... Inactive
Universal Encoding Sup. .. Inactive
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 General DB-Layout screen lists the current code values:
15:51:22 ***** A D A B A S BASIC SERVICES ***** 2006-07-20 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 General DB-Layout screen displays the following space allocation and usage information:
19:14:42 ***** A D A B A S BASIC SERVICES ***** 2014-05-02
DBID 1955 - Display General DB-Layout - PDRG012
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 3390 I 53982 200 I 1 53982 I DDASSOR1 I
I I I I I
DATA I 3390 I 44990 300 I 1 44990 I DDDATAR1 I
DATA I 3390 I 44999 300 I 44991 89989 I DDDATAR2 I
I I I I I
WORK I 3390 I 8091 60 I 1 8091 I DDWORKR1 I
PF1----- PF2------ PF3------ PF4------ PF6----- PF7----- PF8----- PF12-----
Help Exit Menu |
Option (List VOLSER distribution of database) on the menu displays the physical volumes on which the database Associator and Data Storage files are located, sorted by VOLSER number for ASSO or DATA and including the highest RABN for each extent.
The equivalent direct command is
DISPLAY VOLSERTAB
The Display Volser-Tab screen appears.
19:15:22 ***** A D A B A S BASIC SERVICES ***** 2014-05-02
DBID 1955 - Display Volser-Tab - PDRL002
Mark entries with 'D' to display file extents on volume :
I I ASSO/ I Highest RABN I
M I VOLSER I DATA I in extent I
--------------------------------------
_ I SMSZ11 I ASSO I 53982 I
_ I SMSZ11 I DATA I 89989 I
_ I I I I
_ I I I I
_ I I I I
_ I I I I
_ I I I I
_ I I I I
_ I I I I
_ I I I I
_ I I I I
_ I I I I
PF1----- PF2------ PF3------ PF4------ PF6----- PF7----- PF8----- PF12-----
Help Exit Menu |
If you mark one of the entries on this screen with "D" (or you entered the VOLSER number directly on the menu), the file extents of the volume are displayed indicating the RABN range and device type of each extent (table type) in each file on the List File Extents on VOLSER screen:
19:15:53 ***** A D A B A S BASIC SERVICES ***** 2014-05-02
DBID 1955 - List File Extents on VOLSER - PDRL022
VOLSER = SMSZ11
I ASSO/ I From I To I Device I File I Table I
I DATA I Rabn I Rabn I Type I Nr. I Type I
I-------I-------------I-------------I--------I-------I---------I
I ASSO I 5031 I 5048 I 3390 I 0 I DSST I
I I 5049 I 5066 I 3390 I 0 I DSST I
I I 5099 I 5100 I 3390 I 1 I AC I
I I 5101 I 5185 I 3390 I 1 I NI I
I I 5186 I 5198 I 3390 I 1 I UI I
I I 5199 I 5201 I 3390 I 2 I AC I
I I 5202 I 5221 I 3390 I 2 I NI I
I I 5222 I 5226 I 3390 I 2 I UI I
I I 5227 I 5229 I 3390 I 3 I AC I
I I 5230 I 5260 I 3390 I 3 I NI I
I I 5261 I 5265 I 3390 I 3 I UI I
I I 5266 I 5267 I 3390 I 6 I AC I
PF1----- PF2------ PF3------ PF4------ PF6----- PF7----- PF8----- PF12-----
Help Exit Menu |
Option (Display ASSO/DATA block (RABN)) on the menu invokes the Read ASSO/DATA Block screen.
The equivalent direct command is
DISPLAY RABN
19:16:23 ***** A D A B A S BASIC SERVICES ***** 2014-05-02
DBID 1955 - Read ASSO/DATA Block - PDRR002
Type .. _ RABN No .... __________ Offset .. 0000
Hex RABN ... 00000000
0000 00000000 00000000 00000000 00000000
0000 00000000 00000000 00000000 00000000
0000 00000000 00000000 00000000 00000000
0000 00000000 00000000 00000000 00000000
0000 00000000 00000000 00000000 00000000
0000 00000000 00000000 00000000 00000000
0000 00000000 00000000 00000000 00000000
0000 00000000 00000000 00000000 00000000
0000 00000000 00000000 00000000 00000000
0000 00000000 00000000 00000000 00000000
0000 00000000 00000000 00000000 00000000
0000 00000000 00000000 00000000 00000000
0000 00000000 00000000 00000000 00000000
0000 00000000 00000000 00000000 00000000
0000 00000000 00000000 00000000 00000000
Enter RABN details and press 'Enter' to display
PF1----- PF2------ PF3------ PF4------ PF6----- PF7----- PF8----- PF12-----
Help Exit Menu |
On this screen, enter a RABN type ("A" for Associator or "D" for Data Storage) and a RABN number (in either decimal or hexadecimal format) to display a screen similar to the following:
19:18:28 ***** A D A B A S BASIC SERVICES ***** 2014-05-02
DBID 1955 - Read ASSO/DATA Block - PDRR002
Type .. A (ASSO) RABN No .... 5150______ Offset .. 00F0
Hex RABN ... 0000141E
00F0 0000E90D C4D44000 00000000 0062000F * Z?DM Â ? *
0100 02020000 F3000136 0DC4D440 00000000 * ?? 3 ???DM *
0110 00006200 0F030100 00F60DC4 D4400000 * Â ??? 6?DM *
0120 00000000 62100F03 01000120 0DC4D440 * Â???? ???DM *
0130 00000000 00006250 0F050100 018B0DC4 * Â&??? ?»?D *
0140 D4400000 00000000 64000F03 010000E2 * M À ??? S *
0150 0DC4D440 00000000 00006400 0F040100 * ?DM À ??? *
0160 018B0DC4 D4400000 00000000 64100F02 * ?»?DM À??? *
0170 01000120 0DC4D440 00000000 00006450 * ? ???DM À& *
0180 0F010100 00DE0DC4 D4400000 00000000 * ??? ?DM *
0190 64600F01 0100018D 0DC4D440 00000000 * À-??? ?ý?DM *
01A0 00006480 0F010100 012D0DC4 D4400000 * ÀØ??? ???DM *
01B0 00000000 65000F03 010000D2 0DC4D440 * Á ??? K?DM *
01C0 00000000 00006540 0F010200 012F0001 * Á ??? ?? ? *
01D0 7E0DC4D4 40000000 00000065 500F0101 * =?DM Á&??? *
PF1----- PF2------ PF3------ PF4------ PF6----- PF7----- PF8----- PF12-----
Help Exit RABN+1 - + Menu |
Option displays two-doubleword-per-screen rows of the specified RABN block from the Associator or Data Storage in hexadecimal format. Both the hexadecimal data and its alphanumeric equivalent are displayed. If the block is not assigned, zeros are displayed.
The blocks are displayed in the length of the Associator or Data Storage block length.
You can scroll through the RABN display using the PF7 (scroll backward) and PF8 (scroll forward) keys. When using DISPLAY RABN, the offset switches to FFxx when you page past end-of-block. The display just continues to show the next block, until the offset reaches FFFF, when it returns to the first page.
You can display information for the next highest RABN (that is, the current RABN number plus one) by pressing PF4.
If the ADARUN AOSLOG parameter is set to "YES" and you access this screen, a message is printed to DDPRINT that includes the SECUID, type of RABN (ASSO, DATA or WORK), and the RABN number. This message looks like this:
****** A O S / UTILITY OPERATOR COMMAND ****** SECUID=secuid yyyy-mm-dd hh:mm:ss DISPLAY type RABN rabn
Option (Display unused storage) on the menu displays a table of unused storage within the database. The Display Unused Storage screen appears.
The equivalent direct command is
DISPLAY UNUSED
19:18:49 ***** A D A B A S BASIC SERVICES ***** 2014-05-02
DBID 1955 - Display Unused Storage - PDRU012
I Device I Total Number of I Extent in Blk. I
I Type I Blocks / Cyls. I from - until I
------I--------I------------------------- I----------------------------I
DATA I 3390 I 10 0 I 50783 - 50792 I
I 3390 I 37490 249 I 52500 - 89989 I
------I--------I------------------------- I----------------------------I
ASSO I 3390 I 31 0 I 20889 - 20919 I
I 3390 I 29291 108 I 24692 - 53982 I
PF1----- PF2------ PF3------ PF4------ PF6----- PF7----- PF8----- PF12-----
Help Exit DSpace Menu |
Separately for the Associator and Data Storage extents, the table shows the device type where the unused blocks are located, the number of unused storage blocks and cylinders, and the range of unused block numbers.
Option (Display used storage (DSPACE)) on the menu displays how much space is defined and used for the Associator (ASSO) and Data Storage (DATA) areas of your databases.. The Display Used Space screen appears.
The equivalent direct command is
DISPLAY DSPACE
19:19:11 ***** A D A B A S BASIC SERVICES ***** 2014-05-02
DBID 1955 - Display Used Space - PDRV002
-------- ASSO ---------------------- -------- DATA ----------------------
Percent.. 45% Percent.. 58%
Bytes Bytes
Used .. 62,735,040 Used .. 265,804,296
Alloc . 137,330,208 Alloc . 455,704,296
Blocks Blocks
Used .. 24,660 Used .. 52,489
Alloc . 53,982 Alloc . 89,989
Cylinders Cylinders
Used .. 92 Used .. 350
Alloc . 200 Alloc . 600
PF1------ PF2------ PF3------ PF4------ PF6----- PF7----- PF8----- PF12-----
Help Exit Refresh Menu |
This screen shows how much space is used and defined for the Associator and Data Storage areas of your database.