This section describes the reports supplied with Adabas Review. These reports may be used without modification, or they may be customized to suit individual site requirements.
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:
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).
20:50:35 APPLICATION FILE FIELD USAGE 2009-06-18
2009-06-18 Thru 2009-06-18 HUB=15690
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 |
This section covers the following topics:
| 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 |
Defaults.
None.
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 2009-06-19
ADABAS Buffer Pool Display HUB=15690
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 |
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 |
| 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.
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 |
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 2009-06-20
03:37:16 2009-06-20 Thru 03:38:58 2009-06-20 HUB=15690
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:
| Field System Name | Order | Sum | Min | Max | Avg | Pct | Rate | Round |
|---|---|---|---|---|---|---|---|---|
| HOUR | 1 | |||||||
| CMD | 2 | |||||||
| IOS | Y | Y | ||||||
| COMMANDS | Y | |||||||
| CMDRESP | Y | Y |
AUTOSTART = Y MAX K = 8
None.
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.
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 2009-06-20
03:37:25 2009-06-20 Thru 03:40:29 2009-06-20 HUB=15690
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:
| 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 |
Defaults.
None.
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 2003-07-07
10:50:09 1999-06-23 Thru 10:54:51 1999-06-23 LOCL=00009
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:
| 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 |
AUTOSTART = Y
RSP NE (0,3,9,17,48)
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 2009-06-20
03:37:35 2009-06-20 Thru 03:42:23 2009-06-20 HUB=15690
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:
| 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 |
Defaults.
None.
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 2009-06-20
03:37:42 2009-06-20 Thru 04:07:29 2009-06-20 HUB=15690
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:
| 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 |
Defaults.
None.
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 2003-07-07
10:32:13 1999-06-23 Thru 11:35:37 1999-06-23 LOCL=00009
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:
| Field System Name | Order | Sum | Min | Max | Avg | Pct | Rate | Round |
|---|---|---|---|---|---|---|---|---|
| HOUR | 1 | |||||||
| IOS | Y | |||||||
| COMMANDS | Y | |||||||
| ASSOIO | Y | |||||||
| DATAIO | Y | |||||||
| WORKIO | Y |
ENTRIES = 99999
IOS GT 0
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.
The I/O Summary by Volume report is an example of an I/O summary report.
This section covers the following topics:
| Field System Name | Order | Sum | Min | Max | Avg | Pct | Rate | Round |
|---|---|---|---|---|---|---|---|---|
| IOCOMP | 1 | |||||||
| IORABN | 2 | |||||||
| COMMANDS | Y |
ENTRIES = 99999
IOS GT 0
The I/O Summary by Volume report is an example of an I/O summary report.
11:36:43 IO SUMMARY BY VOLUME 2003-07-07
10:33:08 1999-06-23 Thru 11:36:42 1999-06-23 LOCL=00009
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:
| Field System Name | Order | Sum | Min | Max | Avg | Pct | Rate | Round |
|---|---|---|---|---|---|---|---|---|
| IOVOLSER | 1 | |||||||
| IOTYPE | 2 | |||||||
| IOCOMP | 3 | |||||||
| COMMANDS | Y |
ENTRIES = 99999
IOS GT 0
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 2009-06-20
03:38:08 2009-06-20 Thru 03:54:30 2009-06-20 HUB=15690
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:
| 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 |
Defaults.
None.
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 2009-06-20
03:38:15 2009-06-20 Thru 03:57:07 2009-06-20 HUB=15690
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:
| 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 |
WRAPPING = Y MAX K = 48 DISPLAY BY = SORTEDDE ENTRIES = 500
None.
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 2003-07-07
09:52:56 1999-06-16 Thru 11:50:35 1999-06-16 LOCL=00009
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:
| 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 |
Defaults.
ADADURA GT 3.0 AND IOS GT 200
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 2003-07-07
14:12:56 1999-06-28 Thru 14:12:59 1999-06-28 LOCL=00009
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:
| 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 |
Defaults.
NATAPPL EQ MYLOGON AND NATPROG EQ MYPROG
The Natural Summary report shows processing activity for a Natural application on a program-by-program basis.
10:57:09 NATURAL SUMMARY 2010-06-24
10:56:59 2010-06-24 Thru 10:57:04 2010-06-24 HUB=00205
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 2010-06-24
10:56:59 2010-06-24 Thru 10:57:04 2010-06-24 HUB=00205
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:
| 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 |
Defaults.
None.
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 2009-06-20
03:38:39 2009-06-20 Thru 04:05:15 2009-06-20 HUB=15690
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:
| 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 |
Defaults.
None.
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:
| 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 |
Defaults.
None.
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 2009-06-22
04:10:23 2009-06-20 Thru 12:29:51 2009-06-22 HUB=15690
Page: 1
Total Total Rate Rate
Date Time Num-of-IOs Commands Num-of-IOs Commands
---------- ----- ------------- ------------ ---------- ---------
2009-06-20 04:00 0 41 0.0 0.0
********** ***** 0 41
2009-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:
| Field System Name | Order | Sum | Min | Max | Avg | Pct | Rate | Round |
|---|---|---|---|---|---|---|---|---|
| DATE | 1 | |||||||
| HOUR | 2 | |||||||
| IOS | Y | Y | ||||||
| COMMANDS | Y | Y |
MAX K = 16
None.
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 2009-06-22
04:10:29 2009-06-20 Thru 12:32:14 2009-06-22 HUB=15690
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:
| Field System Name | Order | Sum | Min | Max | Avg | Pct | Rate | Round |
|---|---|---|---|---|---|---|---|---|
| HOUR | 1 | |||||||
| IOS | Y | Y | ||||||
| COMMANDS | Y | Y |
Defaults.
None.
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 2009-06-22
04:10:37 2009-06-20 Thru 12:34:40 2009-06-22 HUB=15690
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 2009-06-22
04:10:37 2009-06-20 Thru 12:34:40 2009-06-22 HUB=15690
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:
| 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 |
AUTOSTART = Y MAX K = 8
None.
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 2009-06-22
04:10:46 2009-06-20 Thru 12:36:44 2009-06-22 HUB=15690
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:
| Field System Name | Order | Sum | Min | Max | Avg | Pct | Rate | Round |
|---|---|---|---|---|---|---|---|---|
| THREAD | 1 | |||||||
| IOS | Y | Y | ||||||
| COMMANDS | Y | |||||||
| TOTDURA | Y |
Defaults.
None.
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 2009-06-22
12:40:31 2009-06-22 Thru 12:42:13 2009-06-22 HUB=15690
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 2009-06-22
12:40:31 2009-06-22 Thru 12:42:13 2009-06-22 HUB=15690
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 2009-06-22
12:40:31 2009-06-22 Thru 12:42:13 2009-06-22 HUB=15690
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:
| 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 |
Defaults.
None.
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.
The Transaction Count by Job report is an example of a transaction count report.
17:58:55 TRANSACTION COUNT BY JOB 2003-07-07
04:50:58 1999-06-15 Thru 17:58:54 1999-06-15 LOCL=00009
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:
| 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 |
Defaults.
TPTRANNM NE 0
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:
| 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 |
Defaults.
TPTRANNM NE 0
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:
| 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 |
Defaults.
TPTRANNM NE 0
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:
| 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 |
Defaults.
TPTRANNM NE 0
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 2003-07-07
09:54:54 1999-06-26 Thru 09:56:18 1999-06-26 LOCL=00009
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:
| 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 |
MAX K = 32
TPTRANNM NE 0
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 2003-07-07
09:55:25 1999-06-26 Thru 10:01:21 1999-06-26 LOCL=00009
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:
| 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 |
MAX K = 16
TPTRANNM NE 0
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 2010-06-24
10:51:40 2010-06-24 Thru 10:51:50 2010-06-24 HUB=00205
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 2010-06-24
10:51:40 2010-06-24 Thru 10:51:50 2010-06-24 HUB=00205
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:
| 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 |
Defaults.
None.
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 2003-07-07
09:57:38 1999-06-26 Thru 09:57:41 1999-06-26 LOCL=00009
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:
| 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 |
Defaults.
NATAPPL EQ SYSMAIN
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. |
The Worst Calls by ADADURA report is an example of a Worst Calls report.
11:48:29 WORST CALLS BY-> ADADURA 2010-06-24
11:48:22 2010-06-24 Thru 11:48:28 2010-06-24 LOCL=00204
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 2010-06-24
11:48:22 2010-06-24 Thru 11:48:28 2010-06-24 LOCL=00204
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:
| 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 |
DISPLAY BY = SUMFIELD ENTRIES = 100
None.
The Worst Calls by CQ DURA report is an example of a Worst Calls report.
12:08:15 WORST CALLS BY-> CQ DURA 2010-06-24
12:08:10 2010-06-24 Thru 12:08:14 2010-06-24 LOCL=00204
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 2010-06-24
12:08:10 2010-06-24 Thru 12:08:14 2010-06-24 LOCL=00204
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:
| 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 |
DISPLAY BY = SUMFIELD ENTRIES = 100
None.
The Worst Calls by DESC UPD report is an example of a Worst Calls report.
12:12:17 WORST CALLS BY-> DESC UPD 2010-06-24
12:12:16 2010-06-24 Thru 12:12:16 2010-06-24 LOCL=00204
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 2010-06-24
12:12:16 2010-06-24 Thru 12:12:16 2010-06-24 LOCL=00204
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:
| 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 |
DISPLAY BY = SUMFIELD ENTRIES = 100
None.
The Worst Calls by IOs report is an example of a Worst Calls report.
12:20:02 WORST CALLS BY-> IOS 2010-06-24
12:19:53 2010-06-24 Thru 12:20:01 2010-06-24 LOCL=00204
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 2010-06-24
12:19:53 2010-06-24 Thru 12:20:01 2010-06-24 LOCL=00204
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:
| 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 |
DISPLAY BY = SUMFIELD ENTRIES = 100
None.
The Worst Calls by ISN QUAN report is an example of a Worst Calls report.
12:25:36 WORST CALLS BY-> ISN QUAN 2010-06-24
12:25:27 2010-06-24 Thru 12:25:35 2010-06-24 LOCL=00204
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 2010-06-24
12:25:27 2010-06-24 Thru 12:25:35 2010-06-24 LOCL=00204
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:
| 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 |
DISPLAY BY = SUMFIELD ENTRIES = 100
None.
The Worst Calls by TOTDURA report is an example of a Worst Calls report.
12:41:07 WORST CALLS BY-> TOTDURA 2010-06-24
12:41:07 2010-06-24 Thru 12:41:07 2010-06-24 LOCL=00204
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 2010-06-24
12:41:07 2010-06-24 Thru 12:41:07 2010-06-24 LOCL=00204
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:
| 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 |
DISPLAY BY = SUMFIELD ENTRIES = 100
None.
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.
The report Worst Transactions by Calls report is an example of a Worst Transactions report.
12:47:50 WORST TRANSACTIONS BY CALLS 2010-06-24
12:45:38 2010-06-24 Thru 12:47:49 2010-06-24 LOCL=00204
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 2010-06-24
12:45:38 2010-06-24 Thru 12:47:49 2010-06-24 LOCL=00204
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:
| 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 |
DISPLAY BY = USAGE ENTRIES = 100
None.
The report Worst Transactions by Duration report is an example of a Worst Transactions report.
12:52:32 WORST TRANSACTIONS BY DURATION 2010-06-24
12:52:20 2010-06-24 Thru 12:52:31 2010-06-24 LOCL=00204
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 2010-06-24
12:52:20 2010-06-24 Thru 12:52:31 2010-06-24 LOCL=00204
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:
| 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 |
DISPLAY BY = SUMFIELD ENTRIES = 100
None.
The report Worst Transactions by IOs report is an example of a Worst Transactions report.
12:56:58 WORST TRANSACTIONS BY IOS 2010-06-24
12:56:48 2010-06-24 Thru 12:56:58 2010-06-24 LOCL=00204
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 2010-06-24
12:56:48 2010-06-24 Thru 12:56:58 2010-06-24 LOCL=00204
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:
| 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 |
DISPLAY BY = SUMFIELD ENTRIES = 100
None.
