Cluster Nucleus Session End Statistics

#### Search Results

Search

# Cluster Nucleus Session End Statistics

In addition to the end-of-session statistics printed by every Adabas nucleus, the statistics for a cluster nucleus also include global cache and lock statistics.

If you are running the selectable unit Adabas Online System (AOS), all of the statistics shown in the following sample output are displayed.

If you are running only the demo version of AOS delivered with Adabas, the statistics displayed are limited as follows:

Section | Displays statistics only for...
--- | ---
Global Cache Statistics | totals, DS, and NI
Global Lock Statistics | buffer flush, hold ISN, new data RABN, and global update command sync locks

This document covers the following topics:

- General Nucleus Information

- Input/Output Statistics

- Command Statistics

- User Sessions

- Efficiency Statistics

- Messaging Statistics

- Global Cache Statistics (Cluster Nucleus Only)

- Global Lock Statistics (Cluster Nucleus Only)

- WORK Data Set I/O Statistics (Cluster Nucleus Only)

- Data Set Activity Statistics

## General Nucleus Information

     A d a b a s  nucleus session statistics

     From 2014-03-11 10:56:39 to 2014-03-11 14:46:57

     Duration            3:50:18
     Wait-time           3:50:13
     CPU time            0:00:02

## Input/Output Statistics

### I/O Counts (Including Initialization)

     Container            Reads               Writes
     -----------------------------------------------

     ASSO                   107                   72
     DATA                    27                   14
     WORK                     3                  397
     PLOG                     0                    0
     CLOG                     0                    0

     -----------------------------------------------
     Total                  137                  483

### Work and PLOG I/Os and Blocks

     PLOG  protection blocks                   32
     PLOG  different blocks                    24
     PLOG  protection I/Os                     14
     WORK1 protection blocks                   42
     WORK1 different blocks                    23
     WORK1 protection I/Os                     22

     WORK1 publishing blocks                   21
     WORK1 publishing I/Os                      5
     WORK1 publishing waits                     6

- "WORK1 protection blocks" shows the total number of blocks written to WORK Part 1. Some blocks may have been written more than once (with increasing amounts of data).

- "WORK1 different blocks" shows the number of different blocks written to WORK Part 1 - that is, counting each block once if it was written multiple times in a row. This number correlates with the actual amount of protection data written to WORK.

- "WORK1 protection I/Os" shows the number of I/Os performed to write the protection data to WORK Part 1. Where possible, Adabas writes multiple consecutive blocks in a single I/O operation, if sufficient I/O buffers are available (based on the NWORK1BUFFERS parameter).

- The "PLOG protection blocks", "PLOG different blocks" and "PLOG protection I/Os" statistics are similar.

- The "WORK1 publishing" statistics report on extra WORK writes induced by the CLUPUBLPROT=YES setting in a cluster. They show the number of blocks written, the number of I/O operations performed for those writes, and the number of waits incurred for writing protection data to WORK before ASSO and DATA blocks containing related updates could be written to the global cache. They are printed only if at least one of the numbers is nonzero.

### Log Reads and Buffer Efficiency

     Logical reads                   12,778
     Buffer efficiency                 95.3

### Distribution of ASSO/DATA I/Os by Volser Number (Excluding Initialization)

      VOLSER     High RABN                Reads               Writes
     ---------------------------------------------------------------
     ASSO:
      SMSZ10         6,286                  107                   72
     ---------------------------------------------------------------
     ASSO total                             107                   72

     DATA:
      SMSZ10         5,992                   27                   14
     ---------------------------------------------------------------
     DATA total                              27                   14
     ---------------------------------------------------------------
     Total                                  134                   86

## Command Statistics

### Distribution of Commands by Source

     Source               Commands
     -----------------------------
     Remote                      0
     Local                     579
     Internal                  289
     Operator                    3
     -----------------------------
     Total                     871

### Distribution of Commands by Thread

       Thread             Commands
     -----------------------------
            1                  852
            2                   19
            3                    0
            4                    0
            5                    0
            6                    0
            7                    0
            8                    0
            9                    0
           10                    0
           11                    0
           12                    0
           13                    0
           14                    0
           15                    0
           16                    0
           17                    0
           18                    0
           19                    0
           20                    0
     -----------------------------
       Total                   871

### Distribution of Commands by File

         File             Commands
     -----------------------------
            0                  324
            1                  400
           19                  147
     -----------------------------
        Total                  871

### Distribution of Commands by Type

         Type             Commands
     -----------------------------
         A1/4                  400
         CL                     12
         LF                      2
         L1/4                  147
         OP                     10
         REST                  288
         UC                     12
     -----------------------------
        Total                  871

## User Sessions

     User sessions                   nnn

     Most calls (nnn)              initiated by: User   userid
                                                 Job    jobname
                                                 SECUID secuid

     Most I/Os  (nnn)                initiated by: User   'userid'
                                                 Job    jobname
                                                 SECUID secuid

     Most thread time (hh:mm:ss)         used by: User   'userid'
                                                 Job    jobname

## Efficiency Statistics

     Format translations                          157
     Format overwrites                              0
     Auto-restarts                                  0
     Throw-backs due to ISN                         0
     Throw-backs due to space                       0

### Buffer Flush Information

     Buffer flushes                                20
     Flush phases                                  20
     Blocks flushed                                81
     Flush I/Os                                    73

     Flush requests:
      Return immediately                            0
      Return after logical flush                    0
      Return after entire  flush                   29

     Buffer flush V2 timeouts                       4

Note
The "Buffer flush V2 timeouts" statistic is printed only if it is nonzero or the CLUPUBLPROT parameter is set to YES.

### Actual High-water Marks for Major Pools (Except the Buffer Pool)

     Pool          ADARUN parm       High watermark
     ----------------------------------------------

     AB  -POOL    NAB=       300      16896 (  1 %)
     CQ  -POOL    NC =       500        192 (  0 %)
     DUQ -POOL    LDE=      7000          0 (  0 %)
     FI  -POOL    LFP=    100000        160 (  0 %)
     HQ  -POOL    NH =      8000       5200 (  1 %)
     Redo-POOL   LRDP=    300000        112 (  0 %)
     SC  -POOL    LCP=     10000          0 (  0 %)
     TBI -POOL    LI =      4000          0 (  0 %)
     TBS -POOL    LQ =     30000          0 (  0 %)
     UQ  -POOL    NU =       500       1820 (  0 %)
     UQF -POOL    NU =       500        216 (  0 %)
     Wrk1-IO B NWORK1=         1          1 (100 %)
     WORK-POOL    LWP=    500000      73112 ( 14 %)
     Work Part1   LP =       500          6 (  1 %)
     Work Part2 LWKP2=       200          0 (  0 %)
     Work Part3  --  =       794          0 (  0 %)
     XID -POOL    XID=                      (  0 %)

## Messaging Statistics

     Message Control Block statistics
     Allocated                       768
     Used                              0
     Total requests                    0

     Statistics for ACMD-type messages
     Messages sent                     0
     Messages arrived                  0
     Messages accepted                 0
     Replies sent                      0

## Global Cache Statistics (Cluster Nucleus Only)

Publishing requests by type and total cache statistics are presented first. The following is a sample:

     Update sync    :              20
     BT or CL or ET :             316
     Redo threshold :               0
     Full bufferpool:               0
     All blocks     :              28
     Specific RABN  :               0
     File DS blocks :               0
     DSST blocks    :              13
     File NI blocks :               0

     Totals:

     Cast-out dir   :              40
      Synchronous   :               0
      Asynchronous  :              40

     Unlock cast-out:              20
      Synchronous   :               0
      Asynchronous  :              20

     Directory reads:               3
      Synchronous   :               0
      Asynchronous  :               3

     Reads          :              51
      Synchronous   :              51
      Asynchronous  :               0

      In cache      :               0
      Not in cache  :              51
      Structure full:               0

     Writes         :           3,007
      Synchronous   :           3,007
      Asynchronous  :               0

      Written       :           3,007
      Not written   :               0
      Structure full:               0

     Validates      :          19,302
      Block invalid :               0

     Cast-out reads :              81
      Synchronous   :              81
      Asynchronous  :               0

     Deletes        :               6
      Timeouts      :               0

     Redo processes :               0

After this, specific cache statistics in the following format are presented for the Address Converter (AC), Data Storage (DS), the Data Storage Space Table (DSST), File Control Block (FCB), normal index (NI), upper index (UI), WORK blocks (if at least one of the statistics is nonzero), and for every file in the database:

     Reads          :               4
      Synchronous   :               4
      Asynchronous  :               0

      In cache      :               0
      Not in cache  :               4
      Structure full:               0

     Writes         :              13
      Synchronous   :              13
      Asynchronous  :               0

      Written       :              13
      Not written   :               0
      Structure full:               0

     Validates      :           2,118
      Block invalid :               0

     Cast-out reads :              13
      Synchronous   :              13
      Asynchronous  :               0

     Deletes        :               0
      Timeouts      :               0

     Redo processes :               0

## Global Lock Statistics (Cluster Nucleus Only)

Lock statistics are displayed in a format similar to the following sample:

     Obtains
      Conditional   :               0
       Granted      :               0
       Rejected     :               0
      Unconditional :              12
      Synchronous   :              10
      Asynchronous  :               2
     Releases       :              12
      Synchronous   :               5
      Asynchronous  :               7

Statistics are displayed for many of the following kinds of locks, as appropriate for your database session:

- Buffer flush locks;

- Cancel locks;

- Checkpoint locks;

- Container locks;

- DBID target assignment locks;

- Delta Save Facility (DSF) locks;

- ETID locks;

- File/ISN read locks;

- File Space Table (FST) locks;

- File-lock-table locks;

- Format AC/AC1 locks;

- General Control Block (GCB) locks;

- Global update command sync locks;

- Global ET sync locks;

- Hold ISN locks;

- LOB tracker locks;

- New data RABN locks;

- Online save locks;

- Parameter locks;

- PETU table locks;

- Recovery locks;

- Recovery Log (RLOG) locks;

- Replication handshake locks;

- (Re)usable NI space locks;

- (Re)usable UI space locks;

- Security locks;

- Stored Procedures and Triggers (Spats) locks;

- TBWK4 table locks;

- Unique descriptor locks;

- User locks; and

- XIDE locks.

## WORK Data Set I/O Statistics (Cluster Nucleus Only)

     Internal NUCID :               2
     External NUCID :           10002
      Reads         :               3
      Writes        :               0

     Internal NUCID :               3
     External NUCID :           10001
      Reads         :               1
      Writes        :               0

These statistics include the I/O operations of a cluster nucleus to all WORK datasets in a cluster for the following purposes:

- Initialization and validation of the access to a WORK dataset

- Writing of protection data for an unresponsive peer nucleus

- Reading of protection data during online and offline recovery (session autorestart)

Any I/Os to the own WORK dataset of the nucleus during normal processing (writing of protection data for updates, reading of protection data for backout operations, writing and reading of search results) are not included. These are covered by the Input/Output Statistics displayed near the top of the end-of-session statistics.

## Data Set Activity Statistics

     14:46:58 ADAI03 00035 DDWORKR1                            3 reads
     14:46:58 ADAI03 00035 DDWORKR1                          397 writes
     14:46:58 ADAI03 00035 DDDATAR1                           27 reads
     14:46:58 ADAI03 00035 DDDATAR1                           14 writes
     14:46:58 ADAI03 00035 DDASSOR1                          107 reads
     14:46:58 ADAI03 00035 DDASSOR1                           72 writes

### On this page

- General Nucleus Information
- Input/Output Statistics
- Command Statistics
- User Sessions
- Efficiency Statistics
- Messaging Statistics
- Global Cache Statistics (Cluster Nucleus Only)
- Global Lock Statistics (Cluster Nucleus Only)
- WORK Data Set I/O Statistics (Cluster Nucleus Only)
- Data Set Activity Statistics