Current Activity Displays

This section describes how to obtain and use the buffer statistics available for the active Adabas Fastpath buffer.


Current Activity Displays

Active Fastpath buffers can be monitored and controlled by selecting option code 2 on the Online Services main menu or by entering the command 2 on the command line.

The Session Monitoring menu is then displayed.

13:34:17     ***** A D A B A S   FASTPATH SERVICES 8.2.2 *****      2018-03-04
 Run-mode: 17004              -  Current Activity Displays  -        F12000M1  
                                                                               
                                                                               
                  Code   Service                                               
                  ----   -----------------------------                         
                   1     Buffer Information                                    
                   2     Database and File Information                         
                   3     Optimized Job Information                             
                   4     System Job Information                                
                   .     Exit                                                  
                  ----   -----------------------------                         
          Code ..: _                                                           
                                                                               
      Perspective: 17004 A8P17004                                              
           Status: Active                                                      
                   Started Mar  4,2018 at 13:33                                
                                                                               
                                                                               
                                                                               
                                                                               
 Command ==>                                                                   
                                                                               
                                                                               
                                                                               
Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
      Help        Exit                                                  Menu

The following fields are provided:

Field Description
Run-mode The FASTABM/System Coordinator Node ID to which this job is connected or the following text that explains why the job is not currently connected.

Excluded: Job parameter is not defined.
No connection: Client is unable to connect to the ABM.
ENQ-J failure: An identical job is already connected.
No daemon: The local daemon is not active.
ENQ-B failure: Buffer is unavailable (no buffer enq).
Missing: A component is missing.
Invalid: A component is bad.
Error: A problem with the parameters.
Disconnecting: The linker has stopped.

Provided that the local job has at some point been connected to a buffer then its statistics for its current activity will be recorded.

When the local job is connected to a buffer then its statistics for its current activity will be included in the Optimized Job Details.

But if the local job loses its connection then its statistics for its current activity will be included in the Local Job Statistics accessed via the Special Services. If the local job regains its connection then it will resume recording its statistics for its current activity in the Optimized Job Details.

Code Option code. The following options are available:

1: display buffer information
2: display database and file information
3: display optimized job information
4: display system job information

Perspective The Node ID and Job Name for the buffer being displayed

Note:
You can display buffer information for a different Node ID by entering the corresponding Node ID in this field.

Note:
You can enter a Node ID and press Enter without selecting a code to check the validity of the node.

Status Indicates whether or not the buffer is active and when it was last started.

Buffer Information

Selecting option code 1 on the Current Activity Displays screen invokes the General Information screen.

Note:
You can also access this screen by entering 2.1 on the command line.

 11:09:26     ***** A D A B A S   FASTPATH SERVICES 8.2.2 *****      2018-02-02
 Run-mode: 17004             -  General Information  -                 F12100MA
                                                                               
   Name: A8P17004                              SVC:  254  DB:  17004           
   Dataspace: #DSPNAME                         Buffer Status : Active          
   Started:   Feb  2,2018   at: 11:03          Ave Memory Val:                 
   Address:   00001000 Size(k): 1023           Session Number: 2828            
                                                                               
 ------------------------------ Buffer Statistics -----------------------------
                                                                               
    Access Type               Attempts  (69%)    <----------Successes  (72%)   
                                                                               
    Read-ahead:                  1,365  (21%)                     954  (69%)   
    Direct:                      2,454  (39%)                   1,671  (68%)   
    RCs:                           591   (9%)                     591  (24%)   
    Others:                      1,821  (31%)                                  
                                                                               
    Total:                       6,231 (100%)                   3,216  (51%)   
 ------------------------------------------------------------------------------
                                                                               
                                                                               
 Command ==>                                                                   
                                                                               
                                                                               
                                                                               
Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
      Help        Exit  Refr  Serv  Excl              Parm  Zero  Node  Menu

The first section of this screen provides general information for the buffer. The following information is provided:

Field Description
Name The buffer name.
SVC The Adabas SVC used for this buffer.
DB The Adabas database for which this buffer is used to provide optimization.
Dataspace The name of the dataspace when a dataspace cache is used.
Buffer Status Indicates whether or not the buffer is currently active.
Started The time at which the buffer was last started.
Ave Memory Val ... Session Number These fields are reserved for Software AG use.

The next section provides the buffer statistics. The following information is provided:

Field Description
Access Type

Attempts: the percentage of optimization attempts (optimization attempts divided by total number of commands).
Successes: the percentage of successful optimization attempts (successful optimization attempts divided by number of optimization attempts).

Read-Ahead

Attempts: the number of read-ahead optimization attempts, and the attempt percentage (read-ahead optimization attempts divided by total number of commands).
Successes: the number of successful read-ahead optimization attempts, and the percentage of successful attempts (successful read-ahead optimization attempts divided by read-ahead optimization attempts).

Direct

Attempts: the number of direct access optimization attempts, and the attempt percentage (direct access optimization attempts divided by total number of commands).
Successes: the number of successful direct access optimization attempts, and the percentage of successful attempts (successful direct access optimization attempts divided by direct access optimization attempts).

RCs

Attempts: the number of RC commands that are eligible for optimization. These are RC commands that immediately follow an optimized direct-access command (without any intervening "next" commands).
Successes: the number of successful RC optimization attempts. All of the attempts are always successful, but showing a success percentage of 100% gives no useful information; instead it is shown as a percentage of Direct Access attempts.
This indicates the relative savings in the number of cursors maintained by Adabas. The higher this percentage, the fewer the number of cursors.

Excluded

Attempts: the number of commands which were excluded from optimization, and percentage (number of excluded commands divided by total number of commands).

Note:
For more information on excluded attempts, use PF6.

Total

Attempts: the total number of commands encountered by Adabas Fastpath.
Successes: the total number of successful optimization attempts, and the percentage of successful attempts (successful optimization attempts divided by total number of commands).

Pressing PF6 from any of the buffer information screens displays the Excluded Command Analysis screen:

 11:14:36     ***** A D A B A S   FASTPATH SERVICES 8.2.2 *****      2018-02-02
 Run-mode: 17004             -  Excluded Command Analysis  -           F12100ME
                             Buffer: A8P17004 Node Id: 17004                   
                                                                               
     Statistics for commands that have optimization potential but were         
     unable to be optimized:                                                   
                                                                               
     C     Description                                      Count              
     _     Unsuitable command type:                            10              
     _     Disqualified:                                     1034              
     _     Optimization was disabled:                           0              
     _     Multi-fetch was already set:                         0              
     _     Command details exceed Set-id limit:                 0              
     _     Record Buffer exceeds the limit:                     0              
                                                                               
     Mark (above) to display further information about any exclusion.          
                                                                               
                                                                               
                                                                               
                                                                               
                                                                               
 Command ==>                                                                   
                                                                               
                                                                               
                                                                               
Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
      Help        Exit  Refr  Serv        Gen         Parm  Zero  Node  Menu

This screen displays the following information:

Information Description
Excluded - Reasons The total number of commands excluded from optimization for the listed reasons. For more information, see Excluded Commands.

Selection of an exclusion reason will provide information about that exclusion.

Note:
This same analysis can be displayed for jobs, databases, and files.

Pressing PF9 from any of the buffer information screens invokes the General Parameters screen:

Parameter Display

18:31:41  ***** A D A B A S   FASTPATH SERVICES 8.2.2        *****  2018-11-21
Run-mode: 17004             -  General Parameters  -                  F12100MF
                 Buffer: Global A8P17004 Node ID: 17004                       
                                      Initial                      Commands   
Main Parameters           Value       Allocation     Peak Usage    Ignored    
Size(k)..Min: 1023         1024           1023               24%              
Maximum Jobs:                12                               1             0 
RB Length Limit:           2048                                             0 
Set Length Limit:          1024                                             0 
Other------------------------------------------------------------------------ 
Fast cache attempts:        32         Fast set create attempts:   25         
Coherence Limit (per sec):  1          Suspension Period (mins):   10         
Default pacing rate:        10         Set Concurrency:            2          
Freespace Index Entries:    512        Average Item Size:          256        
                                       Async coherence messages:   Y          
Log every n minutes:        60         Keep for n days:            30         
Restart every n Hrs:        0          Restart Time:               24:00      
Direct Access:              ON         Read-ahead Processing:      ON         
FIND       SX/L1:           ON         READ LOGICAL  L3:           ON         
READ PHYSICAL L2:           ON         HISTOGRAM     L9:           ON         
                                                                              
                                                                              
Command ==>  ______________________________                                   

For description and use of these parameters, see section Adabas Fastpath Parameters.

The following PF keys are available throughout the series of buffer information screens:

PF Key Name Function
PF4 Refr Refreshes the statistics
PF5 Serv Invokes the function Asynchronous Buffer Services
PF5 Parms Displays the file parameters for this buffer
PF6 Excl Displays the Excluded Command Analysis screen
PF6 Look Invokes AFPLOOK
PF7 Gen Reverts to the General Information screen
PF9 Parm Displays the General Parameters screen
PF9 More Displays the next file or job detail display
PF10 Cntl Displays details of the master control set for the file
PF10 Conc Displays set concurrency information
PF10 SysJ Toggles from the User Job Summary to the System Job Summary screen
PF10 UserJ Toggles from the System Job Summary to the User Job Summary screen
PF10 Zero Resets the display counts to zero and automatically refreshes
PF11 Node Displays the Buffer Statistics menu

Database and File Information

Selecting option code 2 on the Current Activity Displays screen, invokes the Database Summary screen.

Note:
You can also access this screen by entering 2.2 on the command line.

For each database, a summary of activity is displayed as shown on the following example screen:

13:10:07     ***** A D A B A S   FASTPATH SERVICES 8.2.2 *****      2018-10-22
 Run-mode: 17004             Databases from A8P17004 :  17004        F12200MA  
                                                                               
 Buffer Session: 113          Started: Oct 22,2018  12:46   Size(k): 1023      
                                                                               
  C   DB SVC      Attempts           Optimized       Set Usage(k) Status       
 _ 17003 254          1391                 823           34       Optimizing   
 _ 17015 254                                                      DB Down      
                                                                               
                                                                               
                                                                               
                                                                               
                                                                               
                                                                               
                                                                               
                                                                               
                                                                               
                                                                               
   Totals:            1391  100%           823  100%     34  100%              
 Mark with F(ile),D(etail),I(nformation),S(ervices),Z(aps)                     
                                                                               
 Command ==>                                                                   
                                                                               
                                                                               
                                                                               
Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
      Help        Exit  Refr                                      Node  Menu  

The following information is provided on this screen:

Field Description
Buffer Session The buffer session number.
Started The time at which the buffer was last started.
Size The memory allocation for the buffer.
C Option code. The following options are available:

d: display detailed database information
f: display file summary information
s: perform database service (stop/start optimization).

DB The Adabas database.
SVC The Adabas SVC.
Attempts The total number of optimization attempts.
Optimized The total number of successful optimization attempts.
Set Usage The total amount of memory allocated for all the files defined for this database.
Status

The status of the database from the viewpoint of the Fastpath component running in System Coordinator daemon.

The following are examples of the status that may be seen:

"Optimizing" – commands to this database may be optimized.
"Woken and waiting" – preparations are being made to allow commands to be optimized.
"DB Down" - the database is inactive.
"AFP (DB) Missing" - the Fastpath component in the database is missing.
"Start requested" - a request to start optimizing commands is being processed.
"Stop requested" - a request to stop optimizing commands is being processed.
"Stopped" - a request to stop optimizing commands has been processed.
"Bad Response" - there has been a communication failure. Optimization is stopped.

Some of these statuses may be proceeded by an indication of the location or type of the database, such as:

"Remote" - the database is on a different lpar to the COR daemon.
"Clus" - the database is a clustered (ALS) instance.
"Paral" - the database is a parallel (ASM) one.

Database Services

If the option code s is selected for a database, the following window is displayed:

13:11:00              2018-10-22
                       F12200MC  
                                 
       Stop/Start Optimization   
       for: Database 17003       
                                 
                                 
         S Stop Optimization     
         R Start Optimization    
         . Exit                  
                                 
 Code..:                         
                                 
                                 
                                 
                                 
 Command ==>                     
       PF1 Help   PF3 Exit    

Using this window, you can stop/restart optimization for a database.

If database optimization is stopped, no further optimization occurs for its files and sets. In addition, all direct access data is removed from the Adabas Fastpath buffer for sets belonging to files within this database.

Note:
A similar service is available at the file and file set levels.

Detailed Database Information

If the option code d is selected for a database, the Database Details screen is displayed.

This screen contains a performance analysis for the selected database.

 13:11:37     ***** A D A B A S   FASTPATH SERVICES 8.2.2 *****      2018-10-22 
 Run-mode: 17004             Database Details from A8P17004 : 17004  F12200MB   
                                                                                
                            Database: 17003 SVC: 254                            
                                                                                
 ---------------------------- Optimization Summary ---------------------------- 
    Access Type               Attempts  (98%)    <----------Successes  (59%)    
                                                                                
    Read-ahead:                    457  (32%)                     320  (70%)    
    Direct:                        815  (58%)                     384  (47%)    
    RCs:                           119   (8%)                     119  (14%)    
    Others:                         14   (0%)                                   
                                                                                
    Total:                       1,405 (100%)                     823  (58%)    
 ------------------------------------------------------------------------------ 
    Updates:                            Over-reads:                52  (16%)    
                                                                                
   Status 1: 40 90 00 A0 Bad Response:       Lock: 00000000  DBE Addr: 16BC5638 
   ADABAS Vers: 813      Hex: 08010300   Location: 00000000                     
   DBID from GCB:        Nuc ID:                                                
                                                                                
 Command ==>                                                                    
                                                                                
                                                                                
                                                                                
Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12--- 
      Help        Exit  Refr        Excl                    Zero  Node  Menu    

The first section of this screen (Optimization Summary) provides optimization statistics for this database. This information is provided in the same format as that provided at the buffer level (see section Buffer Information). The statistics shown at the database level are exclusively for commands that are eligible for optimization. The excluded count therefore differs from the buffer level count.

The second section of this screen provides the following information:

Field Description
Updates The number of update commands processed for this database.
Over-reads

The number of read-aheads performed but not needed by the application, and the percentage of non-needed over-reads to the number of successful read-aheads. Non-needed over-reads represent overhead that may reduce the effectiveness of read-ahead optimization. In general, over-reads should not exceed 25% of read-ahead successes.

Status ... Nuc ID These fields are reserved for Software AG use.

Excluded Command Analysis

Pressing PF6 on the Database Details screen displays the excluded command analysis for the selected database:

 11:25:05     ***** A D A B A S   FASTPATH SERVICES 8.2.2 *****      2018-02-02
 Run-mode: 17004             Database Details from A8P17004 : 17004  F12200MG  
                                                                               
                            Database: 17003 SVC: 254                           
                                                                               
     Statistics for commands that have optimization potential but were         
     unable to be optimized:                                                   
                                                                               
     C     Description                                      Count              
     _     Unsuitable command type:                             6              
     _     Disqualified:                                        0              
     _     Optimization was disabled:                           0              
     _     Multi-fetch was already set:                         0              
     _     Command details exceed Set-id limit:                 0              
     _     Record Buffer exceeds the limit:                     0              
                                                                               
     Mark (above) to display further information about any exclusion.          
                                                                               
                                                                               
                                                                               
                                                                               
 Command ==>                                                                   
                                                                               
                                                                               
                                                                               
Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
      Help        Exit  Refr              Gen               Zero  Node  Menu

Selection of an exclusion reason will provide information about that exclusion.

The information is provided in the same format as that provided at the buffer level (see section Buffer Information).

Note:
A similar analysis can be displayed from the file detail screen.

Summary File Information

If the option code f is selected for a database, the File Summary screen is displayed.

Note:
You can also access this screen by entering 2.2.1 on the command line.

This screen displays a summary of activity for each file in the selected database.

 13:13:00     ***** A D A B A S   FASTPATH SERVICES 8.2.2 *****      2018-10-22
 Run-mode: 17004             Files from A8P17004 : 17004             F12210MA  
                                                                               
                            Database: 17003 SVC 254                            
                                                                               
 C   File      Attempts           Optimized       Set Usage(k)  Status         
 _                                                             Optimizing      
 _      9          1391                 823           34       Optimizing      
 _     10                                                      Optimizing      
                                                                               
                                                                               
                                                                               
                                                                               
                                                                               
                                                                               
                                                                               
                                                                               
                                                                               
  Totals:          1391  100%           823  100%     34  100%                 
 Mark with D(etail),F(ile Sets),S(ervices)                                     
                                                                               
 Command ==>                                                                   
                                                                               
                                                                               
                                                                               
Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
      Help        Exit  Refr                                      Node  Menu   

The following information is provided:

Field Description
C Option code. The following options are available:

d: display detailed database information
d: display detailed file information
f: display file set summary
s: perform file service (stop/start optimization)

File The Adabas file number.
Attempts The total number and percentage of optimization attempts.
Optimized The total number and percentage of successful optimization attempts.
Set Usage The amount of memory allocated for the exclusive use of this file. (This includes both memory that is being productively used and extra memory allocated for the purposes of set growth.)
Status

The status of the file (optimizing or not optimizing).

The following are examples of the status that may be seen:

"File Missing" - the file does not exist.
"Optimizing"”– commands to this file may be optimized.

Note:
If the file is deleted with the option "KEEP FDT" the status will still show as optimizing.

"Stopped" – preparations are being made to allow commands to be optimized.
"Bad response" - there has been a communication failure. Optimization is stopped.
"Error detected" - an error has been detected. Optimization is stopped.
"Locked" - Either the file has been locked with the Adabas operator command LOCKF= , or, an Adabas utility is running against this file, or, a user has requested exclusive control of the file.
"Start requested" - a request to start optimizing commands is being processed.
"Stop requested" - a request to stop optimizing commands is being processed.
"Pending event" - a request to stop optimizing commands has been processed.
"DA suspended" - optimization of commands by direct-access is temporarily stopped.
"DA terminated" - optimization of commands by direct-access is stopped.

Detailed File Information

If option code d is selected on the File Summary screen, the File Details screen is displayed.

This screen contains optimization performance information for the selected file.

13:13:39     ***** A D A B A S   FASTPATH SERVICES 8.2.2 *****      2018-10-22
 Run-mode: 17004             File Details from A8P17004 : 17004      F12210MB  
                                                                               
                      Database: 17003 SVC 254 File: 9                          
 ---------------------------- Optimization Summary ----------------------------
    Access Type               Attempts  (98%)    <----------Successes  (59%)   
                                                                               
    Read-ahead:                    457  (32%)                     320  (70%)   
    Direct:                        815  (58%)                     384  (47%)   
    RCs:                           119   (8%)                     119  (14%)   
    Others:                         10   (0%)                                  
                                                                               
    Total:                       1,401 (100%)                     823  (58%)   
 ------------------------------------------------------------------------------
       Updates:                         Over-reads:                52  (16%)   
                                                                               
   Set Limit(k): 1023                                   Update Sensitivity: R  
   Set Id Length Limit: 1024   RB Length Limit: 1024    Set Concurrency: 2     
   Status: 00 D0   Last RC:         Next Event:  0:00   Addr: 16BCC5A0         
                                                                               
                                                                               
 Command ==>                                                                   
                                                                               
                                                                               
                                                                               
Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
      Help        Exit  Refr        Excl              More  Zero  Node  Menu   

The first section of this screen (Optimization Summary) provides optimization statistics for the file. This information is provided in the same format as that provided at the database level.

The second section of this screen provides the following information:

Field Description
Updates The number of update commands processed for this file.
Over-reads

The number of read-aheads performed but not needed by the application, and the percentage of non-needed over-reads to the number of successful read-aheads. Non-needed over-reads represent overhead that may reduce the effectiveness of read-ahead optimization. In general, over-reads should not exceed 25% of read-ahead successes.

Set Limit ... Set Concurrency The current settings for various file optimization parameters. For a description of each parameter, see the section Adabas Fastpath Parameters.
Status ... Addr These fields are reserved for Software AG use.

Pressing PF9 invokes the second File Details screen. This screen shows whether or not optimization has been defined for the Adabas command/descriptor pairs which are used to access the file.

10:37:21   ***** A D A B A S  FASTPATH SERVICES 8.2.2 *****           2018-05-19
           -  File Details for File 19 DBID 198 SVC 240  -             F12210ME
                            Expanded File N

                On/Off Adabas Field Overrides     ........Direct Access......
              L1   On
              L3   On
              L9   On
              S1   On
              S2   On

  Over-reads   Default Adabas Field Overrides     ........Read-ahead.........
              L1    On
              L2    On
          34  L3    On
              L9    On
              S1    On
              S2    On
              S8    On
              S9    On


  Command ==>
 Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12
       Help        Exit              Excl  Gen                     Node  Menu
File Details 2

The two sections of the screen provide optimization information for direct access and read-ahead commands respectively.

The following information is provided:

Field Description
Command Adabas command.
On/Off Indicates whether or not optimization is in effect for the command.
Adabas Field Overrides Indicates whether or not Adabas field overrides have been defined.
Over-reads

The number of read-aheads performed but not needed for the command. Non-needed over-reads represent overhead that may reduce the effectiveness of read-ahead optimization. In general, over-reads should not exceed 25% of read-ahead successes.

File Set Summary Information

If the option code f is entered for a file on the File Summary screen, the Set Summary screen is displayed. This screen contains summary information for each Adabas command/descriptor pairing:

Note:
You can also access this screen by entering 2.2.2 on any command line.

Note:
You can also access this screen using PF9 from AFPLOOK File Details or File Parameter Maintenance. In addition, this screen gives hot key access to AFPLOOK (PF6) and File Parameters (PF5). Pressing PF10 displays details of the master control set for the file.

13:14:49     ***** A D A B A S   FASTPATH SERVICES 8.2.2 *****      2018-10-22
 Run-mode: 17004             Set Summary from A8P17004 : 17004       F12220MA  
                                                                               
                      Database: 17003 SVC 254 File: 9                          
                                                                               
              Number of Items....                Memory (k)....      Growth    
 C CC De Sets    In Use      Peak     Optimized  In Use    Peak      Mode      
 _ L1       1        20        25            60       2       3                
 _ L1  I    1        20        25           136       2       3                
 _ L3 AA    1        20        25            64       3       4                
 _ L9 AE    1        20        25            64       4       5                
 _ S1 AE    3        20        59            60       3      10                
 _ S2 AE    2                  34                             6                
                                                                               
                                                                               
                                                                               
                                                                               
                                                                               
                                                                               
 Mark with D(etail),F(ull Set List)                                            
                                                                               
 Command ==>                                                                   
                                                                               
                                                                               
                                                                               
Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
      Help        Exit  Refr  Parms Look                    Cntl  Node  Menu   

The following information is provided:

Field Description
C Option code. The following options are available:

d: display detailed set information
f: display full set list

CC De The Adabas command/descriptor pair for which information is provided.
Sets The number of sets that have been added together to make the summary.
Number of Items The number of items (records) in use at the present time, the peak number of items used, and the number of times items in the set were used for optimization.
Memory

In use: The amount of memory productively being used by these sets. Each set may also have extra memory allocated to it for the purposes of set growth, so the sum of the "In use" memory for all the sets in a file will not be the same as the "Set usage (k)" from the summary file information screen.

Peak: The HWM of all memory that has ever been allocated for use by these sets

Growth Mode Fastpath regularly assesses the worthiness of all direct-access sets as being high, medium or low. Based upon this assessment Fastpath is likely to award more memory to sets assessed highly, when there is memory available, and to remove memory from the less worthy sets. The regular reassessment means the assessment of a set will quickly change according to current system activity thereby making sure the most appropriate optimization levels are maintained at all times.

File Set List

If the option code f is selected for a command/descriptor pair on the File Set Summary screen, the Set Summary screen will be displayed.

This screen contains an activity summary for each direct access set used by the selected command/descriptor pair.

13:15:28     ***** A D A B A S   FASTPATH SERVICES 8.2.2 *****      2018-10-22
 Run-mode: 17004             Set Summary from A8P17004 : 17004       F12230MA  
                                                                               
               Database: 17003 SVC 254 File: 9     CC: S1 De: AE               
                                                                               
           Number of Items......               Memory (k).....      Growth     
 C  SSID       In Use       Peak     Optimized  In Use    Peak      Mode       
 _     3           20         25            60       3       4                 
 _     1                      17                             3                 
 _     9                      17                             3                 
                                                                               
                                                                               
                                                                               
                                                                               
                                                                               
                                                                               
                                                                               
                                                                               
                                                                               
 Mark with D(etail),S(start/stop)                                              
                                                                               
 Command ==>                                                                   
                                                                               
                                                                               
                                                                               
Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
      Help        Exit  Refr                                Cntl  Node  Menu  

The following information is provided:

Field Description
C Option code. The following options are available:

d: display detailed set information
s: start/stop optimization for the set

SSID SSID (Short Set ID) is a number used internally to identify different sets. The lower the number, the older the set.
Sets ... Ratings The remaining fields on this screen are as described in the previous section File Set Summary.

Detailed Set Information

The Set Detail screen can be invoked by selecting the option code d for a set or pressing PF10 on the File Set Summary screen:

13:15:57     ***** A D A B A S   FASTPATH SERVICES 8.2.2 *****      2018-10-22
 Run-mode: 17004             Set Detail from A8P17004 : 17004        F12230MB  
                                                                               
                      Database: 17003 SVC 254 File: 9                          
 Command: S1    Primary Descriptor: AE               SSID: 3                   
                                                                               
   Items   - Optimized:            60                 Growth Mode:             
             Current:         20 Added:           20  Removed:                 
             Peak:            25 RLU:                 Overwrites:              
             Free:             5 Resets:              Collisions:              
   Memory  - Used(k):          3 Peak(k):          4  Free(k):                 
   Status:   00 04 0E 08         Expansion:        1  Acc.Mask Entries     2   
   Used      FB:     1 RB:       Indexes:          3  Address:      16BDCF28   
   Lengths:  SB:     8 VB:    20 Code:                Lock:         00000000   
   SetID Length:    21                                                         
 Reject:                                                                       
 SB AE,20,A.                                                                   
 FB .                                                                          
                                                                               
 Command ==>                                                                   
                                                                               
                                                                               
                                                                               
                                                                               
                                                                               
Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
      Help        Exit  Refr                                Conc        Menu   

The following information is provided:

Field Description
Growth Mode Fastpath regularly assesses the worthiness of all direct-access sets as being high, medium or low. Based upon this assessment Fastpath is likely to award more memory to sets assessed highly, when there is memory available, and to remove memory from the less worthy sets. The regular reassessment means the assessment of a set will quickly change according to current system activity thereby making sure the most appropriate optimization levels are maintained at all times.
Items ...

Optimized: the number of successful optimizations from data records in the set.
Added: the number of times a data record was inserted into the set.
Collisions: the number of times a set was inaccessible because concurrency for the set was exhausted.
Current: the number of data records currently in the set.
Peak: the highest number of data records which have been in the set.
Free: the number of free data item areas currently available.
Removed: the number of data records which have been removed from the set.
RLU: the number of times an individual data record was removed from the set as a result of a database modification command (for example, update, insert, delete).
Overwrites: the number of times a new data record was inserted by overwriting an existing record because no free area was available.
Set Resets: the number of times a complete set was emptied.

Memory The memory in use to hold the data in the sets (in k) and the peak memory usage for all sets.
Status ... Reject These fields are reserved for Software AG use.

Press PF10 to display set concurrency information.

Job Information

Selecting option code 3 on the Current Activity Display screen, displays the Job Summary screen.

Note:
You can also access this screen by entering 2.3 on the command line.

This screen displays a summary of activity for each job.

 13:17:32     ***** A D A B A S   FASTPATH SERVICES 8.2.2 *****      2018-10-22
 Run-mode: 17004             Job Summary for A8P17004 : 17004        F12300MA  
                                                                               
 Buffer Session: 113         Started: Oct 22,2018  12:46    Size(k): 1023      
                                                                               
 C Job Name Number Job Type       Attempts     Optimized Mem(k) Status         
 _ UKRPE    U54670 TSO                1391           823        Active         
 _                                                              Unused         
 _                                                              Unused         
 _                                                              Unused         
 _                                                              Unused         
 _                                                              Unused         
 _                                                              Unused         
 _                                                              Unused         
 _                                                              Unused         
 _                                                              Unused         
 _                                                              Unused         
 _                                                              Unused         
                                                                               
 Mark with D(etail),S(ervices)                                                 
                                                                               
 Command ==>                                                                   
                                                                               
                                                                               
                                                                               
Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
      Help        Exit  Refr                                Sysj  Node  Menu   

The following information is provided:

Field Description
C Option code. The following options are available:

d: display detailed job information
s: stop/start optimization

Job Name Number Type The job name, job number and job type.
Attempts The number of optimization attempts.
Optimized The number of successful optimization attempts.
Memory Memory used by the job.
Status The status of the job (active, unused, disconnected).

Note:
Status Disconnected indicates that a job is no longer being optimized, usually because it has completed. The job details can still be displayed until the job area is reused.

Press PF10 to display the System Job Summary screen.

Detailed Job Information

Selecting option code d for a job on the Job Summary screen displays the Job Details screen.

13:19:03     ***** A D A B A S   FASTPATH SERVICES 8.2.2 *****      2018-10-22
 Run-mode: 17004             Job Details from A8P17004 : 17004       F12300MB  
                                                                               
 Job:    UKRPE Type: TSO       Number: U54670        Started: Oct 22,2018 12:29
                                                                               
 ---------------------------- Optimization Summary ----------------------------
    Access Type               Attempts  (64%)    <----------Successes  (59%)   
                                                                               
    Read-ahead:                    457  (21%)                     320  (70%)   
    Direct:                        815  (38%)                     384  (47%)   
    RCs:                           119   (5%)                     119  (14%)   
    Others:                        709  (36%)                                  
                                                                               
    Total:                       2,100 (100%)                     823  (39%)   
 ------------------------------------------------------------------------------
  Memory(k):             RA Memory:             Over-reads:                52  
                                                                               
   Status: 00 00 00 00    System ID:      TSO     Area Address: 16BBAB88       
                                                                               
                                                                               
                                                                               
 Command ==>                                                                   
                                                                               
                                                                               
                                                                               
Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
      Help        Exit  Refr        Excl              More  Zero  Node  Menu   

The first section of this screen (Optimization Summary) provides optimization statistics for this job. This information is provided in the same format as that provided at the buffer and database level (see section Buffer Information).

The following additional fields are displayed:

Field Description
Memory The total memory, in kilobytes, of all memory classes used for this job.
RA Memory The total memory, in kilobytes, of all read-ahead areas allocated to this job.
Over-reads

The number of read-aheads performed but not needed by this job, and the percentage of non-needed over-reads to the number of successful read-aheads. Non-needed over-reads represent overhead that may reduce the effectiveness of read-ahead optimization. In general, over-reads should not exceed 25% of read-ahead successes.

Status ... Address These fields are reserved for Software AG use.

PF9 on the Job Details screen can be used to display the second job detail screen.

11:41:09     ***** A D A B A S   FASTPATH SERVICES 8.2.2 *****      2018-03-01
 Run-mode: 17004             Job Details from A8P17004 : 17004       F12300MC  
                                                                               
 Job:   RPEAWG Type: Batch     Number: B43793         Started Mar  1,2018 10:59
                                                                               
 Job Information---------------------------------------------------------------
   CID  Areas:  In Use: 0        Peak: 1                                       
                                                                               
 Client Runtime Controls-------------------------------------------------------
   System Coordinator (Buffer) Group Name: RPEGRP1                             
                                                                               
   Fastpath ON/OFF......: ON          Read-ahead Optimization Control: BAT     
   Direct Access........: ON          Read-ahead Memory Limit(k).....: 0       
   Tracing..............: N           Maximum read-ahead unit size(k): 32      
   Command time (Hex)...: 12345678    Maximum read-ahead rate........: 4096    
   End-of-job-statistics:   None                                               
                            Daemon messages                                    
                          X File history with maximum records........:  4      
                                                                               
                                                                               
                                                                               
 Command ==>                                                                   
                                                                               
                                                                               
                                                                               
Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
      Help        Exit  Refr        Excl  Gen                     Node  Menu   

The first section of this screen (Job Information) provides the following information:

Field Description
CID Areas

In Use: the number of Command ID areas currently in use.

Peak: the highest number of Command ID areas which have been concurrently in use.

The second section contains the current values for the client runtime controls. See the section Adabas Fastpath Parameters for descriptions of these parameters.

Note:
The parameter values currently being used by the job are displayed. Once a job is disconnected, these values are reset automatically to the default parameter values.

PF6 can be used to display the Excluded Command Analysis screen as described in the section Buffer Information.

System Job Information

Selecting option code 4 on the Current Activity Display screen invokes the System Job Summary screen.

Note:
You can also access this screen by entering 2.4 on the command line.

This screen contains a list of system job areas for the active Adabas Fastpath buffer. This is normally the Asynchronous Buffer Manager task and any database components.

15:53:10  ***** A D A B A S   FASTPATH SERVICES 8.2.2        *****  2018-11-26
 Run-mode: 17004             Jobs for A8P17004 : 17004               F12400MA  
                                                                               
 Buffer Session: 567         Started: Nov 26,2018  10:25    Size(k): 1023      
                                                                               
 C   Job Name Number Job Type    SVC  DB   Nuc ID              Status          
 _                   AFPADA      254 17015                     DB down         
 _   N8C81003 C34417 AFPADA      254 17003                     Active          
 _   A8P17004 C32991 AFPABM                                    Active          
                                                                               
                                                                               
                                                                               
                                                                               
                                                                               
                                                                               
                                                                               
                                                                               
                                                                               
                                                                               
 Mark with D(etail),S(ervices)                                                 
                                                                               
 Command ==>                                                                   
                                                                               
                                                                               
                                                                               
Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
      Help        Exit                                      UserJ Node  Menu   

The following information is provided:

Field Description
C Option code. The following options are available:

d: display the Asynchronous Buffer Services menu
s: display the Database Component Services menu

Note:
These services are described in the section Special Services.

Job Name Number Type The job name, job number and job type.
SVC The Adabas SVC used for this job.
DB The Adabas database used for this job. This is the "external" DBID (DBID used by the application program).
Nuc ID This ID is used by a member of Adabas Parallel/Cluster Services. These services may have "internal" DB numbers.
Status The status of the job (active, unused).

PF10 can be used to display the Optimized Job Summary screen.