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:

graphics/aos_demo.png

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

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:

graphics/aos_demo_ovw.png

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

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

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

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 (adddelete 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

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