Task and External Request Unit Service (ERUS) Statistics Reports

Task statistics and external request unit service (ERUS) statistics record the resource usage of individual tasks and external request units. The following considerations apply:
idms19
Task statistics and external request unit service (ERUS) statistics record the resource usage of individual tasks and external request units. The following considerations apply:
  • Task and ERUS statistics, including database statistics, incorporate statistics of system run units (RHDCRUAL/IDMSXTAL) when these run units do work for the task. For example, loading a load module from a load area requires database requests which show up in the task statistics.
  • Task and ERUS statistics include system-mode statistics; that is, when DC/UCF does work for the task. For example, when a program issues a BIND RUN UNIT, the system obtains variable storage; the storage requests show up in the task statistics.
This article explains the following information:
2
2
Uses for Task and ERUS Statistics
Task and ERUS statistics are useful for monitoring and tuning individual application programs.
Statistics Collected Only Upon Request
DC/UCF collects task and ERUS statistics only when requested to do so by the user, because the statistics require additional overhead and, when written to the log file, generate a large volume of data.
Summary of Task Statistics Reports
The following statistics reports summarize task and external request unit activity:
SREPORT 004
Summarizes task statistics by IP Address.
SREPORT 005
Summarizes task statistics by user identifier.
SREPORT 006
Summarizes task statistics by logical terminal identifier.
SREPORT 007
Summarizes task statistics by task code.
SREPORT 008
Summarizes ERUS statistics by accounting data.
SREPORT 009
Summarizes ERUS statistics by program name.
Sample SREPORT 004
REPORT NO. 04                                IDMS-DC TASK STATISTICS BY IP ADRESS  Rnn.n                          mm/dd/yy PAGE     1            SELECTED FROM:  yyddd  hh:mm      TO:  yyddd  hh:mm          CV SYSTEM START:  yyddd  hh:mm      TO:  yyddd  hh:mm              CV JOB NAME:  jobname                CV NUMBER:  nnn   IP ADDRESS: 138.42.193.137                                                                                                                                                                                                                                                   3         NUMBER TASK EXECUTIONS                                                                                                                                                                                                                  3         NUMBER PROGRAMS CALLED                             0        NUMBER PROGRAMS LOADED                             0         NUMBER TERMINAL READS                              0        NUMBER TERMINAL WRITES                             0         NUMBER TERMINAL ERRORS                           111        NUMBER GETSTG REQUESTS                             0         NUMBER GETSCR REQUESTS                             0        NUMBER PUTSCR REQUESTS                             0         NUMBER DELSCR REQUESTS                             0        NUMBER GETQUE REQUESTS                             0         NUMBER PUTQUE REQUESTS                             0        NUMBER DELQUE REQUESTS                           144         NUMBER GETTIME REQUESTS                            0        NUMBER SETTIME REQUESTS                            0         NUMBER DB SERVICES RQSTS                           0        NUMBER PAGES READ                              .0011         TASK USER MODE TIME                            .0023        TASK SYSTEM MODE TIME                        10.2754         TASK WAIT TIME                                                                                                 0         NUMBER PAGES WRITTEN                               0        NUMBER PAGES REQUESTED                             0         NUMBER CALC RECS NO OFLOW                          0        NUMBER CALC RECS OFLOW                             0         NUMBER VIA RECS NO OFLOW                           0        NUMBER VIA RECS OFLOW                              0         NUMBER RECORDS REQUESTED                           0        NUMBER RECS CURRENT OF RU                           0         NUMBER FRAGMENTS STORED                            0        NUMBER RECORDS RELOCATED                           0         NUMBER CALLS TO DBMS                               0        TOTAL LOCKS ACQUIRED                               0         NUMBER CALLS TO DBMS                               0        TOTAL LOCKS ACQUIRED                           0         NUMBER SR8 SPLITS                                  0        NUMBER SR8 STORES                              0         NUMBER SR8 SPAWNS                                  0        NUMBER SR8 ERASES                              0         NUMBER ORPHAN ADOPT                                0        NUMBER SR7 STORES                              0         NUMBER BTREE SEARCHES                              0        NUMBER SR7 ERASES                              0         NUMBER SQL COMMANDS                                0        NUMBER SQL SORTS                               0         NUMBER TUPLES FETCHED                              0        NUMBER TUPLES SORTED                           0         NUMBER ROWS INSERTED                               0        NUMBER AM RECOMPILES                           0         NUMBER ROWS UPDATED                                                                                        0         NUMBER ROWS DELETED                                                                                                                                                                                                     .002443         TASK SYSTEM MODE CPU                         .000000        TASK ZIIP ON CP CPU                     .000000         TASK ZIIP ON ZIIP CPU                        .001140        TASK USER MODE CPU                     .003583         TOTAL TASK TCB CPU                           .000000        ENCLAVE CPU       
Sample SREPORT 005
 REPORT NO. 05                                IDMS-DC TASK STATISTICS BY USER ID  Rnn.n                          mm/dd/yy PAGE     1            SELECTED FROM:  yyddd  hh:mm      TO:  yyddd  hh:mm          CV SYSTEM START:  yyddd  hh:mm      TO:  yyddd  hh:mm              CV JOB NAME:  jobname                CV NUMBER:  nnn    USER ID:  JEJ                                                              13         NUMBER TASK EXECUTIONS                             20         NUMBER PROGRAMS CALLED                             1        NUMBER PROGRAMS LOADED                           11         NUMBER TERMINAL READS                            159        NUMBER TERMINAL WRITES                            0         NUMBER TERMINAL ERRORS                           471        NUMBER GETSTG REQUESTS                            0         NUMBER GETSCR REQUESTS                             0        NUMBER PUTSCR REQUESTS                            0         NUMBER DELSCR REQUESTS                             2        NUMBER GETQUE REQUESTS                            0         NUMBER PUTQUE REQUESTS                             0        NUMBER DELQUE REQUESTS                          151         NUMBER GETTIME REQUESTS                            5        NUMBER SETTIME REQUESTS                          128         NUMBER DB SERVICES RQSTS                           7        NUMBER PAGES READ                        .0010         TASK USER MODE TIME                            .0536        TASK SYSTEM MODE TIME                   7,573.0212         TASK WAIT TIME                            0         NUMBER PAGES WRITTEN                              50        NUMBER PAGES REQUESTED                            0         NUMBER CALC RECS NO OFLOW                          0        NUMBER CALC RECS OFLOW                            0         NUMBER VIA RECS NO OFLOW                           0        NUMBER VIA RECS OFLOW                           85         NUMBER RECORDS REQUESTED                          33        NUMBER RECS CURRENT OF RU                            0         NUMBER FRAGMENTS STORED                            0        NUMBER RECORDS RELOCATED                          160         NUMBER CALLS TO DBMS                              16        TOTAL LOCKS ACQUIRED                            0         NUMBER SR8 SPLITS                                  0        NUMBER SR8 STORES                            0         NUMBER SR8 SPAWNS                                  0        NUMBER SR8 ERASES                            0         NUMBER ORPHAN ADOPT                                0        NUMBER SR7 STORES                            0         NUMBER BTREE SEARCHES                              0        NUMBER SR7 ERASES                            0         NUMBER SQL COMMANDS                                0        NUMBER SQL SORTS                            0         NUMBER TUPLES FETCHED                              0        NUMBER TUPLES SORTED                            0         NUMBER ROWS INSERTED                               0        NUMBER AM RECOMPILES                            0         NUMBER ROWS UPDATED                            0         NUMBER ROWS DELETED                        .060329         TASK SYSTEM MODE CPU                         .000000        TASK ZIIP ON CP CPU                      .000000         TASK ZIIP ON ZIIP CPU                        .001081        TASK USER MODE CPU                      .061410         TOTAL TASK TCB CPU                           .000000        ENCLAVE CPU
Sample SREPORT 006
 REPORT NO. 06                                IDMS-DC TASK STATISTICS BY LTERM ID  Rnn.n                         mm/dd/yy PAGE     1            SELECTED FROM:  yyddd  hh:mm      TO:  yyddd  hh:mm          CV SYSTEM START:  yyddd  hh:mm      TO:  yyddd  hh:mm              CV JOB NAME:  jobname                CV NUMBER:  nnn    LTERM ID:  VL71001                              13        NUMBER TASK EXECUTIONS                              20        NUMBER PROGRAMS CALLED                             1        NUMBER PROGRAMS LOADED                            11        NUMBER TERMINAL READS                            159        NUMBER TERMINAL WRITES                             0        NUMBER TERMINAL ERRORS                           471        NUMBER GETSTG REQUESTS                             0        NUMBER GETSCR REQUESTS                             0        NUMBER PUTSCR REQUESTS                             0        NUMBER DELSCR REQUESTS                             2        NUMBER GETQUE REQUESTS                             0        NUMBER PUTQUE REQUESTS                             0        NUMBER DELQUE REQUESTS                           151        NUMBER GETTIME REQUESTS                            5        NUMBER SETTIME REQUESTS                           128        NUMBER DB SERVICE RQSTS                            7        NUMBER PAGES READ                         .0010        TASK USER MODE TIME                            .0536        TASK SYSTEM MODE TIME                    7,573.0212        TASK WAIT TIME                             0        NUMBER PAGES WRITTEN                              50        NUMBER PAGES REQUESTED                             0        NUMBER CALC RECS NO OFLOW                          0        NUMBER CALC RECS OFLOW                             0        NUMBER VIA RECS NO OFLOW                           0        NUMBER VIA RECS OFLOW                            85        NUMBER RECORDS REQUESTED                          33        NUMBER RECS CURRENT OF RU                             0        NUMBER FRAGMENTS STORED                            0        NUMBER RECORDS RELOCATED                           160        NUMBER CALLS TO DBMS                              16        TOTAL LOCKS ACQUIRED                             0        NUMBER SR8 SPLITS                                  0        NUMBER SR8 STORES                             0        NUMBER SR8 SPAWNS                                  0        NUMBER SR8 ERASES                             0        NUMBER ORPHAN ADOPT                                0        NUMBER SR7 STORES                             0        NUMBER BTREE SEARCHES                              0        NUMBER SR7 ERASES                             0        NUMBER SQL COMMANDS                                0        NUMBER SQL SORTS                             0        NUMBER TUPLES FETCHED                              0        NUMBER TUPLES SORTED                             0        NUMBER ROWS INSERTED                               0        NUMBER AM RECOMPILES                             0        NUMBER ROWS UPDATED                             0        NUMBER ROWS DELETED                         .060329        TASK SYSTEM MODE CPU                         .000000        TASK ZIIP ON CP CPU                       .000000        TASK ZIIP ON ZIIP CPU                        .001081        TASK USER MODE CPU                       .061410        TOTAL TASK TCB CPU                           .000000        ENCLAVE CPU
Sample SREPORT 007
 REPORT NO. 07                               IDMS-DC TASK STATISTICS BY TASK CODE  Rnn.n                         mm/dd/yy PAGE     1            SELECTED FROM:  yyddd  hh:mm      TO:  yyddd  hh:mm          CV SYSTEM START:  yyddd  hh:mm      TO:  yyddd  hh:mm              CV JOB NAME:  jobname                CV NUMBER:  nnn    TASK CODE:  USGAFIX                               1        NUMBER TASK EXECUTIONS                               5        NUMBER PROGRAMS CALLED                             3        NUMBER PROGRAMS LOADED                             0        NUMBER TERMINAL READS                              0        NUMBER TERMINAL WRITES                             0        NUMBER TERMINAL ERRORS                            13        NUMBER GETSTG REQUESTS                             0        NUMBER GETSCR REQUESTS                             0        NUMBER PUTSCR REQUESTS                             0        NUMBER DELSCR REQUESTS                             0        NUMBER GETQUE REQUESTS                             0        NUMBER PUTQUE REQUESTS                             0        NUMBER DELQUE REQUESTS                            12        NUMBER GETTIME REQUESTS                            0        NUMBER SETTIME REQUESTS                            11        NUMBER DB SERVICE RQSTS                            1        NUMBER PAGES READ                         .0003        TASK USER MODE TIME                            .0016        TASK SYSTEM MODE TIME                         .2276        TASK WAIT TIME                             0        NUMBER PAGES WRITTEN                               3        NUMBER PAGES REQUESTED                             0        NUMBER CALC RECS NO OFLOW                          0        NUMBER CALC RECS OFLOW                             0        NUMBER VIA RECS NO OFLOW                           0        NUMBER VIA RECS OFLOW                             6        NUMBER RECORDS REQUESTED                           0        NUMBER RECS CURRENT OF RU                             0        NUMBER FRAGMENTS STORED                            0        NUMBER RECORDS RELOCATED                            14        NUMBER CALLS TO DBMS                               2        TOTAL LOCKS ACQUIRED                             0        NUMBER SR8 SPLITS                                  0        NUMBER SR8 STORES                             0        NUMBER SR8 SPAWNS                                  0        NUMBER SR8 ERASES                             0        NUMBER ORPHAN ADOPT                                0        NUMBER SR7 STORES                             0        NUMBER BTREE SEARCHES                              0        NUMBER SR7 ERASES                             0        NUMBER SQL COMMANDS                                0        NUMBER SQL SORTS                             0        NUMBER TUPLES FETCHED                              0        NUMBER TUPLES SORTED                             0        NUMBER ROWS INSERTED                               0        NUMBER AM RECOMPILES                             0        NUMBER ROWS UPDATED                             0        NUMBER ROWS DELETED                         .001747        TASK SYSTEM MODE CPU                         .000000        TASK ZIIP ON CP CPU                       .000000        TASK ZIIP ON ZIIP CPU                        .000285        TASK USER MODE CPU                       .002032        TOTAL TASK TCB CPU                           .000000        ENCLAVE CPU
Sample SREPORT 008
 REPORT NO. 08                            IDMS-DC ERUS TASK STATISTICS BY ACCTG DATA  Rnn.n                      mm/dd/yy PAGE     1            SELECTED FROM:  yyddd  hh:mm      TO:  yyddd  hh:mm          CV SYSTEM START:  yyddd  hh:mm      TO:  yyddd  hh:mm              CV JOB NAME:  jobname                CV NUMBER:  nnn    ACCOUNTING DATA:   KRCJA020..111400030                               3        NUMBER TASK EXECUTIONS                               6        NUMBER PROGRAMS CALLED                             1        NUMBER PROGRAMS LOADED                             0        NUMBER TERMINAL READS                              0        NUMBER TERMINAL WRITES                             0        NUMBER TERMINAL ERRORS                            43        NUMBER GETSTG REQUESTS                             0        NUMBER GETSCR REQUESTS                             0        NUMBER PUTSCR REQUESTS                             0        NUMBER DELSCR REQUESTS                             0        NUMBER GETQUE REQUESTS                             0        NUMBER PUTQUE REQUESTS                             0        NUMBER DELQUE REQUESTS                            45        NUMBER GETTIME REQUESTS                            0        NUMBER SETTIME REQUESTS                            42        NUMBER DB SERVICE RQSTS                      519,761        NUMBER PAGES READ                         .0000        TASK USER MODE TIME                           2.5343        TASK SYSTEM MODE TIME                      390.7796        TASK WAIT TIME                             0        NUMBER PAGES WRITTEN                       1,166,589        NUMBER PAGES REQUESTED                             0        NUMBER CALC RECS NO OFLOW                          0        NUMBER CALC RECS OFLOW                             0        NUMBER VIA RECS NO OFLOW                           0        NUMBER VIA RECS OFLOW                       646,839        NUMBER RECORDS REQUESTED                     646,806        NUMBER RECS CURRENT OF RU                             0        NUMBER FRAGMENTS STORED                            0        NUMBER RECORDS RELOCATED                       658,413        NUMBER CALLS TO DBMS                              39        TOTAL LOCKS ACQUIRED                             0        NUMBER SR8 SPLITS                                  0        NUMBER SR8 STORES                             0        NUMBER SR8 SPAWNS                                  0        NUMBER SR8 ERASES                             0        NUMBER ORPHAN ADOPT                                0        NUMBER SR7 STORES                             0        NUMBER BTREE SEARCHES                              0        NUMBER SR7 ERASES                             0        NUMBER SQL COMMANDS                                0        NUMBER SQL SORTS                             0        NUMBER TUPLES FETCHED                              0        NUMBER TUPLES SORTED                             0        NUMBER ROWS INSERTED                               0        NUMBER AM RECOMPILES                             0        NUMBER ROWS UPDATED                             0        NUMBER ROWS DELETED                       24.249488        TASK SYSTEM MODE CPU                         .000000        TASK ZIIP ON CP CPU                       .000000        TASK ZIIP ON ZIIP CPU                        .000000        TASK USER MODE CPU                     24.249488        TOTAL TASK TCB CPU                           .000000        ENCLAVE CPU
Sample SREPORT 009
 REPORT NO. 09                             IDMS-DC ERUS TASK STATISTICS BY PGM NAME  Rnn.n                       mm/dd/yy PAGE     1            SELECTED FROM:  yyddd  hh:mm      TO:  yyddd  hh:mm          CV SYSTEM START:  yyddd  hh:mm      TO:  yyddd  hh:mm              CV JOB NAME:  jobname                CV NUMBER:  nnn    PROGRAM NAME:   ERZPTMSF                               1        NUMBER TASK EXECUTIONS                               2        NUMBER PROGRAMS CALLED                             0        NUMBER PROGRAMS LOADED                             0        NUMBER TERMINAL READS                              0        NUMBER TERMINAL WRITES                             0        NUMBER TERMINAL ERRORS                            14        NUMBER GETSTG REQUESTS                             0        NUMBER GETSCR REQUESTS                             0        NUMBER PUTSCR REQUESTS                             0        NUMBER DELSCR REQUESTS                             0        NUMBER GETQUE REQUESTS                             0        NUMBER PUTQUE REQUESTS                             0        NUMBER DELQUE REQUESTS                            15        NUMBER GETTIME REQUESTS                            0        NUMBER SETTIME REQUESTS                            14        NUMBER DB SERVICE RQSTS                      371,254        NUMBER PAGES READ                         .0000        TASK USER MODE TIME                           1.9449        TASK SYSTEM MODE TIME                      280.8358        TASK WAIT TIME                             0        NUMBER PAGES WRITTEN                         833,263        NUMBER PAGES REQUESTED                             0        NUMBER CALC RECS NO OFLOW                          0        NUMBER CALC RECS OFLOW                             0        NUMBER VIA RECS NO OFLOW                           0        NUMBER VIA RECS OFLOW                       462,013        NUMBER RECORDS REQUESTED                     462,002        NUMBER RECS CURRENT OF RU                             0        NUMBER FRAGMENTS STORED                            0        NUMBER RECORDS RELOCATED                       470,271        NUMBER CALLS TO DBMS                              13        TOTAL LOCKS ACQUIRED                             0        NUMBER SR8 SPLITS                                  0        NUMBER SR8 STORES                             0        NUMBER SR8 SPAWNS                                  0        NUMBER SR8 ERASES                             0        NUMBER ORPHAN ADOPT                                0        NUMBER SR7 STORES                             0        NUMBER BTREE SEARCHES                              0        NUMBER SR7 ERASES                             0        NUMBER SQL COMMANDS                                0        NUMBER SQL SORTS                             0        NUMBER TUPLES FETCHED                              0        NUMBER TUPLES SORTED                             0        NUMBER ROWS INSERTED                               0        NUMBER AM RECOMPILES                             0        NUMBER ROWS UPDATED                             0        NUMBER ROWS DELETED                       17.487940        TASK SYSTEM MODE CPU                         .000000        TASK ZIIP ON CP CPU                       .000000        TASK ZIIP ON ZIIP CPU                        .000000        TASK USER MODE CPU                     17.487940        TOTAL TASK TCB CPU                           .000000        ENCLAVE CPU
Field Descriptions
A description of the fields common to SREPORTs 004 through 009 follows:
  • SELECTED FROM/TO
    Specifies the time period specified on the USE 'SREPORT 000' parameter where SELECTED FROM specifies the beginning date and time and SELECTED TO specifies the ending date and time. The date is in Julian form,
    yyddd
    , where
    yy
    is the last two digits of the year and
    ddd
    is the day. The time is in
    hh:mm
    form, where
    hh
    is hours based on a 24-hour clock and
    mm
    is minutes.
  • CV SYSTEM START/INTERVAL START/TO
    Specifies the actual time period for the report generated. If the USE 'SREPORT 000' parameter does not specify a time range, CV SYSTEM START/INTERVAL START and TO represent the time range for the entire input archive file or input file created by SREPORT 099. When the input file contains cumulative statistics, the CV SYSTEM START date and time will be displayed. When the input file contains interval based statistics, the INTERVAL START date and time will be displayed.
  • CV JOB NAME
    Specifies the starting job name of Central Version which collected the statistics.
  • CV NUMBER
    Specifies the number of Central Version which collected the statistics.
  • IP ADDRESS
    IPV4 or IPV6 (dotted string format) of the originating IP Address for TCP/IP transactions. 
  • NUMBER TASK EXECUTIONS
    Indicates the total number of tasks executed within the actual time frame of the report. This label appears on SREPORTs 005, 006, 007, 008, and 009.
  • NUMBER OF TRANSACTIONS
    Indicates the total number of transactions executed within the actual time frame of the report. This label appears on SREPORTs 010, 011, and 021.
  • NUMBER PROGRAMS CALLED
    Indicates the number of programs called.
  • NUMBER PROGRAMS LOADED
    Indicates the number of programs loaded from disk (either a load area or a load/core-image library).
  • NUMBER TERMINAL READS
    Indicates the number of terminal reads performed.
  • NUMBER TERMINAL WRITES
    Indicates the number of terminal writes performed.
  • NUMBER TERMINAL ERRORS
    Indicates the number of terminal I/O errors.
  • NUMBER GETSTG REQUESTS
    Indicates the number of requests to acquire storage dynamically from storage pool.
  • NUMBER GETSCR REQUESTS
    Indicates the number of requests to retrieve scratch records from the DDLDCSCR area.
  • NUMBER PUTSCR REQUESTS
    Indicates the number of requests to place scratch records in the DDLDCSCR area.
  • NUMBER DELSCR REQUESTS
    Indicates the number of requests to delete scratch records from the DDLDCSCR area.
  • NUMBER GETQUE REQUESTS
    Indicates the number of requests to get queue records from the DDLDCRUN area.
  • NUMBER PUTQUE REQUESTS
    Indicates the number of requests to store or replace queue records in the DDLDCRUN area.
  • NUMBER DELQUE REQUESTS
    Indicates the number of requests to delete queue records from the DDLDCRUN area.
  • NUMBER GETTIME REQUESTS
    Indicates the number of requests for the date and time of day.
  • NUMBER SETTIME REQUESTS
    Indicates the number of requests to define an event that is to occur after a specified time interval.
  • NUMBER DB SERVICE RQSTS
    Indicates the number of times requests for database services (for example, OBTAIN
    record-name
    ) were issued by the task.
    For LRF and SQL programs, this value should be less than or equal to the number of CALLS TO DBMS. You can use these values to evaluate how efficiently the LRF or SQL path extracts data. For example, a program OBTAIN
    logical-record
    command increments NUMBER DB SERVICE RQSTS by one, but may greatly increment the CALLS TO DBMS value, especially if an area sweep occurs due to the NULL SELECT clause.
  • NUMBER PAGES READ
    Indicates the number of database pages read from disk.
  • TASK USER MODE TIME
    Indicates the amount of CPU time (in ten-thousandths seconds) spent executing user code. DC/UCF collects user-mode time statistics if enabled in the STATISTICS TASK clause of the SYSTEM system generation statement.
  • TASK SYSTEM MODE TIME
    Indicates the amount of CPU time (in ten-thousandths seconds) spent performing DC/UCF services for the task. DC/UCF collects system-mode time statistics if enabled in the STATISTICS TASK clause of the SYSTEM system generation statement.
  • TASK WAIT TIME
    Indicates the amount of time spent on I/O requests and waiting for other system resources. The value is the difference between wall-clock and CPU time for the task.
  • NUMBER PAGES WRITTEN
    Indicates the number of database pages physically written to disk for the transaction. A page can be updated several times before it is actually written back to the database.
  • NUMBER PAGES REQUESTED
    Indicates the number of database pages requested by IDMSDBMS (including pages found in a buffer). A page request does not result in a page read if the page is in the buffer pool.
    Interpretation: The ratio of NUMBER PAGES REQUESTED to NUMBER PAGES READ is the
    buffer utilization ratio
    . The buffer utilization ratio measures the effectiveness of the buffer-pool size and design of the database (for example, CALC and VIA clustering). The higher the ratio the better. Ratios consistently below 2.0 indicate that processing is random or that the buffer-pool size is too small.
    The buffer utilization ratio may be artificially high for transactions that keep locks, due to the nature of the internal locking mechanism. IDMSDBMS cannot hold a buffer while requesting a lock; therefore, when locks are kept, IDMSDBMS must free and request a page each time a record is requested.
  • NUMBER CALC RECS NO OFLOW
    Indicates the number of CALC records stored on the target page.
  • NUMBER CALC RECS OFLOW
    Indicates the number of CALC records not stored on the target page.
    Interpretation: The ratio of NO OVERFLOW records to the total number of CALC records stored is the
    CALC cluster ratio
    . Ideally, the ratio should be 1, which indicates no overflow. Ratios less than 1 or less than the norm indicate space utilization is getting high and the database should be tuned.
  • NUMBER VIA RECS NO OFLOW
    Indicates the number of VIA and/or DIRECT records stored on the target page.
  • NUMBER VIA RECS OFLOW
    Indicates the number of VIA and or DIRECT records not stored on the target page.
    Interpretation: The ratio of NO OVERFLOW records to the total number of VIA records stored is the
    VIA cluster ratio.
    Ideally, the ratio should be 1, which indicates no overflow. A value less than 1 or less than the norm indicates very large data clusters, high utilization of space, or small page size.
  • NUMBER RECORDS REQUESTED
    Indicates the number of records requested by the DBMS.
    Interpretation: The ratio of NUMBER RECORDS REQUESTED to NUMBER PAGES REQUESTED is the
    space management ratio.
    The space management ratio measures how well space is allocated (for example, VIA options, CALC distribution, and buffering). The higher the ratio the better. Ratios less than 4 or less than the norm indicate the size of the buffer should be increased and database tuning should be performed.
    The space management ratio may be artificially high for transactions that keep locks, due to the nature of the internal locking mechanism. IDMSDBMS cannot hold a buffer while requesting a lock; therefore, when locks are kept, IDMSDBMS must free and request a page each time a record is requested.
  • NUMBER RECORDS CURRENT OF RU
    Indicates the number of records made current of the transaction.
    Interpretation: The ratio of NUMBER RECORDS REQUESTED to NUMBER RECORDS CURRENT OR RU is the
    effectiveness ratio.
    The effectiveness ratio measures how much work the CA IDMS/DB has to do to find the requested record. The lower the ratio the better. If the ratio is high, examine set options (for example, sorted order or next pointers only) for appropriateness. If the options are correct, examine the program logic for accurate use of currency.
  • NUMBER FRAGMENTS STORED
    Indicates the number of noncontiguous segments stored for variable-length records.
  • NUMBER RECORDS RELOCATED
    Indicates the number of records relocated from the home page.
  • NUMBER CALLS TO DBMS
    Indicates the number of calls to the database management system.
    Execution of each navigational DML request involves one call; execution of each logical record facility (LRF) or SQL request typically involves multiple calls.
  • NUMBER SR8 SPLITS
    Indicates the number of SR8 splits.
  • NUMBER SR8 SPAWNS
    Indicates the number of SR8 spawns.
  • NUMBER ORPHAN ADOPT
    Indicates count of Index members or SR8s whose up-level pointers were corrected to point to the actual SR8 in which they appear.
  • NUMBER BTREE SEARCHES
    Indicates number of Btree index probes.
  • NUMBER SQL COMMANDS
    Indicates the number of SQL commands executed.
  • NUMBER TUPLES FETCHED
    Indicates number of tuples FETCHed.
  • NUMBER ROWS INSERTED
    Indicates the number of rows INSERTed.
  • NUMBER ROWS UPDATED
    Indicates the number of rows UPDATed.
  • NUMBER ROWS DELETED
    Indicates the number of rows DELETEd.
  • NUMBER TOTAL LOCKS
    Indicates the number of all locks acquired and released by all completed transactions. This is NOT a count of locks currently held.
  • NUMBER SR8 STORES
    Indicates count of SR8s created.
  • NUMBER SR8 ERASES
    Indicates count of SR8s erased.
  • NUMBER SR7 STORES
    Indicates count of SR7s created.
  • NUMBER SR7 ERASES
    Indicates count of SR7s erased.
  • NUMBER SORTS
    Indicates the number of SQL sorts performed.
  • NUMBER TUPLES SORTED
    Indicates the number of rows participating in all sorts.
  • NUMBER AM RECOMPILES
    Indicates the number of automatic access module recompilations.
  • TASK SYSTEM MODE CPU
    Indicates the amount of CPU time (in microseconds) spent in executing system code.
  • TASK USER MODE CPU
    Indicates the amount of CPU time (in microseconds) spent in executing user code.
  • TASK ZIIP on ZIIP CPU
    Indicates the amount of CPU time (in microseconds) spent on zIIP.
  • TASK ZIIP on CP CPU
    Indicates the amount of CPU time (in microseconds) spent on CP, while qualified for zIIP.
  • TASK TOTAL TCB CPU TIME
    Indicates the amount of CPU time (in microseconds) spent on CP in either system mode or user mode.
  • ENCLAVE CPU
    Indicates the amount of CPU time (in microseconds) spent on CP or zIIP, while qualified for zIIP.