Version 7.4.4
 —  DBA Tasks  —

Database Report

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:


Display Files

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.

Display a List of Files in the Specified Database

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:

Display Information for a Specific File

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:

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

Top of page

Display General Database Layout

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:

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

Top of page