Adabas Online System Demo Version

#### Search Results

Search

# Adabas Online System Demo Version

A demo version of Adabas Online System (AOS) and access to the online services for selected other Adabas products and facilities is included with Adabas as shown in the following diagram:

##### AOS Demo Version

This part of the DBA tasks documentation describes the operation and use of the AOS demo version. The use of the online services for the other Adabas products and facilities is described in the manuals for those products and facilities. The demo services available for Adabas Fastpath (AFPLOOK) and Adabas Vista (AVILOOK) are described in AFPLOOK and AVILOOK. AOS Security is described in the Adabas Security documentation.

This information is organized under the following headings:

- Overview

- Main Menu Functions

- Session Monitoring

- List Checkpoints

- File Maintenance

- Database Maintenance

- System Operator Command Functions

- Database Report

## Overview

The AOS demo version includes the following functions that are comparable to Adabas operator commands and utilities and are used for Adabas database analysis and control:

##### Overview of the AOS Demo Version

See the Adabas Installation documentation for information about installing the demo version of AOS.

The AOS add-on product includes services that correspond to additional utility functions and operator commands. Read the Adabas Online System documentation for information.

The DBA can use the AOS demo version to monitor aspects of an Adabas database while an Adabas session is active. Using menu options, the DBA can view resource and hold queue status; display space allocation; display file and database parameters; create new FDTs; and stop a current Adabas session.

For analyzing performance and monitoring database operation, the AOS demo version displays the system from the viewpoint of either a user or a particular system resource. For example, you can:

- check hold queue status;

- view nucleus parameters;

- monitor command and file usage and system performance information;

- list file layout and extent status; and

- list file distribution of the database by VOLSER.

For controlling the overall Adabas session, the AOS demo version can be used to

- create new FDTs; and

- terminate an Adabas nucleus session (ADAEND).

## Main Menu Functions

To enter the AOS demo version, log on to the Natural application SYSAOS and enter MENU at the NEXT prompt, if one appears.

Note
If the full version AOS is installed on your system, enter MENU instead. See the Adabas Online System documentation for more information.

    12:59:18          ***** A D A B A S  BASIC  SERVICES *****          2014-04-30
    Cluster                        -  Main Menu  -                      PMAIN02

                 Code  Basic Services              Code  Other Services
                 ----  ----------------------      ----  ---------------------
                  A    Session monitoring           1    Adabas Cache Facility
                  C    Checkpoint maintenance       2    Delta Save Facility
                  F    File maintenance             *    Trigger Maintenance
                  M    Database maintenance         4    AOS Security
                  O    Session opercoms             5    Transaction Manager
                  R    Database report              6    Adabas Statistics
                  *    Space calculation            7    Vista
                  ?    Help                         8    Fastpath
                  .    Exit                         9    SAF Security
                 ----  ----------------------      ----  ---------------------

     Code ....... _
     Database ... 1955    (WIS1955)

    Command ==>
    PF1----- PF2------ PF3------ PF4------ PF6----- PF7----- PF8----- PF12-----
    Help               Exit

The Main Menu displays the functions available with Adabas Online System. AOS functions that are not not available with the demo version are marked with an asterisk (*) on the screen.

From the Main Menu, you can access available "Basic Services" functions or one of the "Other Services" installed on your system. Other services installed at your site are highlighted.

The Main Menu indicates the main DBA tasks in the demo version:

Option | Function
--- | ---
A | Session monitoring allows you to display nucleus parameters, session and thread status information, ISNs in the hold queue, and maintenance levels for nucleus modules
C | Checkpoint maintenance allows you to list checkpoint information
F | File maintenance allows you to define a new FDT for a new file
M | Database maintenance is not active for the demo version
O | Session opercoms allows you to add or delete PIN modules used by the extended error recovery facilities; display currently loaded PIN routines and activate or deactivate them, display locked files, and terminate a session normally (ADAEND)
R | Database report allows you to view general database layout information, tables of database files, and detailed information for any file

Subsequent sections in this chapter describe the major functions of the AOS demo version and menu/screen structures in the order that they appear on the Main Menu.

This section covers the following topics:

- Specifying the AOS Demo Version Database

- Using Program Function (PF) Keys

- Selecting a Menu Option

- Getting Help

- AOS Demo Version Messages

### Specifying the AOS Demo Version Database

The database on which the AOS demo version is installed becomes the default database for demo version functions. However, you can specify the database of any active Adabas nucleus session. Subsequent AOS demo version functions refer to that database until you specify another database or exit the AOS demo version.

### Using Program Function (PF) Keys

Available PF keys and their functions are listed at the bottom of each screen. The following program function (PF) keys appear on all screens within the AOS demo version; other navigation keys appear on some screens:

PF1 | Help
PF3 | Exit to previous screen
PF12 | Return to the Main Menu

### Selecting a Menu Option

To select a function or option, enter the option code in the Code field.

Selecting a Main Menu function displays a menu of choices for that function.

### Getting Help

From any AOS demo version menu, you can use PF1 to display a brief comment about the current menu. See Using Program Function (PF) Keys .

### AOS Demo Version Messages

The AOS demo version issues a message confirming each completed function. If an error occurs, a message appears containing a reference number and describing the error.

Before analyzing an error, try reviewing the help information (PF1) for the last step you performed to see if any requirements were overlooked; then retry the operation.

Response code 22 (ADARSP022) is returned if the Adabas session is terminated and restarted while the AOS demo version is active. In this case, the application should be stopped and restarted.

## Session Monitoring

Adabas session monitoring functions display major Adabas resources. These functions are most useful when analyzing system performance or seeking the cause of performance problems.

     13:10:35          ***** A D A B A S  BASIC  SERVICES *****          2014-04-29
                                -  Session Monitoring  -                 PAC0012

      Code   Service                         Code   Service
      ----   ---------------------------     ----   ----------------------------
       *     Display cluster members          *     Current snapshot statistics
       *     Maintain user profiles           *     Maintain TCP/IP URL
       D     Display parameters               U     Display interval utilization
       I     Display installed products       *     Replicator Management
       *     Display event log buffer         *     Cluster usage
       *     Modify parameters                Z     Display maintenance levels
       Q     Display queues
       *     Refresh interval statistics
       ?     Help                             .     Exit
      ----   ---------------------------     ----   ----------------------------
             Code ......... _
             Database ID .. 1955    (WIS1955)               NucID .. 1021

     Command ==>
     PF1----- PF2------ PF3------ PF4------ PF6----- PF7----- PF8----- PF12-----
     Help     NextNuc   Exit                                           Menu

You can use the Session Monitoring environment to monitor the Adabas nuclei in a multiprocessing ( Parallel Services or Cluster Services) environment. When the DBID of a Parallel or Cluster Services database is entered on the Session Monitoring menu, subsequent screens include a field to specify the ID of the nucleus in the cluster that you want to monitor.

Each of the functions on the Session Monitoring menu is discussed in the following sections:

Option | Function
--- | ---
D | Display Adabas nucleus (ADARUN) parameters
I | Display a list of installed products
Q | Display the contents of the hold queue
U | Display session status and thread usage
Z | Display Adabas nucleus modules: maintenance levels and ZAPs applied

This section covers the following topics:

- Display ADARUN Parameters

- Display Installed Products

- Display Hold Queue

- Display System Status and Thread Usage

- Display Maintenance Levels

### Display ADARUN Parameters

You can view Adabas nucleus (ADARUN) parameters.

To view the parameters, select option D from the Session Monitoring menu.

Multiple screens are used for displaying parameters:

    14:03:49          ***** A D A B A S  BASIC  SERVICES *****          2014-04-30
    DBID 1955                  -  Display Parameters  -                 PACPD22
    NucID 1021

     -------------- Pools --------------  ------------- Queues ------------------
     Sort Area         (LS).. 19968       Command Queue          (NC) .. 20
     Int. User Buffer  (LU).. 400000      Hold Queue             (NH) .. 800
     Buffer Pool      (LBP).. 80896       User Queue             (NU) .. 200
     Format Pool      (LFP).. 150000      ------------ Time Windows -------------
     ISN List Table    (LI).. 360000      Transaction Time       (TT) .. 4858
     Seq. Cmd. Table   (LQ).. 20000       Max Transaction Time (MXTT) .. 3600
     Work Pool        (LWP).. 1500000     Nonactivity ACC-User (TNAA) .. 4858
     Attached Buffer  (NAB).. 100         Nonactivity ET-User  (TNAE) .. 4858
     Security Pool    (LCP).. 10000       Nonactivity EXU-User (TNAX) .. 4858
     UQ-DE Pool    (LDEUQP).. 50000       Max Nonactivity Time(MXTNA) .. 3600
     Err. Recovery (MSGBUF).. 36          Time Limit Sx-Cmds (TLSCMD) .. 300
                                          Max Time for Sx-Cmds(MXTSX) .. 3600
                                          Command Time           (CT) .. 3858
                                          SYNS60 Interval    (INTNAS) .. 3600

                                                                       Page 1 of 7
    PF1----- PF2------ PF3------ PF4------ PF6----- PF7----- PF8----- PF12-----
    Help     NextNuc   Exit      ABC List  Modify            +        Menu

    14:03:49          ***** A D A B A S  BASIC  SERVICES *****          2014-04-30
    DBID 1955                  -  Display Parameters  -                 PACPD22
    NucID 1021

    --------- Miscellaneous -----------     --------- Miscellaneous --------------
    Read only     (READONLY).. NO           LARGEPAGE ................. NO
    UTI only       (UTIONLY).. NO           V64BIT .................... NO
    OPEN required   (OPENRQ).. NO           SRLOG ..................... Upd
    Ignore DIB Entry(IGNDIB).. NO           LOGWARN ................... 0
    Local nucleus   (LOCAL) .. NO           SECUID .................... ALLOW
    Number of Threads  (NT) .. 25           INDEXCROSSCHECK ........... YES
    Non DE Search  (NONDES) .. YES          Print on refresh(REFSTPRT). YES
    Log AOS/DBS Upd.(AOSLOG).. NO           Number plog buffers ....... 1
    Batch Support   (BATCH) .. NO           Number work1 buffers ...... 1
    Data Protection Area(LP).. 1000         Event log buffer size ..... 1024
    Ignore Wrk Prt4(IGNDTP) .. NO
    WORK-Part-4 Area (LDTP) .. 0
    WORK-Part-2 Area(LWKP2) .. 158
    SVC                   (SVC) .. 249

                                                                       Page 2 of 7
    PF1----- PF2------ PF3------ PF4------ PF6----- PF7----- PF8----- PF12-----
    Help     NextNuc   Exit      ABC List  Modify   -        +        Menu

    14:03:49          ***** A D A B A S  BASIC  SERVICES *****          2014-04-30
    DBID 1955                  -  Display Parameters  -                 PACPD22
    NucID 1021

    --------- Space Warning ----------------
    ASSOSPACEWARN ..... 0
    DATASPACEWARN ..... 0

    --------- Auto Increase ------------------------------------------------
    AUTOINCASSOTHRESHOLD ..... 0          AUTOINCDATATHRESHOLD ..... 0
    AUTOINCASSOSIZE ... 0          CYL    AUTOINCDATASIZE ... 0          CYL
    AUTOINCASSOTOTAL .. 0          CYL    AUTOINCDATATOTAL .. 0          CYL

    --------- SMF --------------------------
    SMF ............... NO

                                                                       Page 3 of 7
    PF1----- PF2------ PF3------ PF4------ PF6----- PF7----- PF8----- PF12-----
    Help     NextNuc   Exit      ABC List  Modify   -        +        Menu

    14:03:49          ***** A D A B A S  BASIC  SERVICES *****          2014-04-30
    DBID 1955                  -  Display Parameters  -                 PACPD22
    NucID 1021

     ---- Command Logging ----      ------------ Command Logging --------------
     Command Logging .. YES         Log VOLSER info    (LOGVOLIO) .. NO
     LOGCB ............ NO          Max buffer size/cmd (CLOGMAX) .. 16384
     LOGFB ............ YES         Max buffer size/buf(CLOGBMAX) .. 4096
     LOGRB ............ YES         Log ABDX            (LOGABDX) .. NO
     LOGSB ............ NO          Log multifetch buffer (LOGMB) .. NO
     LOGVB ............ NO          Command log layout(CLOGLAYOUT).. 5
     LOGIB ............ NO
     LOGIO ............ NO
     LOGUX ............ NO
     LOGSIZE .......... 5064        ---------- Protection Logging -----------
     DUAL CLOG Size ... 675         PLOG required        (PLOGRQ) .. YES
     DUAL CLOG Dev. ... 3390        DUAL PLOG Size      (DUALPLS) .. 240
     NCLOG ............ 0           DUAL PLOG Device    (DUALPLD) .. 3390
                                    NPLOG .......................... 0

                                                                       Page 4 of 7
    PF1----- PF2------ PF3------ PF4------ PF6----- PF7----- PF8----- PF12-----
    Help     NextNuc   Exit      ABC List  Modify   -        +        Menu

    14:03:49          ***** A D A B A S  BASIC  SERVICES *****          2014-04-30
    DBID 1955                  -  Display Parameters  -                 PACPD22
    NucID 1021

    ------------ Large Pools -------------      --------- Other Services ---------
    Flush I/O Pool (LFIOP)  .. 80000            Triggers / Procedures (SPT) .. NO
                                                Delta Save Facility   (DSF) .. YES
                                                Cache Facility      (CACHE) .. NO
                                                Transaction Manager   (ATM) .. NO
    -------- User Specific Limits --------      TCP/IP Support      (TCPIP) .. NO
    Hold Queue Limit  (NISNHQ) .. 200           Ext. Error Recovery  (SMGT) .. YES
    CIDs per User      (NQCID) .. 40            2 Phase Commit Support(DTP) .. NO
    ISN per TBI Element(NSISN) .. 100
                                                Review:
    ------------ Buffer Pool -------------       Support  (REVIEW) .. LOCAL
    Bufferflush Dur.  (TFLUSH) .. 1
    Parallel LFIOP I/O (FMXIO) .. 1              Filter ............. YES
    Async. by Vol-Ser (ASYTVS) .. YES            Max bufsize cmd .... 16384
                                                 Max bufsize buf .... 5120

                                                                       Page 5 of 7
    PF1----- PF2------ PF3------ PF4------ PF6----- PF7----- PF8----- PF12-----
    Help     NextNuc   Exit      ABC List  Modify   -        +        Menu

    14:03:49          ***** A D A B A S  BASIC  SERVICES *****          2014-04-30
    DBID 1955                  -  Display Parameters  -                 PACPD22
    NucID 1021

    ----- Cluster/Parallel Services -------    ---- Cluster/Parallel Services ----
    Environment .......... Sysplex             MXMSG .................. 300
    ARM element name .....                     MXMSGWarn .............. 0
    Cache structure name . ADA_CACHE4          MXCANCEL ............... 300
    Lock structure name .. ADA_LOCK4           MXCANCELWarn ........... 75
    Sysplex group name ... WISPLEX             MXWtor ................. 0
    Cache type ........... DSP                 MXStatus ............... 15
    DIrratio ............. 4
    ELemratio ............ 1
    Redo Pool (LRDP) ..... 80000
    CLOGMRg .............. NO
    CLUCACHEUnchanged .... No
    CLULOCKSize .......... 0
    CLUCACHESize ......... 0

                                                                       Page 6 of 7
    PF1----- PF2------ PF3------ PF4------ PF6----- PF7----- PF8----- PF12-----
    Help     NextNuc   Exit      ABC List  Modify   -        +        Menu

    14:03:49          ***** A D A B A S  BASIC  SERVICES *****          2014-04-30
    DBID 1955                  -  Display Parameters  -                 PACPD22
    NucID 1021

    ---- Replication Parameters -------
    Replication .......... YES
    RPWARNPercent ........ 0
    RPWARNINCrement ...... 10
    RPWARNINTerval ....... 60
    RPWARNMessagelimit ... 5
    RPCONNECTCount ....... 0
    RPCONNECTInterval .... 0
    RPLSORT .............. YES
    LRPL ................. 100000

                                                                       Page 7 of 7
    PF1----- PF2------ PF3------ PF4------ PF6----- PF7----- PF8----- PF12-----
    Help     NextNuc   Exit      ABC List  Modify   -                 Menu

### Display Installed Products

Choose option I on the Session Monitoring menu and press ENTER to display a list of installed products.

    14:06:21          ***** A D A B A S  BASIC  SERVICES *****          2014-04-30
    DBid  1955             - Display Installed Products -               PACII02
    NucID 1021

       -------------------------- -----    ------------------------------- ----
       Cache Facility ........... NO       Extended Error Recovery ....... YES
       Delta Save Facility ...... YES      Recovery Aid .................. YES
       Cluster Services ......... YES      Stored Procedures & Triggers .. NO
       Parallel Services ........ NO       Two Phase Commit .............. NO
       Fastpath ................. NO       TCPIP support ................. NO
       Vista .................... NO       Event Replicator .............. YES
       Transaction Manager ...... NO
       SAF Security Interface ... NO
       Review ................... LOCAL
       Adabas Online System ..... YES

    Command ==>
    PF1----- PF2------ PF3------ PF4------ PF6----- PF7----- PF8----- PF12-----
    Help               Exit                                           Menu

This screen displays what is installed on the current selected Adabas.

### Display Hold Queue

Selecting Queue displays (option Q) from the Session Monitoring menu displays the following menu:

    14:07:11          ***** A D A B A S  BASIC  SERVICES *****          2014-04-30
                                 -  Queue Displays  -                   PACQ002

                           Code    Service
                           ----    ---------------------------
                            *      Display User Queue Elements
                            *      Display Command Queue
                            H      Display Hold Queue
                            ?      Help
                            .      Exit
                           ----    ---------------------------
       Code ............... _
       Max No. Elements ... 100
       Last Activity ...... 0         (elapsed time in seconds)
       Selection Criteria
         ET-ID (User-ID) .. ________  User Type ... ___
         Job Name ......... ________
         Terminal ID ...... ________
       Database ID ........ 1955      (WIS1955)             NucID .. 1021

    Command ==>
    PF1----- PF2------ PF3------ PF4------ PF6----- PF7----- PF8----- PF12-----
    Help     NextNuc   Exit      Clear UID                            Menu

Option H displays a list of the ISNs currently in hold status.

If the queue is currently empty, an appropriate message appears.

### Display System Status and Thread Usage

Selecting Resource utilization (option U) from the Session Monitoring menu invokes the Interval Utilization menu:

    14:08:04          ***** A D A B A S  BASIC  SERVICES *****          2014-04-30
                              -  Interval Utilization  -                PACU002

    Code  Service                           Code  Service
    ----  -------------------------------   ----  -------------------------------
     *    Command usage                      S    System status
     *    File usage                         T    Thread usage
     *    High watermarks (pools/queues)     *    I/Os by Volser
     *    Workpool (LWP) usage               *    WORK status
     *    Nucleus File Status                *    Display PPT table
     *    PLOG status
     ?    Help
     .    Exit
    ----  -------------------------------   ----  -------------------------------

            Code ......... _
            File Number .. 0
            Database ID .. 1955   (WIS1955)             NucID .. 1021

    Command ==>
    PF1----- PF2------ PF3------ PF4------ PF6----- PF7----- PF8----- PF12-----
    Help     NextNuc   Exit                                           Menu

Each option allows you to refresh ( PF4 ) the displayed values, a convenience for long-term monitoring of Adabas system functions.

#### System Status

System status (option S) displays I/O counts for the ASSO, DATA, WORK, and PLOG data sets; remote and local call distribution; and other current session status information.

    14:10:32          ***** A D A B A S  BASIC  SERVICES *****          2014-04-30
    DBID 1955                     -  System Status  -                   PACUS12
    NucID: 1021

     Physical    Reads          Writes                Call Distribution
            -----------------------------  ---------------------------------------
     ASSO         1,106             124    No. of HQEs active .........          0
     DATA         1,416              39    No. of UQEs in User Queue ..          1
     WORK             2             161    No. of CQEs waiting in CQ ..          0
     PLOG            15             120    No. of PLOG switches .......          0
     CLOG             9               6    No. of CLOGs ...............          2
                                           No. of PLOGs ...............          2
     PLOG protection blks .         119
     PLOG protection I/Os .         119    Format translations .....          45
     WORK1 protection blks.         161    Format overwrites .......           0
     WORK1 protection I/Os.         161    Auto-restarts ...........           2
                                           Throw-backs for ISN .....           0
     Logical reads ........      12,140    Throw-backs for Space....           0
     Buffer efficiency ....           4.8
                                                                      page 1 of 3

    PF1---- PF2---- PF3----- PF4----- PF6----- PF7----- PF8----- PF9----- PF12----
    Help            Exit     Refresh                    +        FullView Menu

    14:10:32          ***** A D A B A S  BASIC  SERVICES *****          2014-04-30
    DBID 1955                     -  System Status  -                   PACUS12
    NucID: 1021

             Call Distribution                          Commands
    ------------------------------------      -----------------------------
    User sessions ........          22        Remote ........           0
    Buffer flushes .......          39        Local .........       2,861
    Flush phases .........          39        Internal ......       2,824
    Blocks flushed .......         156        Operator ......           0
    Flush I/Os ...........         156        Total .........       5,685

           Flush Requests Returned                     Time Elapsed
    ------------------------------------      ----------------------------------
    Immediately ..........           0        Duration .... 1 day, 17:36:50
    After logical flush ..           0        Wait-time ... 1 day, 17:36:44
    After entire flush ...          41        CPU time .... 0 day, 00:00:17

                                                                      page 2 of 3

    PF1---- PF2---- PF3----- PF4----- PF6----- PF7----- PF8----- PF9----- PF12----
    Help            Exit     Refresh           -        +        FullView Menu

    14:10:32          ***** A D A B A S  BASIC  SERVICES *****          2014-04-30
    DBID 1955                     -  System Status  -                   PACUS12
    NucID: 1021

                                  Nucleus Status Flags
                          ------------------------------------
                          Adabas operation normal

                                                                      page 3 of 3

    PF1---- PF2---- PF3----- PF4----- PF6----- PF7----- PF8----- PF9----- PF12----
    Help            Exit     Refresh           -                 FullView Menu

#### Thread Usage

Thread usage (option T) displays a table of all defined Adabas threads, the status of each, the command type currently in process in each active thread, and the number of commands processed by each thread in the current session.

    14:12:25          ***** A D A B A S  BASIC  SERVICES *****          2014-04-30
    DBID 1955                     -  Thread Usage  -                    PACUT12
    NucID 1021
    Nr. I Thread Status     I Command Type    I Wait Event        I Nr. CMDs
    -----------------------------------------------------------------------------
      1 I Active            I Simple Cmd.     I                   I       5,707
      2 I Not active        I                 I                   I          10
      3 I Not active        I                 I                   I           0
      4 I Not active        I                 I                   I           0
      5 I Not active        I                 I                   I           0
      6 I Not active        I                 I                   I           0
      7 I Not active        I                 I                   I           0
      8 I Not active        I                 I                   I           0
      9 I Not active        I                 I                   I           0
     10 I Not active        I                 I                   I           0
     11 I Not active        I                 I                   I           0
     12 I Not active        I                 I                   I           0
     13 I Not active        I                 I                   I           0
     14 I Not active        I                 I                   I           0
     15 I Not active        I                 I                   I           0

    PF1----- PF2------ PF3------ PF4------ PF6----- PF7----- PF9----- PF12-----
    Help               Exit      Refresh                     Fullview Menu

### Display Maintenance Levels

Selecting Display maintenance levels (option Z) from the Session Monitoring menu displays information about the Adabas nucleus modules:

    14:13:25          ***** A D A B A S  BASIC  SERVICES *****          2014-04-30
    DBID 1955             -  Display Maintenance Levels  -              PACZ002
    NucID .. 1021

     Select Module Name:  ________
     -----------------------------------------------------------------------------
       ADARUN   RUNMVS   Date 2013-09-17, Version 8.3, SP 1
                RUNIND   Date 2014-03-21, Version 8.3, SP 1
       ADANCX            Date 2014-04-21, Version 8.3, SP 1
       ADAXCF            Date 2012-04-19, Version 8.3, SP 1
       ADAXEC            Date 2012-10-11, Version 8.3, SP 1
       ADAXEL            Date 2013-10-21, Version 8.3, SP 1
       ADACLU            Date 2014-04-15, Version 8.3, SP 1
       ADAMXI            Date 2013-12-10, Version 8.3, SP 1
       ADAMIM            Date 2014-03-21, Version 8.3, SP 1
       ADARVU            Date 2014-03-21, Version 8.3, SP 1
       ADACLX            Date 2013-12-30, Version 8.3, SP 1
       ADARMT            Date 2014-03-19, Version 8.3, SP 1

    Command ===>
    PF1----- PF2------ PF3------ PF4------ PF6----- PF7----- PF8----- PF12-----
    Help               Exit                --       -        +        Menu

Maintenance levels for each module are displayed. Any ZAPs that are applied to the module are also listed.

The list of modules can be limited by entering a specific module name in the Select Module Name field at the top of the screen. A starting value may also be used. For example, specifying ADANC3 displays information for the ADANC3 module only. Specifying ADANC* lists all modules with names that begin with ADANC.

## List Checkpoints

Selecting Checkpoint maintenance (option C) from the Main Menu invokes the Checkpoint Maintenance menu:

    14:14:45          ***** A D A B A S  BASIC  SERVICES *****          2014-04-30
                             -  Checkpoint Maintenance  -               PCP0002

                            Code    Service
                            ----    -----------------------
                             C      List checkpoints
                             *      Delete checkpoints
                             ?      Help
                             .      Exit
                            ----    -----------------------

          Code ............. _
          Date(YYYY-MM-DD) . 0000-00-00
          Ext. CP-list ..... N
          Checkpoint Name .. ALL
          Database ID ...... 1955   (WIS1955)

    Command ==>
    PF1----- PF2------ PF3------ PF4------ PF6----- PF7----- PF8----- PF12-----
    Help               Exit                                           Menu

Option C lists checkpoints currently in the checkpoint file.

The result can be either a basic or an extended list, depending on the setting of the External CP-list field, which can be used to override the CPEXLIST operating control parameter.

You can start the list of checkpoints on a particular day by entering the date in the Date field in exactly the format shown.

You can specify the database for which the checkpoint list is to be written.

You can restrict the list to a particular type of checkpoint by changing the ALL designation in the Checkpoint Type field to one of the following:

Type | Description
--- | ---
SYNC | nucleus initialization
SYNF | user open EXF
SYNP | utility, without nucleus
SYNS | ADARES
SYNV | volume ID change
SYNX | utility
SYN1 | ADASAV DB begin
SYN2 | ADASAV DB begin
SYN4 | ADASAV file begin
SYN5 | ADASAV file begin

For more information about checkpoint types, see ADAREP in the Adabas Utilities documentation .

The following screen displays a normal checkpoint list:

    14:15:13          ***** A D A B A S  BASIC  SERVICES *****       2014-04-30
    DBID 1955                     - List Checkpoints -                  PCPC012

      CP   CP     Date      Time      PLOG     Block      Vol/Ser   User Job Name
     Name Type                       Number    Number      Number   Type
     ---- ---- ---------- --------   ------  ----------   --------  ---- --------
     SYNC  01  2010-12-14 11:29:34                                       USAWISCR
     SYNS  5B  2010-12-14 11:29:34                                  EXU  ADAEND
     SYNP  07  2010-12-14 11:30:19        2           1   DUAL           USAWISRE
     SYNC  01  2010-12-14 11:30:45        2           2   DUAL           USAWISRP
     SYNS  61  2010-12-14 11:32:40        2         417   DUAL           ADABAS
     SYNS  5B  2010-12-14 11:42:43        2       29341   DUAL      EXU  ADAEND
     SYNC  01  2010-12-14 11:43:26        3           1   DUAL           USAWISRP
     SYNS  60  2010-12-14 16:05:31        3        1524   DUAL           ADABAS
     SYNS  60  2010-12-15 10:08:02        3        1525   DUAL           ADABAS
     SYNS  60  2010-12-15 11:53:37        3        1526   DUAL           ADABAS
     SYNS  60  2010-12-15 12:56:37        3        1527   DUAL           ADABAS
     SYNS  60  2010-12-15 13:59:37        3        1528   DUAL           ADABAS
     SYNS  60  2010-12-15 15:02:37        3        1529   DUAL           ADABAS
     SYNS  60  2010-12-15 16:05:37        3        1530   DUAL           ADABAS
     SYNS  60  2010-12-15 17:08:42        3        1531   DUAL           ADABAS
    PF1----- PF2------ PF3------ PF4------ PF6----- PF7 ----- PF8----- PF12-----
    Help               Exit                Top      -        +        Menu

This screen illustrates an extended checkpoint list providing additional information about each checkpoint:

    18:58:21          ***** A D A B A S  BASIC  SERVICES *****       2009-08-13
    DBID 1955                     - List Checkpoints -                  PCPC012

      CP   CP     Date      Time      PLOG     Block      Vol/Ser   User Job Name
     Name Type                       Number    Number      Number   Type
     ---- ---- ---------- --------   ------  ----------   --------  ---- --------
     SYNP  30  2009-02-17 19:07:59                                       USAWISN0
          LOAD                FNR= 1
     SYNP  30  2009-02-17 19:07:59                                       USAWISN0
          LOAD                FNR= 2
     SYNP  30  2009-02-17 19:08:00                                       USAWISN0
          LOAD                FNR= 3
     SYNP  30  2009-02-17 19:08:01                                       USAWISN0
          LOAD                FNR= 6
     SYNP  30  2009-02-17 19:08:01                                       USAWISN0
          LOAD                FNR= 7
     SYNC  01  2009-02-17 19:08:02                                       USAWISN0
          SESSION OPEN        IGNDIB = N , FORCE = N
     SYNS  5B  2009-02-17 19:08:02                                  EXU  ADAEND
          REFRESH STATS
     SYNP  30  2009-02-17 19:17:04        2           1   DUAL           USAWISTA
    PF1----- PF2------ PF3------ PF4------ PF6----- PF7 ----- PF8----- PF12-----
    Help               Exit                Top      -        +        Menu

## File Maintenance

Selecting option F from the Main Menu invokes the File Maintenance menu:

    14:16:42          ***** A D A B A S  BASIC  SERVICES *****          2014-04-30
                                -  File Maintenance  -                  PFL0004

    Code  Service                          Code  Service
    ----  -------------------------------- ----  --------------------------------
      C   Define/modify FDT                  *   Modify file parameters
      *   Release descriptor                 *   Reorder file online
      *   Delete existing file               *   Refresh file to empty status
      *   Define new file                    *   Allocate/deallocate file space
      *   Logically delete/undel descriptr   *   Maintain expanded files
      ?   Help                               .   Exit
    ----  -------------------------------- ----  --------------------------------
           Code ......... _
           File No ...... 0      Descriptor Name .. __
           Database ID .. 1955   (WIS1955)

    Command ==>
    PF1----- PF2------ PF3------ PF4------ PF6----- PF7----- PF8----- PF12-----
    Help               Exit                                           Menu

From the File Maintenance menu, option C displays the FDT/SDT Definition / Modification menu:

    14:18:02          ***** A D A B A S  BASIC  SERVICES *****          2014-04-30
                       -  FDT/SDT Definition / Modification  -          PFLC004

      Code  Service                          Code  Service
      ----  ----------------------------     ----  ----------------------------
        *   Add new field(s)                   *   Online invert
        *   Change field parameters            *   Define/add SDT
        D   Define new FDT                     *   Release UQ from descriptor
        *   Delete field from FDT              ?   Help
        *   Undelete field from FDT            .   Exit
      ----  ----------------------------     ----  ----------------------------
            Code ......... _
            File No. .....
            Field Name ... __
            File Password.
            Database ID .. 1955   (WIS1955)

    Command ==>
    PF1----- PF2------ PF3------ PF4------ PF6----- PF7----- PF8----- PF12-----
    Help     Def. File Exit                                           Menu

From the FDT/SDT Definition / Modification menu, option D displays the Define FDT screen, which can be used to define a new FDT for a new file:

    14:19:27          ***** A D A B A S  BASIC  SERVICES *****          2014-04-30
    DBID 1955                       -  Define FDT  -                    PFLCD12

    File Number .... 55                            New FDT ... Y

    Enter Field Description(s) ::

    I Levl I Name I Length I Format I Options        I Date/time and System fields
    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   _    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     Def SDT   Exit      Def File  Disp FDT                   Menu

FDTs for existing files cannot be redefined with this option.

This function corresponds to the Adabas utility function ADACMP COMPRESS.

## Database Maintenance

Selecting option M from the Main Menu invokes the Database Maintenance menu:

    14:20:01          ***** A D A B A S  BASIC  SERVICES *****          2014-04-30
                              -  Database Maintenance  -                PDM0002

                          Code    Service
                          ----    ----------------------------
                           *      Add new dataset to ASSO/DATA
                           *      Increase/decrease ASSO/DATA
                           *      List/reset DIB block entries
                           *      Recover unused space
                           *      Uncouple two ADABAS files
                           ?      Help
                           .      Exit
                          ----    ----------------------------

           Code .......... _
           File No. ...... 55
           Coupled File .. 0
           Database ID ... 1955   (WIS1955)

    Command ==>
    PF1----- PF2------ PF3------ PF4------ PF6----- PF7----- PF8----- PF12-----
    Help               Exit                                           Menu

None of the Database Maintenance functions are active for the demo version.

## System Operator Command Functions

Selecting Session opercoms (option O) from the Main Menu displays the following menu:

    19:36:22          ***** A D A B A S  BASIC  SERVICES *****          2009-08-18
                                 -  Session Opercoms  -                 PACI002

     Code  Service                           Code  Service
     ----  ------------------------------    ----  ------------------------------
      *    Allocate/Deallocate CLOG/PLOG      S    Stop user(s)
      *    Issue reactivate CLOG command      T    Termination Commands
      E    Extended Error Recovery            *    Manage Online Utilities
      *    Force CLOG or PLOG switch          *    User Table Maintenance
      L    Lock or unlock files               *    Replicator Management
      *    Reset ONLINE-DUMP-Status
      .    Exit                               ?    Help
     ----  ------------------------------    ----  ------------------------------
           Code ........... _
           Userid(ETID) ... ________
           CLOG/PLOG Ind .. _
           Database ID .... 1955   (WIS1955)

    Command ==>
    PF1----- PF2------ PF3------ PF4------ PF6----- PF7----- PF8----- PF12-----
    Help               Exit                                           Menu

    14:44:58          ***** A D A B A S  BASIC  SERVICES *****          2014-04-30
                                 -  Session Opercoms  -                 PACI002

     Code  Service                           Code  Service
     ----  ------------------------------    ----  ------------------------------
      *    Allocate/Deallocate CLOG/PLOG      S    Stop user(s)
      *    Issue reactivate CLOG command      T    Termination Commands
      E    Extended Error Recovery            *    Manage Online Utilities
      *    Force CLOG or PLOG switch          *    User Table Maintenance
      L    Lock or unlock files               *    Replicator Management
      *    Reset ONLINE-DUMP-Status           *    Cluster operator commands
      .    Exit                               ?    Help
     ----  ------------------------------    ----  ------------------------------
           Code ........... _
           Userid(ETID) ... ________
           CLOG/PLOG Ind .. _       Global.. _
           Database ID .... 1955   (WIS1955)             NucID .. 1021

    Command ==>
    PF1----- PF2------ PF3------ PF4------ PF6----- PF7----- PF8----- PF12-----
    Help               Exit                                           Menu

The following functions are available to the AOS demo version:

Code | Function
--- | ---
E | Add or delete PIN modules used by the extended error recovery facilities; display, activate or deactivate current PIN routines
L | Display locked files
S | Stop a specific user, all users of a specific file or job, or all inactive users
T | Terminate a session normally (ADAEND)

This section covers the following topics:

- Extended Error Recovery

- Display Locked Files

- Stop User(s)

- Terminate a Session Normally (ADAEND)

### Extended Error Recovery

Selecting option E (extended error recovery) from the Session Opercoms menu displays the Extended Error Recovery menu:

    14:45:54          ***** A D A B A S  BASIC  SERVICES *****          2014-04-30
                              -  Extended Error Recovery  -             PACIE02

                       Code    Service
                       ----    ----------------------------------
                        *      Display message buffer
                        *      Display/modify environment
                        *      Display/modify Exit routines
                        M      Add/Delete PIN modules
                        P      Display/modify PIN routines
                        *      Refresh threshold and alert exits
                        *      SNAP a nucleus dump
                        ?      Help
                        .      Exit
                       ----    ----------------------------------

       Code ........... _
       Start Address .. ________   End Address ... ________
       Database ID .... 1955   (WIS1955)              NUCID .. 1021

    Command ==>
    PF1----- PF2------ PF3------ PF4------ PF6----- PF7----- PF8----- PF12-----
    Help               Exit                                           Menu

From this menu you can

- add or delete PIN modules;

- display, activate, or deactivate specific PIN routines.

#### Add / Delete PIN Modules

Selecting option M (add/delete PIN modules) from the Extended Error Recovery menu displays a list of currently available PIN modules:

    14:47:40          ***** A D A B A S  BASIC  SERVICES *****          2014-04-30
    DBID 1955                -  Add/Delete PIN Modules  -               PACIEM2
    NUCID .. 1021

    Mark entries with 'A' to Add or 'D' to Delete:

              M   Module    Description                      Message
              -   --------  ------------------------------   -------
              _   ADAMXY    Standard Nucleus PIN Routines
                  PINAAF    SAF Security
                  PINAFP    Adabas Fastpath
                  PINATM    Adabas Transaction Manager
                  PINAVI    Adabas Vista
              _   PINRSP    Adabas Response Code Handler
              _   PINUES    Universal Encoding Support

    PF1----- PF2------ PF3------ PF4------ PF6----- PF7----- PF8----- PF12-----
    Help               Exit                                           Menu

To load a PIN module into memory, enter `A' in the M column next to the module name.

This command is successful only if the exit module exists in a library accessible to the Adabas nucleus.

To remove a PIN module from memory, enter a `D' in the M column next to the module name.

When deleting a PIN module from memory, all related PIN routines are also removed.

These functions are the same as the extended error recovery operator commands

    SMGT,{ADDPIN | DELPIN}=module-name

#### Display/Modify PIN Routines

Selecting option P (display/modify PIN routines) from the Extended Error Recovery menu displays a list of PINs currently loaded in memory:

    14:48:34          ***** A D A B A S  BASIC  SERVICES *****          2014-04-30
    DBID 1955               -  List/Modify PIN Routines  -              PACIEP2
    NUCID .. 1021
    Mark entries with 'A' Activate, or 'D' Deactivate:         Total Pins: 267

     M  Condition        Error Location        Status  Uses  Module     Message
     -  --------- ---------------------------- ------- ---- --------  -----------
     _  000C1000  All Locations                Active     0   ADAMXY
     _  000C2000  All Locations                Active     0   ADAMXY
     _  000C3000  All Locations                Active     0   ADAMXY
     _  000C4000  All Locations                Active     0   ADAMXY
     _  000C5000  All Locations                Active     0   ADAMXY
     _  000C6000  All Locations                Active     0   ADAMXY
     _  000C7000  All Locations                Active     0   ADAMXY
     _  000C8000  All Locations                Active     0   ADAMXY
     _  000C9000  All Locations                Active     0   ADAMXY
     _  000CB000  All Locations                Active     0   ADAMXY
     _  000CF000  All Locations                Active     0   ADAMXY
     _  00047000  All Locations                Active     0   ADAMXY

    PF1----- PF2------ PF3------ PF4------ PF6----- PF7----- PF8----- PF12-----
    Help               Exit      Refr       --       -        +       Menu

For all PIN routines on the list, the screen indicates the conditions that cause them to be executed, the current status, the number of times they have been used, and the module in which they are located.

To change the status of the PINs from this screen, enter in the M column next to the PIN number

A | to activate a PIN
D | to deactivate a PIN

After changes have been made, use PF4 to refresh the screen.

These functions are the same as the extended error recovery operator commands

    SMGT,DISPLAY=PINS
      SMGT,{ACTPIN | DEACTPIN}=pin-number

### Display Locked Files

Selecting option L from the Session Opercoms menu displays the following:

    14:49:15          ***** A D A B A S  BASIC  SERVICES *****          2014-04-30
                              -  Lock / Unlock Files  -                 PACIL02

                      Code    Service
                      ----    ----------------------------------
                       D      Display locked files
                       *      Lock file for all users
                       *      Advance lock file
                       *      Lock file except for UTI/EXF users
                       *      Unlock file from general lock
                       *      Release an advance lock
                       *      Unlock file from UTI/EXF lock
                       ?      Help
                       .      Exit
                      ----    -----------------------------------
        Code ......... _
        File Number .. 55
        UTI/EXF Ind .. U
        Database ID .. 1955   (WIS1955)

    Command ==>
    PF1----- PF2------ PF3------ PF4------ PF6----- PF7----- PF8----- PF12-----
    Help               Exit                                           Menu

Option D from this menu displays the Display Locked Files screen:

    14:49:15          ***** A D A B A S  BASIC  SERVICES *****          2014-04-30
    DBID 1955                 -  Display Locked Files  -                PACID02

     Mark entries with 'U' to unlock:
     M  Fnr.   Lock Status                  M  Fnr.   Lock Status
     -  -----  -------------------------    -  -----  -------------------------
     _  1      Locked for ALL users
     _  35     Locked except for UTI
     _  50     Locked except for EXU/EXF
     _  55     Locked for ALL users
     _  60     Locked for ALL users

    PF1----- PF2------ PF3------ PF4------ PF6----- PF7----- PF8----- PF12-----
    Help               Exit                 --       -        +       Menu

### Stop User(s)

Selecting option S (stop users) from the Session Opercoms menu displays the Stop Users menu:

    14:50:30          ***** A D A B A S  BASIC  SERVICES *****          2014-04-30
                                   -  Stop Users  -                     PACIS02

                          Code  Service
                          ----  -----------------------
                           *    Stop users using file
                           *    Stop inactive users
                           *    Stop users by jobname
                           *    Stop a selected user
                           ?    Help
                           .    Exit
                          ----  -----------------------
        Code ............. _
        File Number ...... 55___
        Last Activity .... ________ (elapsed time in seconds)
        Job Name ......... ________
        Purge UQE(s) ..... N
        Selected Userid ..
        Database ID ...... 1955     (WIS1955)             NUCID .. 1021

    Command ==>
    PF1----- PF2------ PF3------ PF4------ PF6----- PF7----- PF8----- PF12-----

None of the Stop Users functions are active for the demo version.

### Terminate a Session Normally (ADAEND)

Selecting option T from the Session Opercoms menu invokes the Session Termination menu from which you can terminate a session normally (ADAEND).

    14:51:06          ***** A D A B A S  BASIC  SERVICES *****          2014-04-30
                               -  Session Termination  -                PACT002

                        Code    Service
                        ----    -----------------------------------
                         A      Normal session termination (ADAEND)
                         *      Cancel session immediately (CANCEL)
                         *      Stop session               (HALT)
                         ?      Help
                         .      Exit
                        ----    -----------------------------------
          Code ......... _
          Database ID .. 1955   (WIS1955)             NUCID .. 1021
                                                      Global.. _

           Current nr. of users in User Queue ... 1
           Nr. of users with open transactions .. 0
           Nr. of active nucs in Plex cluster ... 1

    Command ==>
    PF1----- PF2------ PF3------ PF4------ PF6----- PF7----- PF8----- PF12-----
    Help               Exit                                           Menu

You are prompted to confirm your termination request before the action is taken.

## 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:51:51          ***** A D A B A S  BASIC  SERVICES *****          2014-04-30
                                 -  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
                       *      Display used storage (DSPACE)
                       ?      Help
                       .      Exit
                      ----    -------------------------------------
        Code ......... _
        File No ...... 55____ 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:

Option | 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 section covers the following topics:

- Display Files

- Display General Database Layout

### 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:

     14:53:05          ***** A D A B A S  BASIC  SERVICES *****          2014-04-30
     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      25281      26287  1  1  1  1 NNNSNNN  2 99
       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.

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:

  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.

#### 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:

     14:53:56          ***** A D A B A S  BASIC  SERVICES *****       2014-04-30
     DBID 1955                   - Display File Layout -                 PDRF043
      ****************
      *  File 11     *   NAT-SYSTEM
      ****************

      Records loaded ..... 88764         Date loaded .......... 2009-02-17 19:17:04
      TOP ISN ............ 99317         Date of last update .. 2014-04-28 16:33:27
      Max ISN expected ... 100063        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 .. 980806        RPLUPDATEONLY. No
      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
      Blk per DS Extent .. 0             Logged DSF Changes ... DS AC Index
      Blk per UI Extent .. 0             Total Changed Blks ... 33976
      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

     14:54:40          ***** A D A B A S  BASIC  SERVICES *****       2014-04-30
     DBID 1955                   - Display File Layout -                 PDRF043
      ****************                                                   Page 2
      *  File 11     *   NAT-SYSTEM
      ****************

      Last format AC ISN .. 100063
      File readonly mode .. No           Date FDT modified .... 1949-12-31 23:59:59
      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

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:

     14:55:02          ***** A D A B A S  BASIC  SERVICES *****       2014-04-30
     DBID 1955                  - Display File Layout -                  PDRF052
     File 11

        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      118        0 I       5493 -       5610 I        0        0
    ASSOI 3390 UII       50        0 I       7313 -       7362 I       35        0
    ASSOI 3390 NII     1702        6 I       5611 -       7312 I      814        3
        I        I                   I                         I
    DATAI 3390 DSI    44782      298 I        382 -      45163 I    11827       78

     PF1----- PF2------ PF3------ PF4------ PF6----- PF7----- PF8----- PF12-----
     Help               Exit      Refresh                              Menu

### Display General Database Layout

Option G displays general database information on the Display General DB-Layout screen:

    14:55:29          ***** A D A B A S  BASIC  SERVICES *****       2014-04-30
    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 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:

     14:55:54         *****  A D A B A S   BASIC  SERVICES  *****       2014-04-30
       DBID 1955               - 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:

    14:55:54          ***** A D A B A S  BASIC  SERVICES *****       2014-04-30
    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

### On this page

- Overview
- Main Menu Functions
- Session Monitoring
- List Checkpoints
- File Maintenance
- Database Maintenance
- System Operator Command Functions
- Database Report