Pulse reports receive nucleus statistical data from Adabas on an interval basis. Adabas transmits to Review a Pulse record once for each interval period.
The Adabas Pulse report gives the DBA a method of collecting statistical details about the Adabas nucleus during a user-specified time interval. The Pulse report collects minimum, maximum, and average values for non-cumulative nucleus statistics such as:
current number of users
current amount of the work pool used
current number of hold queue elements
The Pulse report also gathers and calculates the delta values of cumulative nucleus statistics such as buffer waits, format overwrites, and buffer flushes. These statistics will help the DBA monitor overall database activity over a given period of time. Non-cumulative statistics will be checked every minute with the average calculated at the time interval. Cumulative statistics will be checked only at the time interval when deltas are calculated.
The Pulse report timer interval can be set in the report options and must be specified in minutes. The minimum interval is one minute and the maximum is 1440 minutes. Once the report is started, the interval is in effect until the report is stopped. A new interval can be set prior to restarting the report. Only one Pulse report is allowed per database. This feature is available on all supported platforms.
To define the Pulse report, you choose the DBID where the report will run and the interval (in seconds), as well as some additional settings and information. Only one Pulse report may be started per Database. In the Review hub environment, you may have several Pulse reports active, but only one for each of the monitored databases.
To access the Edit Pulse Report function
Enter the EL code on the command line.
The following screen will display:
10:14:20 A D A B A S - R E V I E W 2003-06-06
Edit ADABAS Pulse Report LOCL=00204
+-------------------------------------------------------+
! !
! Report Name: .... ADABAS Pulse Report !
! DBID: ........................... _____ !
! ADABAS Collection Interval: (mins) ____ !
! Autostarted: ........................ N !
! !
! Collect History: .................... N !
! History Interval: (minutes) ...... ____ !
! Repository DBID: ............... __222 !
! Repository File: ................ __23 !
! Repository Database SVC: ........ 236 !
+-------------------------------------------------------+
Command: ______________________________________________________________________
Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
Help Exit Save Start Menu |
The Edit Adabas Pulse Report Report screen provides the following input fields:
| Heading | Explanation |
|---|---|
| Report Name | The name of the report. This field cannot be modified. |
| DBID | Specifies which database the report is to run on. When a DBID is entered into this field, the DBID will be automatically appended to the report name. |
| Adabas Collection Interval | The number of seconds between each report. Report data will be written to the Review history file once for each interval. The minimum interval is one minute and the maximum is 1440 minutes. |
| Autostarted | Specifies whether the report is started when Review is initialized. |
| Collect History | Indicates whether to collect history data. |
| History Interval | The number of minutes between each history data collection. |
| Repository DBID | The database that contains the Review history file. |
| Repository File | The file number of the Review history file. |
| Repository Database SVC | The SVC currently being used by the Review history database. |
Press PF5 to save your changes to the report; press PF6 to save the report and manually start it. You will find the pulse report as a started report and, after the first collection interval is reached, you can enter the Pulse Statistics screen, as shown below:
10:18:52 A D A B A S - R E V I E W 2003-06-06
Pulse Statistics LOCL=00204
Select one Pulse interval and press Enter
+----------------------------------------------------------------------------+
! _ 2003-06-06 11:37:54 _ __________ ________ _ __________________ !
! _ 2003-06-06 11:41:29 _ __________ ________ _ __________________ !
! _ 2003-06-06 12:13:44 _ __________ ________ _ __________________ !
! _ 2003-06-06 12:18:33 _ __________ ________ _ __________________ !
! _ __________ ________ _ __________ ________ _ __________________ !
! _ __________ ________ _ __________ ________ _ __________________ !
! _ __________ ________ _ __________ ________ _ __________________ !
! _ __________ ________ _ __________ ________ _ __________________ !
! _ __________ ________ _ __________ ________ _ __________________ !
! _ __________ ________ _ __________ ________ _ __________________ !
! _ __________ ________ _ __________ ________ _ __________________ !
! _ __________ ________ _ __________ ________ _ __________________ !
+----------------------------------------------------------------------------+
Command: ______________________________________________________________________
Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
Help Exit Menu |
Selecting a pulse interval line displays the Pulse Statistics panel, as shown below:
09:41:48 A D A B A S - R E V I E W 2003-06-06
Pulse Statistics LOCL=00204
High Low Avg
Allocated Size ------------------------------------------------------
Format Pool 7600 7600 7600
Work Pool 0 0 0
Table of ISNs 0 0 0
Table of Seq Cmds 0 0 0
Allocated Entries ---------------------------------------------------
Attached Buffers 2 2 2
Command Queue 1 1 1
Hold Queue 0 0 0
User Queue 5 5 5
Buffer Efficiency ---------------------------------------------------
Percent 5.0 5.0 5.0
Command: ______________________________________________________________________
Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
Help Exit Delta Menu |
Pressing PF4 (Delta) displays the Delta Statistics screen, as shown below:
10:27:39 A D A B A S - R E V I E W 2003-06-06
Pulse Statistics LOCL=00204
Delta Statistics
+-----------------------------------------------------------------------+
! Buffer Waits 0 User Commands 22 !
! Buffer Flushes 2 Asso Reads 0 !
! Format Overwrites 0 Asso Writes 0 !
! Format Translations 0 Data Reads 11 !
! System Commands 2 Data Writes 0 !
! Total Commands 24 Work Reads 0 !
! Throwbacks 0 Work Writes 0 !
! Thread Switches 110 Total IOS 11 !
+-----------------------------------------------------------------------+
Command: ______________________________________________________________________
Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
Help Exit Menu |
