Supplied Report Reference

This section describes the reports supplied with Adabas Review. These reports should be customized to suit individual site requirements, prior to attempting to run them.

The documentation for each report lists the fields (system names), report options, and report processing rules (if any) used to produce the report. To examine these report definitions online, read Editing Existing Reports.

The following reports are described:


Application File Field Usage Report

The Application File Field Usage report shows the processing activity, by file, for Natural application programs. Processing activity information includes the total number of commands and I/Os, as well as the total amount of command response time (CMDRESP) and time used to process in the Adabas thread (ADADURA).

11:15:38                APPLICATION FILE FIELD USAGE                 2016-07-28
                          2016-07-28 Thru 2016-07-28                           
                                                                     Page:    1
                             Total        Total         Total                  
NAT-Appl  File  Fld-Name  Num-of-IOs     Commands      Cmd-Resp                
-------- ------ -------- ------------- ------------ --------------             
                                                                               
              0                      0           34       0.113408             
             50                      0           85       6.183168             
             50 AB                   0           14       4.649984             
             50 AI                   0            5       2.564480             
             50 AK                   0            5       2.564480             
             50 AL                   0            5       2.564480             
             50 AM                   0            5       2.564480             
             50 AN                   0            5       2.564480             
             50 AZ                   0            5       2.564480             
             50 OA                   0          163      12.200576             
             50 OB                   0           15       1.862784             
             50 OC                   0          101       7.873152             
             50 OD                   0          103       8.088064             
                                                                               
Command: _____________________________________________________________________ 
Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
      Help        Exit                           +                ===>  Menu
11:15:40                 APPLICATION FILE FIELD USAGE               2016-07-28
                   2016-07-28 11:15:25 - 2016-07-28 11:15:38    Columns 010 072
=====>                                                        Scroll ===>  PAGE
 ***** ****************************** top of data *****************************
 00001 -------- ----- -------- ------------ ------------- ------------------- -
 00002                                Total         Total               Total  
 00003 NAT-Appl  File Fld-Name   Num-of-IOs      Commands            CMD-Resp  
 00004 -------- ----- -------- ------------ ------------- ------------------- -
 00005              0                     0             8            0.129125  
 00006              1                     0             5            0.001250  
 00007              1 AQ                  5            11            0.012250  
 00008              1 AT                 11            12            0.027125  
 00009 ******** ***** ********           16            36            0.169750  
 00010 SYSBIZ       0                     0             4            0.001000  
 00011           1007                     0             1            0.004750  
 00012           1008                     0             1            0.004750  
 00013           1021                     0             1            0.004750  
 00014           1022                     0             1            0.004750  
 00015 ******** ***** ********            0             8            0.020000  
 00016 SYSREVDB     0                     0            23            0.336500  
 00017 ******** ***** ********            0            23            0.336500  
 00018 ******** ***** ********           16            67            0.526250  
 ***** **************************** bottom of data ****************************
                                                                               
Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
      Help  RVSrt Exit  Updat Rfind       -     +           <===  ===>  Canc
11:18:37                 APPLICATION FILE FIELD USAGE               2016-07-28
                   2016-07-28 11:15:25 - 2016-07-28 11:15:38    Columns 025 087
=====>                                                        Scroll ===>  PAGE
 ***** ****************************** top of data *****************************
 00001 -------- ------------ ------------- ------------------- --------------- 
 00002                 Total         Total               Total           Total 
 00003 NAT-Appl   Num-of-IOs      Commands            CMD-Resp         ADA-Dur 
 00004 -------- ------------ ------------- ------------------- --------------- 
 00005                     0             8            0.129125        0.020310 
 00006                     0             5            0.001250        0.000148 
 00007                     5            11            0.012250        0.055925 
 00008                    11            12            0.027125        0.194048 
 00009 ********           16            36            0.169750        0.270431 
 00010 SYSBIZ              0             4            0.001000        0.000083 
 00011                     0             1            0.004750        0.000041 
 00012                     0             1            0.004750        0.000036 
 00013                     0             1            0.004750        0.000035 
 00014                     0             1            0.004750        0.000147 
 00015 ********            0             8            0.020000        0.000342 
 00016 SYSREVDB            0            23            0.336500        0.000122 
 00017 ********            0            23            0.336500        0.000122 
 00018 ********           16            67            0.526250        0.270895 
 ***** **************************** bottom of data ****************************
                                                                               
Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
      Help  RVSrt Exit  Updat Rfind       -     +           <===  ===>  Canc

Output of APPLICATION FILE FIELD USAGE with redefined field redefinitions:

<FIELDS-REDEF-START>                                
NATAPPL  A8     NAT-Appl         /* A8     NAT-Appl 
FILE     N5     File             /* N5     File     
FBFIELDS A2     FB               /* A2     Fld-Name 
IOS      N8     NumOfIOs         /* N12    Num-of-IOs
COMMANDS N8     Commands         /* N13    Commands 
CMDRESP  N4.4   CMD-Resp         /* N12.6  CMD-Resp 
ADADURA  N2.4   ADA-Dur          /* N8.6   ADA-Dur  
<FIELDS-REDEF-END>
11:40:37                 APPLICATION FILE FIELD USAGE                2017-10-04
                   2017-09-28 12:53:31 - 2017-10-04 11:40:36    Columns 010 054
=====>                                                        Scroll ===>  PAGE
 ***** ********************* top of data ********************                 
 00001 -------- ----- -- -------- -------- --------- -------                  
 00002                      Total    Total     Total   Total                  
 00003 NAT-Appl  File FB NumOfIOs Commands  CMD-Resp ADA-Dur                  
 00004 -------- ----- -- -------- -------- --------- -------                  
 00005              0           0       69    1.1040  0.0000                  
 00006 ******** ***** **        0       69    1.1040  0.0000                  
 00007 SYSREVDB     0           0     2627   42.0320  0.0000                  
 00008 ******** ***** **        0     2627   42.0320  0.0000                   
 00009 ******** ***** **        0     2696   43.1360  0.0000                  
 ***** ******************* bottom of data *******************                 
                                                                               
                                                                              
Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
      Help  RVSrt Exit  Updat Rfind       -     +                       Canc

This section covers the following topics:

Fields Selected

Field System Name Order Sum Min Max Avg Pct Rate Round
NATAPPL 1              
FILE 2              
FBFIELDS 3              
IOS   Y            
COMMANDS   Y            
CMDRESP   Y            
ADADURA   Y            

Report Options Selected

Defaults.

Report Processing Rules

None.

Adabas Buffer Pool Display Report

The Adabas Buffer Pool Display Report shows the usage of Adabas buffer pools.

22:31:56                  A D A B A S  -  R E V I E W                2016-06-19
                          ADABAS Buffer Pool Display                           
                                                                               
 nnnnK  = Buffer Size ------- = Max Used ======= = Currently Used              
                                                                               
   !   47003K                        29K       0K       0K       0K     602K   
100%  ---45%-                    --605%-  ==605%=  ---45%-  ====7%=  --828%-   
   !  -------                    -------  =======  -------  =======  -------   
   !  -------                    -------  =======  -------  =======  -------   
 75%  -------                    -------  =======  -------  =======  -------   
   !  -------                    -------  =======  -------  =======  -------   
   !  -------               19K  -------  =======  -------  =======  -------   
 50%  -------           ---50%-  -------  =======  -------  =======  -------   
   !  -------           -------  -------  =======  -------  =======  -------   
   !  -------           -------  -------  =======  -------  =======  -------   
 25%  -------           -------  -------  =======  -------  =======  -------   
   !  -------           -------  -------  =======  -------  =======  -------   
   !  -------   33224K  ===10%=  ====1%=  =======  -------  =======  -------   
  0%-------------------------------------------------------------------------  
       AB-POOL  COMMAND  HOLD     USER     ISN TAB  SEQ TAB  FORMAT   WORK     
                                                                               
Command: ______________________________________________________________________
Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
      Help        Exit                                                  Menu   

Command Logging Report

The Command Logging report is a detailed report that contains the necessary report options for using the command logging features of Adabas Review. It may be used as an example for creating reports that perform command logging. For more information about the use of the command logging report options, refer to the section Logging Options.

The following report options are required for command logging and are used in this report:

Detail/Sum D
Print N
Log Y
File name
Num of Logs number
Log Size number

A command log report must be a detailed report so that it produces a straight recording of each command processed by Adabas.

Data fields are not used in reports that perform command logging. Because it is a detailed report and cannot be viewed online, and because the PRINT option is set to "N", field information entered on the Edit Report screen produces no effect.

Note:
When Log is set to Y, a detailed report without fields may be defined.

The following report options used in this report are not required for command logging:

AutoStart Y
Log FB Y
Log SB Y
Log RB Y
Log VB Y
Log IB Y
Log IO Y

Commands By Hour Report

The Commands by Hour report shows Adabas processing activity, by command, on an hourly basis. The processing activity shown includes the total number of commands, the total and average number of I/Os, and the total command response time.

03:39:06                      COMMANDS BY HOUR                       2016-06-20
                 03:37:16 2016-06-20 Thru 03:38:58 2016-06-20                  
                                                                     Page:    1
              Total        Total         Total           Avg                   
Time  Cmd  Num-of-IOs     Commands      Cmd-Resp     Num-of-IOs                
----- --- ------------- ------------ -------------- -------------              
                                                                               
03:00 L3              0           12       0.998400         0.000              
      RC              0            2       0.003584         0.000              
      S1              0           28       3.218432         0.000              
***** ***             0           42       4.220416         0.000              
***** ***             0           42       4.220416         0.000              
                                                                               
*****   E N D    O F    R E P O R T   *****                                    
                                                                               
                                                                               
                                                                               
                                                                               
                                                                               
                                                                               
                                                                               
Command: _____________________________________________________________________ 
Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
      Help  Sort  Exit              --           +                ===>  Menu   

This section covers the following topics:

Fields Selected

Field System Name Order Sum Min Max Avg Pct Rate Round
HOUR 1              
CMD 2              
IOS   Y     Y      
COMMANDS   Y            
CMDRESP   Y     Y      

Report Options Selected

AUTOSTART = Y
MAX K = 8

Report Processing Rules

None.

Cost Accounting Example Report

The Cost Accounting Example report is a summary report designed to show how Adabas Review may be used to produce cost accounting reports about Adabas resource consumption.

For more information about this report, see the section Cost Accounting Example.

Descriptor Usage Report

The Descriptor Usage Report shows processing done for Adabas fields used as descriptors. Commands are shown with the descriptor name for the field on which the command was performed. Processing statistics are given for each command, whether or not the command was performed on a descriptor.

03:41:00                   DESCRIPTOR USAGE REPORT                   2016-06-20
                 03:37:25 2016-06-20 Thru 03:40:29 2016-06-20                  
                                                                     Page:    1
                         Total        Total          Total           Total     
 File  Cmd Desc-Name  Num-of-IOs     Commands       ADA-Dur         ISN-Qty    
------ --- --------- ------------- ------------ ---------------- ------------- 
                                                                               
     0 RC                        0            3         0.000336             0 
****** *** *********             0            3         0.000336             0 
    50 L3  O1                    0           12         0.000592             0 
       S1                        0            2         0.000416             2 
       S1  O1                    0           25         0.005552            25 
       S1  T1                    0            1         0.000304             1 
****** *** *********             0           40         0.006864            28 
****** *** *********             0           43         0.007200            28 
                                                                               
*****   E N D    O F    R E P O R T   *****                                    
                                                                               
                                                                               
                                                                               
                                                                               
Command: _____________________________________________________________________ 
Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
      Help  Sort  Exit              --           +                      Menu   

This section covers the following topics:

Fields Selected

Field System Name Order Sum Min Max Avg Pct Rate Round
FILE 1              
CMD 2              
SBFIELDS 3              
IOS   Y            
COMMANDS   Y            
ADADURA   Y            
ISNQ   Y            

Report Options Selected

Defaults.

Report Processing Rules

None.

Exceptional Response Codes Report

The Exceptional Response Codes report gives a snapshot of the processing environment at the time that an Adabas command returns an exceptional response code. (Response codes are exceptional if they are not equal to 0, 3, 9, 17, or 48.) The information collected by this report may be used to help determine the cause and resolve the condition causing the exceptional response code.

11:27:13                  EXCEPTIONAL RESPONSE CODES                2016-07-07
                    10:50:09 2016-06-23 Thru 10:54:51 2016-06-23             

    Seq     CQ-Job  TPUserid NAT-Appl NAT-Pgm  NAT-Stmt Cmd File Rsp Rspsub
 --------- -------- -------- -------- -------- -------- --- ---- ----------
    203871 COMPLETE USER1    PAA      MGLNVAUD 3110     L4    63  113   0
    204158 COMPLETE USER2    PAA      MGLNVAUD 3110     L4    63  113   0
    204689 COMPLETE USER3    PAA      MGLNVAUD 3110     L4    63  113   0
 ********* ******** ******** ******** ******** ******** *** **** **********
 *****   E N D    O F    R E P O R T   *****

 Command: _____________________________________________________________________
 Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
       Help  Sort  Exit                           +                ===>  Menu

This section covers the following topics:

Fields Selected

Field System Name Order Sum Min Max Avg Pct Rate Round
SEQ 1              
CQJOB 2              
TPUSERID 3              
NATAPPL 4              
NATPROG 5              
NATSTMT 6              
CMD 7              
FILE 8              
RSP 9              
RSPSUB 10              
IOS 11              
ADADURA 12              
CID 13              

Report Options Selected

AUTOSTART = Y

Report Processing Rules

RSP  NE  (0,3,9,17,48)

File Usage Report

The File Usage report breaks down file usage into the types of processing done to the file. It shows the total number of associator and data storage I/Os executed, the descriptor updates performed, the command response time used, the amount of Adabas processing time required, and the total number of commands.

03:43:13                         FILE USAGE                          2016-06-20
                 03:37:35 2016-06-20 Thru 03:42:23 2016-06-20                  
                                                                     Page:    1
           Total         Total        Total         Total         Total        
 File    Asso-IOs      Data-IOs      Commands     Desc-Upd       Cmd-Resp      
------ ------------- ------------- ------------ ------------- --------------   
                                                                               
     0             0             0            4             0       0.007168   
    50             0             0           38             0       3.986944   
******             0             0           42             0       3.994112   
                                                                               
*****   E N D    O F    R E P O R T   *****                                    
                                                                               
                                                                               
                                                                               
                                                                               
                                                                               
                                                                               
                                                                               
                                                                               
                                                                               
Command: _____________________________________________________________________ 
Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
      Help  Sort  Exit              --           +                ===>  Menu   

This section covers the following topics:

Fields Selected

Field System Name Order Sum Min Max Avg Pct Rate Round
FILE 1              
ASSOIO   Y            
DATAIO   Y            
COMMANDS   Y            
DESUPD   Y            
CMDRESP   Y            
DURATION   Y            

Report Options Selected

Defaults.

Report Processing Rules

None.

Hourly Database Overview Report

The Hourly Database Overview report shows the processing done in the database which is currently selected, on an hourly basis. It gives the total number of commands and I/Os, the total and average command response time (CMDRESP), and the average Adabas thread processing time (ADADURA).

04:08:00                  HOURLY DATABASE OVERVIEW                   2016-06-20
                 03:37:42 2016-06-20 Thru 04:07:29 2016-06-20                  
                                                                     Page:    1
                 Total        Total         Total           Total              
Time   File   Num-of-IOs     Commands      Cmd-Resp        ADA-Dur             
----- ------ ------------- ------------ -------------- ----------------        
                                                                               
03:00      0             0           12       0.021504         0.001872        
          50             0           51       5.481216         0.008976        
***** ******             0           63       5.502720         0.010848        
04:00      0             0            4       0.007168         0.000624        
          50             0            8       0.919552         0.001840        
***** ******             0           12       0.926720         0.002464        
***** ******             0           75       6.429440         0.013312        
                                                                               
*****   E N D    O F    R E P O R T   *****                                    
                                                                               
                                                                               
                                                                               
                                                                               
                                                                               
Command: _____________________________________________________________________ 
Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
      Help  Sort  Exit              --           +                ===>  Menu   

This section covers the following topics:

Fields Selected

Field System Name Order Sum Min Max Avg Pct Rate Round
HOUR 1              
FILE 2              
IOS   Y            
COMMANDS   Y            
CMDRESP   Y     Y      
ADADURA   Y     Y      

Report Options Selected

Defaults.

Report Processing Rules

None.

I/O Count by Hour Report

The I/O Count by Hour report calculates and displays information on an hourly basis. It shows the total I/Os, and breaks them into totals for the associator, the data storage area, and the work area. Total number of commands is also shown. The processing rule "IOS GT 0" assures that reporting is on commands issuing at least one I/O.

11:35:38                       IO COUNT BY HOUR                     2016-07-07
                    10:32:13 2016-06-23 Thru 11:35:37 2016-06-23              
           Total        Total         Total         Total         Total
 Time       IOs        Commands     Asso-IOs      Data-IOs     Work-IOs
 ----- ------------- ------------ ------------- --------------------------
 10:00          3913         2140          1862          1737          314
 11:00          5245         2899          2554          2319          372
 *****          9158         5039          4416          4056          686
 *****   E N D    O F    R E P O R T   *****



 Command: _____________________________________________________________________
 Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
       Help  Sort  Exit                           +                      Menu

This section covers the following topics:

Fields Selected

Field System Name Order Sum Min Max Avg Pct Rate Round
HOUR 1              
IOS   Y            
COMMANDS   Y            
ASSOIO   Y            
DATAIO   Y            
WORKIO   Y            

Report Options Selected

ENTRIES = 99999

Report Processing Rules

IOS  GT  0

I/O Summary... Reports

The two I/O summary reports, I/O Summary by RABN and I/O Summary by Volume, may be used to determine the components against which I/Os are performed. For commands issuing at least one I/O, these reports list the Adabas component against which the I/O was performed, and either the Adabas relative block number or the volume serial number of the device.

I/O Summary by RABN Report

The I/O Summary by Volume report is an example of an I/O summary report.

This section covers the following topics:

Fields Selected

Field System Name Order Sum Min Max Avg Pct Rate Round
IOCOMP 1              
IORABN 2              
COMMANDS   Y            

Report Options Selected

ENTRIES = 99999

Report Processing Rules

IOS  GT  0

I/O Summary by Volume Report

The I/O Summary by Volume report is an example of an I/O summary report.

11:36:43                     IO SUMMARY BY VOLUME                   2016-07-07
                    10:33:08 2016-06-23 Thru 11:36:42 2016-06-23              
                           Total
 Volser IO-TYPE IO-Comp   Commands
 ------ ------- ------- ------------
 RD0008 ASSO    AC1             1172
        ASSO    AC2                7
        ASSO    AS               386
        ASSO    FCB              193
        ASSO    FDT              103
        ASSO    NI1             1704
        ASSO    UI1              881
        ASSO    UI2               12
        DATA    DS               161
        DATA    DS1             3562
        DATA    DS2              183
        DATA    DS3               37
        DATA    DS4              150
 Command: _____________________________________________________________________
 Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
       Help  Sort  Exit                           +                      Menu

This section covers the following topics:

Fields Selected

Field System Name Order Sum Min Max Avg Pct Rate Round
IOVOLSER 1              
IOTYPE 2              
IOCOMP 3              
COMMANDS   Y            

Report Options Selected

ENTRIES = 99999

Report Processing Rules

IOS  GT  0

Job Overview Report

The Job Overview report shows processing activity for jobs or tasks issuing Adabas calls. For the job or task, it shows the file number accessed, the total number of I/Os and commands, and the total command response time (CMDRESP) and Adabas thread processing time used (ADADURA).

03:55:38                        JOB OVERVIEW                         2016-06-20
                 03:38:08 2016-06-20 Thru 03:54:30 2016-06-20                  
                                                                     Page:    1
                        Total        Total         Total           Total       
 CQ-Job   File  Cmd  Num-of-IOs     Commands      Cmd-Resp        ADA-Dur      
-------- ------ --- ------------- ------------ -------------- ---------------- 
                                                                               
 ?~??q        0 RC              0            8       0.014336         0.001184 
             50 L3              0           12       0.998400         0.000592 
             50 S1              0           26       2.988544         0.005344 
******** ****** ***             0           46       4.001280         0.007120 
******** ****** ***             0           46       4.001280         0.007120 
                                                                               
*****   E N D    O F    R E P O R T   *****                                    
                                                                               
                                                                               
                                                                               
                                                                               
                                                                               
                                                                               
                                                                               
Command: _____________________________________________________________________ 
Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
      Help  Sort  Exit              --           +                      Menu   

This section covers the following topics:

Fields Selected

Field System Name Order Sum Min Max Avg Pct Rate Round
CQJOB 1              
FILE 2              
CMD 3              
IOS   Y            
COMMANDS   Y            
CMDRESP   Y            
ADADURA   Y            

Report Options Selected

Defaults.

Report Processing Rules

None.

Last 500 Adabas Calls Report

The Last 500 Adabas Calls report lists the last 500 Adabas call in order by Adabas sequence number. This report uses the report option "DISPLAY BY=SORTEDDE" which lists the calls in order by sequence number, starting with the most recent sequence number first.

The order in which the sequence numbers are displayed may be changed by using a different "DISPLAY BY=" option. The number of calls shown can be varied from 500, by changing the "ENTRIES=" option to any number desired. For example, "ENTRIES=100" displays the last 100 Adabas calls.

03:57:18                    LAST 500 ADABAS CALLS                    2016-06-20
                 03:38:15 2016-06-20 Thru 03:57:07 2016-06-20                  
                                                                     Page:    1
                                                                               
 Sequence  TPUserid NAT-Appl NAT-Pgm   File  Cmd Rsp     Total-Dur            
 --------- -------- -------- -------- ---- --- ---- ----------------
    228047 USER1    SYS410DB SR-00038    0 RC     0         0.000304
    228046 USER1    SYS410DB SR-00038   17 L3     0         0.000864
    228045 USER1    SYS410DB SR-00038   17 L3     0         0.005328
    228044 USER1    SYS410DB SR-00038   17 L3     0         0.000512
    228043 USER1    SYS410DB SR-00038   17 L3     0         0.004272
    228042 USER1    SYS410DB SR-00038   17 L3     0         0.000640
    228041 USER1    SYS410DB SR-00038   17 L3     0         0.089600
    228040 USER2    SYS410DB P-DBLS      0 RC     0         0.000320
    228039 USER3    SYS410DB S-DBEXIT    0 ET     0         0.030048
    228038 USER3    SYS410DB S-DBEXIT   17 A1     0         0.029248
    228037 USER3    SYS410DB S-DBEXIT   17 S4     0         0.000768
    228036 USER3    SYS410DB S-DBEXIT   17 A1     0         0.026256
    228035 USER3    SYS410DB S-DBEXIT   17 S4     0         0.000544
 Command: _____________________________________________________________________
 Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
       Help  Sort  Exit                           +               ===>  Menu

This section covers the following topics:

Fields Selected

Field System Name Order Sum Min Max Avg Pct Rate Round
SEQ 1              
TPUSERID 2              
NATAPPL 3              
NATPROG 4              
FILE 5              
CMD 6              
RSP 7              
TOTDURA 8              
IOS 9              

Report Options Selected

WRAPPING = Y
MAX K = 48
DISPLAY BY = SORTEDDE
ENTRIES = 500

Report Processing Rules

None.

Long Running Commands Report

The Long Running Commands report shows commands with a duration greater than three seconds and I/Os greater than 200.

The report processing rule "ADADURA GT 3.0" determines that commands with a duration greater than three seconds are selected for this report; to change the duration for the commands selected, change the number "3.0" to any number desired. Similarly, the report processing rule "IOS GT 200" selects commands with more than 200 I/Os; to change the I/O criterion for the commands selection, change "200" to any number desired.

11:54:53                     LONG RUNNING COMMANDS                 2016-07-07
                    09:52:56 2016-06-16 Thru 11:50:35 2016-06-16              
    Seq     CQ-Job  TPUserid NAT-Appl NAT-Pgm  Cmd File Rsp       IOs
 --------- -------- -------- -------- -------- --- ---- ---- -------------
  13375591 COM000R  USER1    SYSCNT2  NIDES2   S1    65    0          389
  13377560 COM000R  USER2    SYSCNT2  NIDES2   S1    65    0          383
  13384954 COM000R  USER3    SYSCNT2  NIDES2   S1    65    0          393
  13390282 COM000R  USER4    SYSCNT2  NIDES2   S1    65    0          386
  13393597 COM000R  USER5    SYSCNT2  NIDES2   S1    65    0          388
  13404627 COM000R  USER6    SYSCNT2  NIDES2   S1    65    0          489
 ********* ******** ******** ******** ******** *** **** *****************
 *****   E N D    O F    R E P O R T   *****

 Command: _____________________________________________________________________
 Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
       Help  Sort  Exit                           +                ===>  Menu

This section covers the following topics:

Fields Selected

Field System Name Order Sum Min Max Avg Pct Rate Round
SEQ 1              
CQJOB 2              
TPUSERID 3              
NATAPPL 4              
NATPROG 5              
CMD 6              
FILE 7              
RSP 8              
IOS 9              
ADADURA 10              
CID 11              

Report Options Selected

Defaults.

Report Processing Rules

ADADURA  GT  3.0  AND
IOS  GT  200

Maximum PCT Space Used

The Maximum PCT Space Used report shows the maximum buffer usage in percent of various Adabas Nucleus buffers. The values are taken from Adabas Nucleus statistical buffer fields.

Here is a sample of the report:

13:44:34                   MAXIMUM PCT SPACE USED                    2020-02-21
                   2020-02-21 13:44:17 - 2020-02-21 13:44:33                   
                                                                        Page: 1
         Max        Max        Max        Max         Max         Max          
DBID  AB-Max-Pct CQ-Max-Pct  DUQ-Pct   HQ-Max-Pct LFP-Max-Pct LWP-Max-Pct      
----- ---------- ---------- ---------- ---------- ----------- -----------      
                                                                              
  129        0          0            0        0          0           0         
  177        2          0            0        1         31           6         
11177        3          0            0        7         35          12         
*****        3          0            0        7         35          12         
                                                                              
*****   E N D    O F    R E P O R T   *****                                    

                                                                             
Command: _____________________________________________________________________
Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
      Help  Sort  Exit                           +                      Menu

This section covers the following topics:

Fields Selected

Field System Name Order Sum Min Max Avg Pct Rate Round
DBID 1              
ABPCT       Y        
CQPCT       Y        
DQPCT       Y        
HQPCT       Y        
LFPPCT       Y        
LWPPCT       Y        
PIPCT       Y        
RDPCT       Y        
RPPCT       Y        
SCPCT       Y        
TIPCT       Y        
TSPCT       Y        
WIPCT       Y        

Report Options Selected

Defaults.

Report Processing Rules

None.

Natural Program Trace Report

The Natural Program Trace report shows processing activity for a specific Natural program, sorted by Adabas sequence number. To specify the program to be reported on, use the processing rules:

NATAPPL  EQ MYLOGON

where MYLOGON is the program library name; and

NATPROG  EQ MYPROG

where MYPROG is the program name.

Here is a sample of the report:

15:14:55                     NATURAL PROGRAM TRACE                  2016-07-07
                  14:12:56 2016-06-28 Thru 14:12:59 2016-06-28                 
                                                                       
    
    Seq    Cmd File Rsp    CID        ADA-Dur         Cmd-Resp        IOs
 --------- --- ---- ---- -------- ---------------- -------------- -------------
        
    375126 L3    12    0 09700101         0.004672       0.000112            1
    375127 L3    12    0 09700101         0.003184       0.000112            0
    375128 L3    12    0 09700101         0.000384       0.000112            0
    375129 L3    12    0 09700101         0.000496       0.000112            0
    375130 L3    12    0 09700101         0.000384       0.000112            0
    375131 L3    12    0 09700101         0.000352       0.000112            0
    375132 L3    12    0 09700101         0.001456       0.000112            0
    375133 L3    12    0 09700101         0.000352       0.000112            0
    375134 L3    12    0 09700101         0.000352       0.000112            0
    375135 L3    12    0 09700101         0.000432       0.000112            0
    375136 L3    12    0 09700101         0.000528       0.000112            0
    375137 L3    12    0 09700101         0.000352       0.000112            0
    375138 S1     0   17 47550101         0.000048       0.000144            0
                                                                              
 Command: _____________________________________________________________________
 Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
       Help  Sort  Exit                           +                      Menu

This section covers the following topics:

Fields Selected

Field System Name Order Sum Min Max Avg Pct Rate Round
SEQUENCE 1              
CMD 2              
FILE 3              
RSP 4              
CID 5              
ADADURA 6              
CMDRESP 7              
IOS 8              

Report Options Selected

Defaults.

Report Processing Rules

NATAPPL  EQ MYLOGON AND
NATPROG  EQ MYPROG

Natural Summary Report

The Natural Summary report shows processing activity for a Natural application on a program-by-program basis.

10:57:09                       NATURAL SUMMARY                       2016-06-24
                 10:56:59 2016-06-24 Thru 10:57:04 2016-06-24                  
                                                                     Page:    1
                                 Total        Total         Total              
NAT-Appl NAT-Pgm   File  Cmd  Num-of-IOs     Commands      Cmd-Resp            
-------- -------- ------ --- ------------- ------------ --------------         
                                                                               
SYSREVDB N--FKEYW      0 RC              0            1       1.000000         
         N--FKEYW      8 L3              0            1       1.000000         
         N--RPROF      0 RC              0            2       2.000000         
         N--RPROF      8 L3              0            2       2.000000         
         N--UPROF      8 S1              0            2       2.000000         
         N-NTFILE      8 S1              0            2       2.000000         
         P-DBLR        0 RC              0            3       3.000000         
         P-DBLR        8 L3              0            1       1.000000         
         P-DBLR        8 S1              1            2       2.000000         
         P-DBLR       33 S1              0            1       1.000000         
         P-DBLS        0 RC              0            1       1.000000         
         P-DBLS        8 L3              0            1       1.000000         
         P-DBLS        8 S1              0            1       1.000000         
                                                                               
Command: _____________________________________________________________________
Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
      Help  Sort  Exit              --    Rdsp   +                ===>  Menu   
10:57:09                       NATURAL SUMMARY                       2016-06-24
                 10:56:59 2016-06-24 Thru 10:57:04 2016-06-24                  
                                                                               
              Total                                                            
NAT-Appl     ADA-Dur                                                           
-------- ----------------                                                      
                                                                               
SYSREVDB         1.048576                                                      
                 1.048576                                                      
                 2.097152                                                      
                 2.097152                                                      
                 2.097152                                                      
                 2.097152                                                      
                 3.145728                                                      
                 1.048576                                                      
                 2.097152                                                      
                 1.048576                                                      
                 1.048576                                                      
                 1.048576                                                      
                 1.048576                                                      
                                                                               
Command: _____________________________________________________________________ 
Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
      Help  Sort  Exit              --    Rdsp   +          <===        Menu   

This section covers the following topics:

Fields Selected

Field System Name Order Sum Min Max Avg Pct Rate Round
NATAPPL 1              
NATPROG 2              
FILE 3              
CMD 4              
IOS   Y            
COMMANDS   Y            
CMDRESP   Y            
ADADURA   Y            

Report Options Selected

Defaults.

Report Processing Rules

None.

Natural Transaction Trace Report

The Natural Transaction Trace report shows processing activity by transaction number using the TPTRANNM field. Data is broken down by Natural application and program name.

04:06:06                  NATURAL TRANSACTION TRACE                  2016-06-20
                 03:38:39 2016-06-20 Thru 04:05:15 2016-06-20                  
                                                                     Page:    1
                                                Total
  Trans Nr   NAT-Appl NAT-Pgm  File Cmd Rsp    Commands
 ----------- -------- -------- ---- --- ---- ------------
         140 SYS410DB P-DBST      0 RC     0            1
             SYS410DB P-DBST      0 S1    17            1
             SYS410DB S-DBEXIT    0 ET     0            1
 *********** ******** ******** **** *** ****            3
         141 SYS410DB S-ST241     0 ET     0            1
             SYS410DB S-ST241    17 A1     0            2
             SYS410DB S-ST241    17 S4     0            2
 *********** ******** ******** **** *** ****            5
         595 PAC13               15 L3     0           11
 *********** ******** ******** **** *** ****           11
         596 PAC13               15 L3     0           11
 *********** ******** ******** **** *** ****           11
         597 PAC13                0 RC     0            1
 Command: _____________________________________________________________________
 Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
       Help  Sort  Exit                           +                      Menu

This section covers the following topics:

Fields Selected

Field System Name Order Sum Min Max Avg Pct Rate Round
TPTRANNM 1              
NATAPPL 2              
NATPROG 3              
FILE 4              
CMD 5              
RSP 6              
COMMANDS   Y            

Report Options Selected

Defaults.

Report Processing Rules

None.

PRILOG Report

The PRILOG Report duplicates the information provided by the PRILOG program, which is supplied with Adabas and is used to print command logs.

This section covers the following topics:

Fields Selected

Field System Name Order Sum Min Max Avg Pct Rate Round
SEQUENCE 1              
TIME 2              
DURATION 3              
CQJOB 4              
USERID 5              
CMD 6              
RSP 7              
CID 8              
FILE 9              
ISN 10              
THREAD 11              
PRI 12              
ASSOIO 13              

Report Options Selected

Defaults.

Report Processing Rules

None.

Rate of Commands and I/Os by Date Report

The Rate of Commands and I/Os by Date report calculates and displays the total and average rate of commands and I/Os by hour for a specific date.

12:30:37              RATE OF COMMANDS AND IOS BY DATE               2016-06-22
                 04:10:23 2016-06-20 Thru 12:29:51 2016-06-22                  
                                                                     Page:    1
                     Total        Total        Rate      Rate                  
   Date    Time   Num-of-IOs     Commands   Num-of-IOs Commands                
---------- ----- ------------- ------------ ---------- ---------               
                                                                               
2016-06-20 04:00             0           41       0.0        0.0               
********** *****             0           41                                    
2016-06-22 12:00             0          174       0.0        0.0               
********** *****             0          174                                    
********** *****             0          215                                    
                                                                               
*****   E N D    O F    R E P O R T   *****                                    
                                                                               
                                                                               
                                                                               
                                                                               
                                                                               
                                                                               
                                                                               
Command: _____________________________________________________________________ 
Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
      Help  Sort  Exit              --           +                      Menu   

This section covers the following topics:

Fields Selected

Field System Name Order Sum Min Max Avg Pct Rate Round
DATE 1              
HOUR 2              
IOS   Y         Y  
COMMANDS   Y         Y  

Report Options Selected

MAX K = 16

Report Processing Rules

None.

Rate of Commands and I/Os by Hour Report

The Rate of Commands and I/Os by Hour report calculates and displays the total and average rate of commands and I/Os by hour.

12:32:48              RATE OF COMMANDS AND IOS BY HOUR               2016-06-22
                 04:10:29 2016-06-20 Thru 12:32:14 2016-06-22                  
                                                                     Page:    1
          Total        Total        Rate      Rate                             
Time   Num-of-IOs     Commands   Num-of-IOs Commands                           
----- ------------- ------------ ---------- ---------                          
        
 04:00            41           71       0.0       0.0
 05:00          2503         6040       0.7       1.7
 06:00          5189        12280       1.5       3.4
 07:00          3408         9674       1.0       2.8                  
 08:00         12024        39308       3.4      11.1
 09:00         10970        24753       9.9      22.3
 *****         34135        92126                 
                                                  
       
 *****   E N D    O F    R E P O R T   *****
 
        
        
 Command: _____________________________________________________________________
 Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
       Help  Sort  Exit                           +                      Menu

This section covers the following topics:

Fields Selected

Field System Name Order Sum Min Max Avg Pct Rate Round
HOUR 1              
IOS   Y         Y  
COMMANDS   Y         Y  

Report Options Selected

Defaults.

Report Processing Rules

None.

Remote Physical Calltype

The Remote Physical Calltype report shows if an Adabas calls was issued as a standard "PHYSICAL" Adabas call or a "REMOTE" call arriving via Entire Net-Work.

13:55:25                  REMOTE PHYSICAL CALLTYPE                   2020-02-21
                    2020-02-21 13:55:17 - 2020-02-21 13:55:24                   
                                                                         Page: 1
                                                                                
 DBID    Job    Call Type User-Type                                             
 ----- -------- --------- ---------                                             
                                                                                
   129 DAEFCO   PHYSICAL  COMPLETE                                              
 ***** ******** ********* *********                                             
   177 DAEFCO   PHYSICAL  COMPLETE                                              
       HUB129   PHYSICAL                                                        
 ***** ******** ********* *********                                             
 11177 DAEFCO   PHYSICAL  COMPLETE                                              
       DAEFNBS  PHYSICAL  BATCH                                                 
       HUB129   PHYSICAL                                                        
       SDEPQA   PHYSICAL                                                        
 ***** ******** ********* *********                                             
 ***** ******** ********* *********                                             
                                                                                
 *****   E N D    O F    R E P O R T   *****                                     
        
        
 Command: _____________________________________________________________________
 Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
       Help  Sort  Exit                           +                      Menu

This section covers the following topics:

Fields Selected

Field System Name Order Sum Min Max Avg Pct Rate Round
DBID 1              
JOBNAME 2              
CALLTYPE 3              
USERTYPE 4              

Report Options Selected

Defaults.

Report Processing Rules

None.

Schedule File Usage Report

The Schedule File Usage report returns the same fields as the File Usage report described above. However, the Schedule File Usage report is defined with scheduling report options.

Report Options Selected

Scheduling Active = N                      
Date/Time From    = TODAY      12:00       
Date/Time To      = TODAY+7    12:00       
Duration          = 10     M (Min/Hour/Day)
Interval          = 60     M (Min/Hour/Day)

Summary Report by File Report

The Summary Report by File shows Adabas processing activity by file number and file name. Within each file, command types are listed, showing the total number of this type of command, total and average I/Os, total and average Adabas thread processing time (ADADURA), and total and average command response time (CMDRESP).

12:34:51                   SUMMARY REPORT BY FILE                    2016-06-22
                 04:10:37 2016-06-20 Thru 12:34:40 2016-06-22                  
                                                                     Page:    1
                                Total        Total          Total              
 File     File Name     Cmd  Num-of-IOs     Commands       ADA-Dur             
------ ---------------- --- ------------- ------------ ----------------        
                                                                               
     0                  OP              0            1         0.096368        
                        RC              0           24         0.002512        
****** **************** ***             0           25         0.098880        
    50                  L3              0            1         0.000000        
        ?USER  Reposito L1              0            1         0.000288        
        ?USER  Reposito L3              0          165         0.035312        
        ?USER  Reposito S1              0           28         0.014752        
****** **************** ***             0          195         0.050352        
****** **************** ***             0          220         0.149232        
                                                                               
*****   E N D    O F    R E P O R T   *****                                    
                                                                               
                                                                               
                                                                               
Command: _____________________________________________________________________ 
Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
      Help  Sort  Exit              --           +                ===>  Menu   
12:34:51                   SUMMARY REPORT BY FILE                    2016-06-22
                 04:10:37 2016-06-20 Thru 12:34:40 2016-06-22                  
                                                                               
           Total           Avg            Avg             Avg                  
 File     Cmd-Resp     Num-of-IOs       ADA-Dur         Cmd-Resp               
------ -------------- ------------- ---------------- --------------            
                                                                               
     0       0.506112         0.000         0.096368       0.506112            
             0.043008         0.000         0.000104       0.001792            
             0.549120         0.000         0.003955       0.021964            
    50       0.081920         0.000         0.000000       0.081920            
             0.704768         0.000         0.000288       0.704768            
            13.647872         0.000         0.000214       0.082714            
             3.218432         0.000         0.000526       0.114944            
            17.652992         0.000         0.000258       0.090528            
            18.202112         0.000         0.000678       0.082736            
                                                                               
                                                                               
                                                                               
                                                                               
                                                                               
Command: _____________________________________________________________________ 
Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
      Help  Sort  Exit              --           +          <===        Menu   

This section covers the following topics:

Fields Selected

Field System Name Order Sum Min Max Avg Pct Rate Round
FILE 1              
FILENAME 2              
CMD 3              
IOS   Y     Y      
COMMANDS   Y            
ADADURA   Y     Y      
CMDRESP   Y     Y      

Report Options Selected

AUTOSTART = Y
MAX K = 8

Report Processing Rules

None.

Thread Activity Report

The Thread Activity report shows processing activity broken down for individual Adabas threads. Each thread number shows the total number of commands, the total and average number of I/Os, and the average amount of command processing time per command; i.e., the time the command spent in the command queue added to the Adabas command processing time (TOTDURA).

12:37:06                       THREAD ACTIVITY                       2016-06-22
                 04:10:46 2016-06-20 Thru 12:36:44 2016-06-22                  
                                                                     Page:    1
           Total        Total          Avg            Avg                      
Thread  Num-of-IOs     Commands    Num-of-IOs      Total-Dur                   
------ ------------- ------------ ------------- ----------------               
  1            12743        27843         0.457         0.011301 
  2              470         1024         0.458         0.016938
  3              133          159         0.836         0.019639
******         13346        29026         0.459         0.011546
*****   E N D    O F    R E P O R T   *****



 Command: _____________________________________________________________________
 Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
       Help  Sort  Exit                           +                      Menu

This section covers the following topics:

Fields Selected

Field System Name Order Sum Min Max Avg Pct Rate Round
THREAD 1              
IOS   Y     Y      
COMMANDS   Y            
TOTDURA         Y      

Report Options Selected

Defaults.

Report Processing Rules

None.

Thread Activity by Command Report

The Thread Activity by Command report breaks thread activity down into command types, then shows the total number of commands, the total and average number of I/Os per command, and the total and average amount of command processing time per command.

12:42:29                 THREAD ACTIVITY BY COMMAND                  2016-06-22
                 12:40:31 2016-06-22 Thru 12:42:13 2016-06-22                  
                                                                     Page:    1
               Total        Total          Total            Total              
Thread Cmd  Num-of-IOs     Commands      Total-Dur         ADA-Dur             
------ --- ------------- ------------ ---------------- ----------------        
                                                                               
  1    L3              0           18     65281.124466         0.002160        
       RC              0            1      3840.066162         0.000144        
       S1              0           36    138242.384728         0.008080        
****** ***             0           55    207363.575356         0.010384        
****** ***             0           55    207363.575356         0.010384        
                                                                               
*****   E N D    O F    R E P O R T   *****                                    
                                                                               
                                                                               
                                                                               
                                                                               
                                                                               
                                                                               
                                                                               
Command: _____________________________________________________________________ 
Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
      Help  Sort  Exit              --           +                ===>  Menu   
12:42:29                 THREAD ACTIVITY BY COMMAND                  2016-06-22
                 12:40:31 2016-06-22 Thru 12:42:13 2016-06-22                  
                                                                               
            Total            Avg            Avg              Avg               
Thread      CQ Dur       Num-of-IOs      Total-Dur         ADA-Dur             
------ ---------------- ------------- ---------------- ----------------        
                                                                               
  1        65281.122306         0.000      3626.729137         0.000120        
            3840.066018         0.000      3840.066162         0.000144        
          138242.376648         0.000      3840.066242         0.000224        
          207363.564972         0.000      3770.246824         0.000188        
          207363.564972         0.000      3770.246824         0.000188        
                                                                               
                                                                               
                                                                               
                                                                               
                                                                               
                                                                               
                                                                               
                                                                               
                                                                               
Command: _____________________________________________________________________ 
Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
      Help  Sort  Exit              --           +          <===  ===>  Menu   
12:42:29                 THREAD ACTIVITY BY COMMAND                  2016-06-22
                 12:40:31 2016-06-22 Thru 12:42:13 2016-06-22                  
                                                                               
             Avg                                                               
Thread      CQ Dur                                                             
------ ----------------                                                        
                                                                               
  1         3626.729017                                                        
            3840.066018                                                        
            3840.066018                                                        
            3770.246635                                                        
            3770.246635                                                        
                                                                               
                                                                               
                                                                               
                                                                               
                                                                               
                                                                               
                                                                               
                                                                               
                                                                               
Command: _____________________________________________________________________ 
Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
      Help  Sort  Exit              --           +          <===        Menu   

This section covers the following topics:

Fields Selected

Field System Name Order Sum Min Max Avg Pct Rate Round
THREAD 1              
CMD 2              
IOS   Y     Y      
COMMANDS   Y            
TOTDURA   Y     Y      
ADADURA   Y     Y      
CQDURA   Y     Y      

Report Options Selected

Defaults.

Report Processing Rules

None.

Transaction Count... Reports

For transaction numbers not equal to zero, the Transaction Count reports calculate and display the total:

  • number of completed Adabas transactions for the user;

  • number of commands performed for the transactions;

  • number of I/Os performed for the transactions;

  • amount of command processing time; i.e., the time Adabas spent to process the command, and the time the command spent in the command queue;

  • amount of time spent by Adabas to process the command;

  • amount of time the command spent in the command queue.

Transaction Count by Job Report

The Transaction Count by Job report is an example of a transaction count report.

17:58:55                   TRANSACTION COUNT BY JOB                2016-07-07
                  04:50:58 2016-06-15 Thru 17:58:54 2016-06-15               
             Total        Total         Total          Total
  CQ-Job   Trans-Cnt     Commands        IOs         Total-Dur
 -------- ------------ ------------ ------------- ----------------
 CICSPROD        35971       322386        169800      2751.100528
 CICSTEST         1352        19816          8503       377.155664
 USER1            1387        19958         10718       412.490496
 USER2              59          604           192         5.377152
 BATCHJOB            4          123            53         1.454592
 TSOUSER3            4          144           104         3.208336
 ********        38777       363031        189370      3550.786768
 *****   E N D    O F    R E P O R T   *****

 Command: _____________________________________________________________________
 Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
       Help  Sort  Exit                           +                ===>  Menu

This section covers the following topics:

Fields Selected

Field System Name Order Sum Min Max Avg Pct Rate Round
CQJOB 1              
TPTRANCT   Y            
COMMANDS   Y            
IOS   Y            
TOTDURA   Y            
ADADURA   Y            
CQDURA   Y            

Report Options Selected

Defaults.

Report Processing Rules

TPTRANNM  NE  0

Transaction Count by Job-NATAPPL Report

The Transaction Count by Job-NATAPPL report includes and sorts the transaction count report by job and Natural application name.

This section covers the following topics:

Fields Selected

Field System Name Order Sum Min Max Avg Pct Rate Round
CQJOB 1              
NATAPPL 2              
TPTRANCT   Y            
COMMANDS   Y            
IOS   Y            
TOTDURA   Y            
ADADURA   Y            
CQDURA   Y            

Report Options Selected

Defaults.

Report Processing Rules

TPTRANNM  NE  0

Transaction Count by Job-User Report

The Transaction Count by Job-User report includes and sorts the transaction count report by job and TP monitor user ID.

This section covers the following topics:

Fields Selected

Field System Name Order Sum Min Max Avg Pct Rate Round
CQJOB 1              
TPUSERID 2              
TPTRANCT   Y            
COMMANDS   Y            
IOS   Y            
TOTDURA   Y            
ADADURA   Y            
CQDURA   Y            

Report Options Selected

Defaults.

Report Processing Rules

TPTRANNM  NE  0

Transaction Count by Natural Report

The Transaction Count by Job-User report includes and sorts the transaction count report by Natural application name and program name.

This section covers the following topics:

Fields Selected

Field System Name Order Sum Min Max Avg Pct Rate Round
NATAPPL 1              
NATPROG 2              
TPTRANCT   Y            
COMMANDS   Y            
IOS   Y            
TOTDURA   Y            
ADADURA   Y            
CQDURA   Y            

Report Options Selected

Defaults.

Report Processing Rules

TPTRANNM  NE  0

Transaction Detailed Information Report

The Transaction Detailed Information report displays detailed processing information, by transaction number, for each transaction not equal to zero.

The processing rule "TPTRANNM NE 0" ensures that the transaction number will not be equal to zero.

Here is a sample report:

10:01:46               TRANSACTION DETAILED INFORMATION             2016-07-07
                  09:54:54 2016-06-26 Thru 09:56:18 2016-06-26                

  Trans Nr      Seq    TPUserid Cmd File Rsp       IOs          ADA-Dur
 ----------- --------- -------- --- ---- ---- ------------- ----------------
          87     50967 USER1    RC     0    0             0        0.000080
 *********** ********* ******** *** **** **** ************* ****************
          88     50968 USER1    S4    17    0             0        0.000320
                 50969 USER1    A1    17    0             0        0.000288
                 50970 USER1    S4    17    0             0        0.000464
                 50971 USER1    A1    17    0             0        0.002064
                 50972 USER1    ET     0    0             1        0.000064
 *********** ********* ******** *** **** **** ************* ****************
          89     51005 USER2    S4    17    0             0        0.000384
                 51006 USER2    A1    17    0             0        0.000400
                 51007 USER2    S4    17    0             0        0.000288
                 51008 USER2    A1    17    0             1        0.031280
                 51009 USER2    ET     0    0             1        0.000064
 Command: _____________________________________________________________________
 Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
       Help  Sort  Exit                           +                ===>  Menu

This section covers the following topics:

Fields Selected

Field System Name Order Sum Min Max Avg Pct Rate Round
TPTRANNM 1              
SEQUENCE 2              
TPUSERID 3              
CMD 4              
FILE 5              
RSP 6              
IOS 7              
ADADURA 8              
CMDRESP 9              
CQJOB 10              
COMMANDS 11              

Report Options Selected

MAX K = 32

Report Processing Rules

TPTRANNM  NE  0

Transaction Summary by User Report

Similar to the Transaction Count reports, the Transaction Summary by User calculates and displays information about a user's TP transaction for transaction numbers not equal to zero.

The processing rule "TPTRANNM NE 0" ensures that the transaction number will not be equal to zero.

Here is a sample report:

10:02:16                  TRANSACTION SUMMARY BY USER               2016-07-07
                  09:55:25 2016-06-26 Thru 10:01:21 2016-06-26                
                          Total        Total          Total
 TPUserid  Trans Nr        IOs        Commands      Total-Dur
 -------- ----------- ------------- ------------ ----------------
 USER1            654             4            4         0.048944
                  655            11           11         0.218096
                  656             2            4         0.048512
 ******** ***********            17           19         0.315552
 USER2            552            12            9         0.211936
                  553             4            3         0.108320
                  554             3            1         0.105456
                  555             4            2         0.103792
                  556             4            2         0.125264
                  557             3            3         0.076016
                  558             0            3         0.005376
 ******** ***********            30           23         0.736160
 USER3           2280             5           11         0.100288
 Command: _____________________________________________________________________
 Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
       Help  Sort  Exit                           +                ===>  Menu

This section covers the following topics:

Fields Selected

Field System Name Order Sum Min Max Avg Pct Rate Round
TPUSERID 1              
TPTRANNM 2              
IOS   Y            
COMMANDS   Y            
TOTDURA   Y            
ADADURA   Y            
CQDURA   Y            

Report Options Selected

MAX K = 16

Report Processing Rules

TPTRANNM  NE  0

Who is Using Natural? Report

The Who is Using Natural? report shows processing activity broken down by the individual user. Users are identified by their TP user ID.

10:51:51                    WHO IS USING NATURAL                     2016-06-24
                 10:51:40 2016-06-24 Thru 10:51:50 2016-06-24                  
                                                                     Page:    1
                                          Total        Total                   
TPUserid NAT-Appl NAT-Pgm   File  Cmd  Num-of-IOs     Commands                 
-------- -------- -------- ------ --- ------------- ------------               
                                                                               
XXX      SYSREVDB N-CHKMN       0 RC              0            8               
         SYSREVDB N-CHKMN       8 L3              0            8               
         SYSREVDB N-CHKMN       8 S1              0            8               
         SYSREVDB N-NTFILE      8 S1              0            2               
         SYSREVDB P-DBER        0 RC              0            5               
         SYSREVDB P-DBER        8 L3              0            5               
         SYSREVDB P-DBER        8 S1              0            6               
         SYSREVDB P-DBLR        0 RC              0            3               
         SYSREVDB P-DBLR        8 L3              0            1               
         SYSREVDB P-DBLR        8 S1              0            1               
         SYSREVDB P-DBLR       33 L3              0           36               
         SYSREVDB P-DBLS        0 RC              0            1               
         SYSREVDB P-DBLS        8 L3              2            1               
                                                                               
Command: _____________________________________________________________________
Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
      Help  Sort  Exit              --    Rdsp   +                ===>  Menu   
10:51:51                    WHO IS USING NATURAL                     2016-06-24
                 10:51:40 2016-06-24 Thru 10:51:50 2016-06-24                  
                                                                               
             Total           Total                                             
TPUserid    Cmd-Resp        ADA-Dur                                            
-------- -------------- ----------------                                       
                                                                               
XXX            8.000000         8.388608                                       
               8.000000         8.388608                                       
               8.000000         8.388608                                       
               2.000000         2.097152                                       
               5.000000         5.242880                                       
               5.000000         5.242880                                       
               6.000000         6.291456                                       
               3.000000         3.145728                                       
               1.000000         1.048576                                       
               1.000000         1.048576                                       
              36.000000        37.748736                                       
               1.000000         1.048576                                       
               1.000000         1.048576                                       
                                                                               
Command: _____________________________________________________________________ 
Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
      Help  Sort  Exit              --    Rdsp   +          <===        Menu    

This section covers the following topics:

Fields Selected

Field System Name Order Sum Min Max Avg Pct Rate Round
TPUSERID 1              
NATAPPL 2              
NATPROG 3              
FILE 4              
CMD 5              
IOS   Y            
COMMANDS   Y            
CMDRESP   Y            
ADADURA   Y            

Report Options Selected

Defaults.

Report Processing Rules

None.

Who Uses SYSMAIN? Report

The Who Uses SYSMAIN? report shows jobs which are using SYSMAIN. The job name is shown, listing the individual users, denoted by the user's TP user ID.

The report processing rule "NATAPPL EQ SYSMAIN" assures that only jobs using SYSMAIN are shown. This processing rule may be modified to equal any Natural application name.

Here is a sample report:

10:05:06                       WHO USES SYSMAIN                     2016-07-07
                  09:57:38 2016-06-26 Thru 09:57:41 2016-06-26                
                            Total         Total         Total
  CQ-Job  TPUserid File    Cmd-Resp      Commands        IOs
 -------- -------- ---- -------------- ------------ -------------
 COMPLETE USER1       0       0.000784           48             1
          USER1      15       0.000672            6             2
          USER1      16       0.000304            3             7
          USER1      17       0.011056          105            70
          USER1      18       0.001280            6            10
 ******** ******** ****       0.014096          168            90
 ******** ******** ****       0.014096          168            90
 *****   E N D    O F    R E P O R T   *****

 Command: _____________________________________________________________________
 Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
       Help  Sort  Exit                           +                ===>  Menu

This section covers the following topics:

Fields Selected

Field System Name Order Sum Min Max Avg Pct Rate Round
CQJOB 1              
TPUSERID 2              
FILE 3              
CMDRESP   Y            
COMMANDS   Y            
IOS   Y            
ADADURA   Y            

Report Options Selected

Defaults.

Report Processing Rules

NATAPPL  EQ  SYSMAIN

Worst Calls... Reports

The six Worst Calls reports list and calculate information about the 100 "worst" Adabas calls. Each report rates its commands according to certain criteria:

Worst Calls by ... Selects the 100 calls that ...
ADADURA required the most Adabas processing time, and calculates a total for Adabas processing time.
CQDURA spent the longest time in the command queue, and calculates a total for command queue duration.
DESCUPD required the most descriptor updates, and calculates the total number of descriptor updates.
IOS caused the most I/O operations to be performed, and calculates the total number of I/Os.
ISNQ required the most ISNs, and calculates the total number of ISNs.
TOTDURA required the longest processing time (i.e., time in the command queue and Adabas processing time) and calculates a total for processing time.

Worst Calls by ADADURA Report

The Worst Calls by ADADURA report is an example of a Worst Calls report.

11:48:29                  WORST CALLS BY-> ADADURA                   2016-06-24
                 11:48:22 2016-06-24 Thru 11:48:28 2016-06-24                  
                                                                     Page:    1
                                                                               
 Sequence    CQ-Job  TPUserid NAT-Appl NAT-Pgm  Cmd  File      ADA-Dur         
----------- -------- -------- -------- -------- --- ------ ----------------    
                                                                               
        123 XXX      XXX      SYSREVDB SR-00016 V4       0         0.000000    
        122 XXX      XXX      SYSREVDB SR-00016 S1       8         0.000071    
        121 XXX      XXX      SYSREVDB SR-00016 S1       8         0.005856    
        120 XXX      XXX      SYSREVDB P-DBVWRT RC       0         0.000384    
        119 XXX      XXX      SYSREVDB P-DBVWRT RC       0         0.000065    
        118 XXX      XXX      SYSREVDB P-DBVWRT L3       8         0.006766    
        117 XXX      XXX      SYSREVDB P-DBVWRT S1       8         0.000104    
        116 XXX      XXX      SYSREVDB USR1029N RC       0         0.000119    
        115 XXX      XXX      SYSREVDB USR1029N L3       8         0.014382    
*********** ******** ******** ******** ******** *** ****** ****************    
                                                                               
*****   E N D    O F    R E P O R T   *****                                    
                                                                               
                                                                               
Command: _____________________________________________________________________
Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
      Help  Sort  Exit              --    Rdsp   +                ===>  Menu   
11:48:29                  WORST CALLS BY-> ADADURA                   2016-06-24
                 11:48:22 2016-06-24 Thru 11:48:28 2016-06-24                  
                                                                               
                                              Total          Total             
 Sequence    Num-of-IOs      Cmd-Resp        ADA-Dur        Commands           
----------- ------------- -------------- ---------------- ------------         
                                                                               
        123             0       0.000000         0.000000            1         
        122             0       0.044000         0.000071            1         
        121             2       0.151750         0.005856            1         
        120             0       0.007500         0.000384            1         
        119             0       0.007625         0.000065            1         
        118             9       0.761750         0.006766            1         
        117             0       0.049000         0.000104            1         
        116             0       0.008000         0.000119            1         
        115             4       0.406875         0.014382            1         
            ************* **************         0.027747            9         
                                                                               
                                                                               
                                                                               
                                                                               
Command: _____________________________________________________________________ 
Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
      Help  Sort  Exit              --    Rdsp   +          <===        Menu   

This section covers the following topics:

Fields Selected

Field System Name Order Sum Min Max Avg Pct Rate Round
SEQUENCE 1              
CQJOB 2              
TPUSERID 3              
NATAPPL 4              
NATPROG 5              
CMD 6              
FILE 7              
ADADURA 8 Y            
IOS 9              
CMDRESP 10              
COMMANDS   Y            

Report Options Selected

DISPLAY BY = SUMFIELD
ENTRIES = 100

Report Processing Rules

None.

Worst Calls by CQ DURA Report

The Worst Calls by CQ DURA report is an example of a Worst Calls report.

12:08:15                  WORST CALLS BY-> CQ DURA                   2016-06-24
                 12:08:10 2016-06-24 Thru 12:08:14 2016-06-24                  
                                                                     Page:    1
                                                                               
 Sequence    CQ-Job  TPUserid NAT-Appl NAT-Pgm  Cmd  File       CQ Dur         
----------- -------- -------- -------- -------- --- ------ ----------------    
                                                                               
        277 XXX      XXX      SYSREVDB SR-00014 V4       0         0.000000    
        276 XXX      XXX      SYSREVDB SR-00014 S1       8         0.000384    
        275 XXX      XXX      SYSREVDB SR-00014 S1       8         0.000080    
        274 XXX      XXX      SYSREVDB P-DBLS   RC       0         0.000032    
        273 XXX      XXX      SYSREVDB P-DBLS   RC       0         0.000288    
        272 XXX      XXX      SYSREVDB P-DBLS   L3       8         0.000160    
        271 XXX      XXX      SYSREVDB P-DBLS   S1       8         0.000064    
*********** ******** ******** ******** ******** *** ****** ****************    
                                                                               
*****   E N D    O F    R E P O R T   *****                                    
                                                                               
                                                                               
                                                                               
                                                                               
Command: _____________________________________________________________________
Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
      Help  Sort  Exit              --    Rdsp   +                ===>  Menu   
 12:08:15                  WORST CALLS BY-> CQ DURA                   2016-06-24
                  12:08:10 2016-06-24 Thru 12:08:14 2016-06-24                  
                                                                                
                                                 Total                          
  Sequence       ADA-Dur       Num-of-IOs        CQ Dur                         
 ----------- ---------------- ------------- ----------------                    
                                                                                
         277         0.000000             0         0.000000                    
         276         0.000487             0         0.000384                    
         275         0.000167             0         0.000080                    
         274         0.000027             0         0.000032                    
         273         0.000319             0         0.000288                    
         272         0.013165             7         0.000160                    
         271         0.009379             1         0.000064                    
             **************** *************         0.001008                    
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
 Command: _____________________________________________________________________ 
 Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
       Help  Sort  Exit              --    Rdsp   +          <===        Menu   

This section covers the following topics:

Fields Selected

Field System Name Order Sum Min Max Avg Pct Rate Round
SEQUENCE 1              
CQJOB 2              
TPUSERID 3              
NATAPPL 4              
NATPROG 5              
CMD 6              
FILE 7              
CQDURA 8 Y            
ADADURA 9              
IOS 10              

Report Options Selected

DISPLAY BY = SUMFIELD
ENTRIES = 100

Report Processing Rules

None.

Worst Calls by DESC UPD Report

The Worst Calls by DESC UPD report is an example of a Worst Calls report.

 12:12:17                  WORST CALLS BY-> DESC UPD                  2016-06-24
                  12:12:16 2016-06-24 Thru 12:12:16 2016-06-24                  
                                                                      Page:    1
                                                                                
  Sequence    CQ-Job  TPUserid NAT-Appl NAT-Pgm  Cmd  File    Desc-Upd          
 ----------- -------- -------- -------- -------- --- ------ -------------       
                                                                                
         585 XXX      XXX      SYSREVDB SR-00015 V4       0             0       
         584 XXX      XXX      SYSREVDB P-DBVWRT RC       0             0       
         583 XXX      XXX      SYSREVDB P-DBVWRT RC       0             0       
         582 XXX      XXX      SYSREVDB P-DBVWRT L3       8             0       
         581 XXX      XXX      SYSREVDB P-DBVWRT S1       8             0       
         580 XXX      XXX      SYSREVDB USR1029N RC       0             0       
         579 XXX      XXX      SYSREVDB USR1029N L3       8             0       
         578 XXX      XXX      SYSREVDB USR1029N S1       8             0       
         577 XXX      XXX      SYSREVDB NAT00060 RC       0             0       
 *********** ******** ******** ******** ******** *** ****** *************       
                                                                                
 *****   E N D    O F    R E P O R T   *****                                    
                                                                                
                                                                                
 Command: _____________________________________________________________________
 Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
       Help  Sort  Exit              --    Rdsp   +                ===>  Menu   
 12:12:17                  WORST CALLS BY-> DESC UPD                  2016-06-24
                  12:12:16 2016-06-24 Thru 12:12:16 2016-06-24                  
                                                                                
                                                Total        Total              
  Sequence       ADA-Dur       Num-of-IOs     Desc-Upd      Commands            
 ----------- ---------------- ------------- ------------- ------------          
                                                                                
         585         0.000000             0             0            1          
         584         0.000117             0             0            1          
         583         0.000100             0             0            1          
         582         0.000481             0             0            1          
         581         0.007516             0             0            1          
         580         0.000493             0             0            1          
         579         0.003002             0             0            1          
         578         0.000925             0             0            1          
         577         0.000040             0             0            1          
             **************** *************             0            9          
                                                                                
                                                                                
                                                                                
                                                                                
 Command: _____________________________________________________________________
 Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
       Help  Sort  Exit              --    Rdsp   +          <===        Menu    

This section covers the following topics:

Fields Selected

Field System Name Order Sum Min Max Avg Pct Rate Round
SEQUENCE 1              
CQJOB 2              
TPUSERID 3              
NATAPPL 4              
NATPROG 5              
CMD 6              
FILE 7              
DESUPD 8 Y            
ADADURA 9              
IOS 10              
COMMANDS   Y            

Report Options Selected

DISPLAY BY = SUMFIELD
ENTRIES = 100

Report Processing Rules

None.

Worst Calls by IOs Report

The Worst Calls by IOs report is an example of a Worst Calls report.

  12:20:02                    WORST CALLS BY-> IOS                     2016-06-24
                  12:19:53 2016-06-24 Thru 12:20:01 2016-06-24                  
                                                                      Page:    1
                                                                                
  Sequence    CQ-Job  TPUserid NAT-Appl NAT-Pgm  Cmd  File   Num-of-IOs         
 ----------- -------- -------- -------- -------- --- ------ -------------       
                                                                                
         767 XXX      XXX      SYSREVDB SR-00017 V4       0             0       
         766 XXX      XXX      SYSREVDB P-DBVWRT RC       0             0       
         765 XXX      XXX      SYSREVDB P-DBVWRT RC       0             0       
         764 XXX      XXX      SYSREVDB P-DBVWRT L3       8             7       
         763 XXX      XXX      SYSREVDB P-DBVWRT S1       8             0       
         762 XXX      XXX      SYSREVDB USR1029N RC       0             0       
         761 XXX      XXX      SYSREVDB USR1029N L3       8             0       
         760 XXX      XXX      SYSREVDB USR1029N S1       8             0       
 *********** ******** ******** ******** ******** *** ****** *************       
                                                                                
 *****   E N D    O F    R E P O R T   *****                                    
                                                                                
                                                                                
                                                                                
 Command: _____________________________________________________________________
 Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
       Help  Sort  Exit              --    Rdsp   +                ===>  Menu   
12:20:02                    WORST CALLS BY-> IOS                     2016-06-24
                 12:19:53 2016-06-24 Thru 12:20:01 2016-06-24                  
                                                                               
                                                Total        Total             
 Sequence       ADA-Dur         Cmd-Resp     Num-of-IOs     Commands           
----------- ---------------- -------------- ------------- ------------         
                                                                               
        767         0.000000       0.000000             0            1         
        766         0.000096       0.007250             0            1         
        765         0.000211       0.012875             0            1         
        764         0.026738       1.184625             7            1         
        763         0.000160       0.095125             0            1         
        762         0.000620       0.004750             0            1         
        761         0.000252       0.175750             0            1         
        760         0.000708       0.087625             0            1         
            **************** **************             7            8         
                                                                               
                                                                               
                                                                               
                                                                               
                                                                               
Command: _____________________________________________________________________ 
Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
      Help  Sort  Exit              --    Rdsp   +          <===        Menu    

This section covers the following topics:

Fields Selected

Field System Name Order Sum Min Max Avg Pct Rate Round
SEQUENCE 1              
CQJOB 2              
TPUSERID 3              
NATAPPL 4              
NATPROG 5              
CMD 6              
FILE 7              
IOS 8 Y            
ADADURA 9              
CMDRESP 10              
COMMANDS   Y            

Report Options Selected

DISPLAY BY = SUMFIELD
ENTRIES = 100

Report Processing Rules

None.

Worst Calls by ISN QUAN Report

The Worst Calls by ISN QUAN report is an example of a Worst Calls report.

12:25:36                  WORST CALLS BY-> ISN QUAN                  2016-06-24
                 12:25:27 2016-06-24 Thru 12:25:35 2016-06-24                  
                                                                     Page:    1
                                                                               
 Sequence    CQ-Job  TPUserid NAT-Appl NAT-Pgm  Cmd  File     ISN-Qty          
----------- -------- -------- -------- -------- --- ------ -------------       
                                                                               
        934 XXX      XXX      SYSREVDB P-DBVWRT L3       8             0       
        933 XXX      XXX      SYSREVDB P-DBVWRT S1       8             1       
        932 XXX      XXX      SYSREVDB USR1029N RC       0             0       
        931 XXX      XXX      SYSREVDB USR1029N L3       8             0       
        930 XXX      XXX      SYSREVDB USR1029N S1       8             1       
*********** ******** ******** ******** ******** *** ****** *************       
                                                                               
*****   E N D    O F    R E P O R T   *****                                    
                                                                               
                                                                               
                                                                               
                                                                               
                                                                               
                                                                               
Command: _____________________________________________________________________
Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
      Help  Sort  Exit              --    Rdsp   +                ===>  Menu   
12:25:36                  WORST CALLS BY-> ISN QUAN                  2016-06-24
                 12:25:27 2016-06-24 Thru 12:25:35 2016-06-24                  
                                                                               
                                               Total        Total              
 Sequence       ADA-Dur       Num-of-IOs      ISN-Qty      Commands            
----------- ---------------- ------------- ------------- ------------          
                                                                               
        934         0.015030             7             0            1          
        933         0.000056             0             1            1          
        932         0.000026             0             0            1          
        931         0.000107             0             0            1          
        930         0.000096             0             1            1          
            **************** *************             2            5          
                                                                               
                                                                               
                                                                               
                                                                               
                                                                               
                                                                               
                                                                               
                                                                               
Command: _____________________________________________________________________
Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
      Help  Sort  Exit              --    Rdsp   +          <===        Menu   

This section covers the following topics:

Fields Selected

Field System Name Order Sum Min Max Avg Pct Rate Round
SEQUENCE 1              
CQJOB 2              
TPUSERID 3              
NATAPPL 4              
NATPROG 5              
CMD 6              
FILE 7              
ISNQ 8 Y            
ADADURA 9              
IOS 10              
COMMANDS   Y            

Report Options Selected

DISPLAY BY = SUMFIELD
ENTRIES = 100

Report Processing Rules

None.

Worst Calls by TOTDURA Report

The Worst Calls by TOTDURA report is an example of a Worst Calls report.

12:41:07                  WORST CALLS BY-> TOTDURA                   2016-06-24
                 12:41:07 2016-06-24 Thru 12:41:07 2016-06-24                  
                                                                     Page:    1
                                                                               
 Sequence   TPUserid NAT-Pgm  Cmd    Total-Dur         ADA-Dur                 
----------- -------- -------- --- ---------------- ----------------            
                                                                               
       1110 XXX      SR-00019 V4          0.000000         0.000000            
       1109 XXX      SR-00019 S1          0.000344         0.000184            
       1108 XXX      SR-00019 S1          0.001312         0.000720            
       1107 XXX      P-DBVWRT RC          0.000035         0.000019            
       1106 XXX      P-DBVWRT RC          0.000075         0.000043            
*********** ******** ******** *** **************** ****************            
                                                                               
*****   E N D    O F    R E P O R T   *****                                    
                                                                               
                                                                               
                                                                               
                                                                               
                                                                               
                                                                               
Command: _____________________________________________________________________
Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
      Help  Sort  Exit              --    Rdsp   +                ===>  Menu   
12:41:07                  WORST CALLS BY-> TOTDURA                   2016-06-24
                 12:41:07 2016-06-24 Thru 12:41:07 2016-06-24                  
                                                                               
                                                           Total               
 Sequence        CQ Dur       File   CQ-Job  NAT-Appl    Total-Dur             
----------- ---------------- ------ -------- -------- ----------------         
                                                                               
       1110         0.000000      0 XXX      SYSREVDB         0.000000         
       1109         0.000160      8 XXX      SYSREVDB         0.000344         
       1108         0.000592      8 XXX      SYSREVDB         0.001312         
       1107         0.000016      0 XXX      SYSREVDB         0.000035         
       1106         0.000032      0 XXX      SYSREVDB         0.000075         
            **************** ****** ******** ********         0.001766         
                                                                               
                                                                               
                                                                               
                                                                               
                                                                               
                                                                               
                                                                               
                                                                               
Command: _____________________________________________________________________
Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
      Help  Sort  Exit              --    Rdsp   +          <===  ===>  Menu   

This section covers the following topics:

Fields Selected

Field System Name Order Sum Min Max Avg Pct Rate Round
SEQUENCE 1              
TPUSERID 2              
NATPROG 3              
CMD 4              
TOTDURA 5 Y            
ADADURA 6              
CQDURA 7              
FILE 8              
CQJOB 9              
NATAPPL 10              
COMMANDS   Y            

Report Options Selected

DISPLAY BY = SUMFIELD
ENTRIES = 100

Report Processing Rules

None.

Worst Transactions... Reports

The three Worst Transactions reports list and calculate information about the 100 worst transactions. Each report rates its transactions according to certain criteria:

Worst Transactions by ... Selects the 100 transactions that ...
Calls issued the most Adabas calls.
Duration required the most Adabas processing time, including time spent in the command queue.
IOS caused the most I/O operations to be performed.

The number of transactions shown can be varied from 100, by changing the "ENTRIES=" option to any number desired. For example, "ENTRIES=50" displays the 50 worst transactions.

Worst Transactions by Calls Report

The report Worst Transactions by Calls report is an example of a Worst Transactions report.

12:47:50                 WORST TRANSACTIONS BY CALLS                 2016-06-24
                 12:45:38 2016-06-24 Thru 12:47:49 2016-06-24                  
                                                                     Page:    1
                                  Total        Total          Total            
 Trans Nr   TPUserid NAT-Appl  Num-of-IOs     Commands      Total-Dur          
----------- -------- -------- ------------- ------------ ----------------      
                                                                               
          0 XXX      SYSREVDB             9           56         0.053288      
*********** ******** ********             9           56         0.053288      
                                                                               
*****   E N D    O F    R E P O R T   *****                                    
                                                                               
                                                                               
                                                                               
                                                                               
                                                                               
                                                                               
                                                                               
                                                                               
                                                                               
                                                                               
Command: _____________________________________________________________________
Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
      Help  Sort  Exit              --    Rdsp   +                ===>  Menu  
12:47:50                 WORST TRANSACTIONS BY CALLS                 2016-06-24
                 12:45:38 2016-06-24 Thru 12:47:49 2016-06-24                  
                                                                               
                 Total            Total                                        
 Trans Nr       ADA-Dur           CQ Dur                                       
----------- ---------------- ----------------                                  
                                                                               
          0         0.036936         0.016352                                  
                    0.036936         0.016352                                  
                                                                               
                                                                               
                                                                               
                                                                               
                                                                               
                                                                               
                                                                               
                                                                               
                                                                               
                                                                               
                                                                               
                                                                               
Command: _____________________________________________________________________
Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
      Help  Sort  Exit              --    Rdsp   +          <===        Menu   

This section covers the following topics:

Fields Selected

Field System Name Order Sum Min Max Avg Pct Rate Round
TPTRANNM 1              
TPUSERID 2              
NATAPPL 3              
IOS   Y            
COMMANDS   Y            
TOTDURA   Y            
ADADURA   Y            
CQDURA   Y            

Report Options Selected

DISPLAY BY = USAGE
ENTRIES = 100

Report Processing Rules

None.

Worst Transactions by Duration Report

The report Worst Transactions by Duration report is an example of a Worst Transactions report.

12:52:32               WORST TRANSACTIONS BY DURATION                2016-06-24
                 12:52:20 2016-06-24 Thru 12:52:31 2016-06-24                  
                                                                     Page:    1
                                   Total          Total         Total          
 Trans Nr   TPUserid NAT-Appl    Total-Dur       Commands    Num-of-IOs        
----------- -------- -------- ---------------- ------------ -------------      
                                                                               
          0 XXX      SYSREVDB         0.075285           50             9      
*********** ******** ********         0.075285           50             9      
                                                                               
*****   E N D    O F    R E P O R T   *****                                    
                                                                               
                                                                               
                                                                               
                                                                               
                                                                               
                                                                               
                                                                               
                                                                               
                                                                               
                                                                               
Command: _____________________________________________________________________
Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
      Help  Sort  Exit              --    Rdsp   +                ===>  Menu   
 12:52:32               WORST TRANSACTIONS BY DURATION                2016-06-24
                  12:52:20 2016-06-24 Thru 12:52:31 2016-06-24                  
                                                                                
                  Total            Total                                        
  Trans Nr       ADA-Dur           CQ Dur                                       
 ----------- ---------------- ----------------                                  
                                                                                
           0         0.071541         0.003744                                  
                     0.071541         0.003744                                  
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
 Command: _____________________________________________________________________ 
 Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
       Help  Sort  Exit              --    Rdsp   +          <===        Menu   

This section covers the following topics:

Fields Selected

Field System Name Order Sum Min Max Avg Pct Rate Round
TPTRANNM 1              
TPUSERID 2              
NATAPPL 3              
TOTDURA   Y            
COMMANDS   Y            
IOS   Y            
ADADURA   Y            
CQDURA   Y            

Report Options Selected

DISPLAY BY = SUMFIELD
ENTRIES = 100

Report Processing Rules

None.

Worst Transactions by IOs Report

The report Worst Transactions by IOs report is an example of a Worst Transactions report.

12:56:58                  WORST TRANSACTIONS BY IOS                  2016-06-24
                 12:56:48 2016-06-24 Thru 12:56:58 2016-06-24                  
                                                                     Page:    1
                                  Total        Total          Total            
 Trans Nr   TPUserid NAT-Appl  Num-of-IOs     Commands      Total-Dur          
----------- -------- -------- ------------- ------------ ----------------      
                                                                               
          0 XXX      SYSREVDB             9           71         0.054694      
*********** ******** ********             9           71         0.054694      
                                                                               
*****   E N D    O F    R E P O R T   *****                                    
                                                                               
                                                                               
                                                                               
                                                                               
                                                                               
                                                                               
                                                                               
                                                                               
                                                                               
                                                                               
Command: _____________________________________________________________________
Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
      Help  Sort  Exit              --    Rdsp   +                ===>  Menu   
12:56:58                  WORST TRANSACTIONS BY IOS                  2016-06-24
                 12:56:48 2016-06-24 Thru 12:56:58 2016-06-24                  
                                                                               
                 Total            Total                                        
 Trans Nr       ADA-Dur           CQ Dur                                       
----------- ---------------- ----------------                                  
                                                                               
          0         0.042710         0.011984                                  
                    0.042710         0.011984                                  
                                                                               
                                                                               
                                                                               
                                                                               
                                                                               
                                                                               
                                                                               
                                                                               
                                                                               
                                                                               
                                                                               
                                                                               
Command: _____________________________________________________________________ 
Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
      Help  Sort  Exit              --    Rdsp   +          <===        Menu   

This section covers the following topics:

Fields Selected

Field System Name Order Sum Min Max Avg Pct Rate Round
TPTRANNM 1              
TPUSERID 2              
NATAPPL 3              
IOS   Y            
COMMANDS   Y            
TOTDURA   Y            
ADADURA   Y            
CQDURA   Y            

Report Options Selected

DISPLAY BY = SUMFIELD
ENTRIES = 100

Report Processing Rules

None.

ZIIP Usage Per Command

The ZIIP Usage Per Command report shows if an Adabas call was issued from an Adabas client or application, which is running on a zIIP processor when calling Adabas.

14:43:02                   ZIIP USAGE PER COMMAND                    2020-02-21
                    2020-02-21 14:42:55 - 2020-02-21 14:43:01                   
                                                                         Page: 1
                                                                                
    Date      TIME   DBID  Cmd ZP   Job                                         
 ---------- -------- ----- --- -- --------                                      
                                                                                
 2020-02-21 14:42:55   177 S1  Z  DAEFCO                                        
            14:42:55 11177 L3  Z  DAEFCO                                        
            14:42:55 11177 RC  Z  DAEFCO                                        
            14:42:57   129 V4  Z  DAEFCO                                        
            14:42:57   177 S1  Z  DAEFCO                                        
            14:42:57   177 V4     HUB129                                        
            14:42:57 11177 V4     HUB129                                        
            14:42:59   129 V4  Z  DAEFCO                                        
            14:42:59   177 RC  Z  DAEFCO                                        
            14:42:59 11177 L3  Z  DAEFCO                                        
            14:42:59 11177 RC  Z  DAEFCO                                        
            14:43:01   129 V4  Z  DAEFCO                                        
            14:43:01   177 RC  Z  DAEFCO                                        
            14:43:01   177 S1  Z  DAEFCO                                        
            14:43:01 11177 L3  Z  DAEFCO                                        
            14:43:01 11177 RC  Z  DAEFCO                                        
            14:43:01 11177 S1  Z  DAEFCO                                        
 ********** ******** ***** *** ** ********                                      
 ********** ******** ***** *** ** ********                                      
                                                                                
 *****   E N D    O F    R E P O R T   *****                                   
 Command: _____________________________________________________________________
 Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
       Help  Sort  Exit                           +                      Menu

This section covers the following topics:

Fields Selected

Field System Name Order Sum Min Max Avg Pct Rate Round
DATE 1              
TIME 2              
DBID 3              
CMD 4              
ZIIP 5              
JOBNAME 6              

Report Options Selected

Defaults.

Report Processing Rules

None.