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 external 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...
External Cache Statistics totals, DS, and NI
External Lock Statistics buffer flush, hold ISN, new data RABN, and global update command sync locks

This document covers the following topics:


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

External Cache Statistics (Cluster Nucleus Only)

Publishing requests by type and total cache statistics are presented first:

 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

External 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