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:
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
Container Reads Writes ----------------------------------------------- ASSO 107 72 DATA 27 14 WORK 3 397 PLOG 0 0 CLOG 0 0 ----------------------------------------------- Total 137 483
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.
Logical reads 12,778 Buffer efficiency 95.3
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
Source Commands ----------------------------- Remote 0 Local 579 Internal 289 Operator 3 ----------------------------- Total 871
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
File Commands ----------------------------- 0 324 1 400 19 147 ----------------------------- Total 871
Type Commands ----------------------------- A1/4 400 CL 12 LF 2 L1/4 147 OP 10 REST 288 UC 12 ----------------------------- Total 871
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
Format translations 157 Format overwrites 0 Auto-restarts 0 Throw-backs due to ISN 0 Throw-backs due to space 0
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.
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 %)
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
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
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.
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.
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