Adabas Online System Cluster Environment Screens

This document describes the Adabas Online System screens that apply to a cluster environment.


Scrolling through Nucleus IDs in a Cluster

You can use the PF2 key (function key 2) on some cluster environment screens in Adabas Online System (AOS) to scroll through the nuclei in a cluster. This allows you to review the same sets of statistics for each of the nuclei in a cluster.

When you press PF2 on such an AOS screen (or enter the NextNucid command), the same screen appears, but with data pertaining to the nucleus with the next highest nucleus ID in the cluster. If there is no higher nucleus ID, AOS cycles back to the beginning and displays the same screen, with data pertaining to the nucleus with the lowest ID in the cluster.

The screens on which this functionality is provided are:

  • Session Monitoring menu

  • Display Parameters screen

  • Modify Parameters screen

  • Queue Displays menu

  • Display User Queue screen

  • Resource Utilization menu

Once the nucleus ID is incremented on any of these screens, it remains in use on all AOS screens until it is changed.

Displaying Cluster Members

From the Session Monitoring menu, a new function Display cluster members (option A) produces the following screen:

14:02:39          *****  A D A B A S   BASIC  SERVICES  *****        2014-05-02
DBID 105                  -  Display Cluster Members  -               PACA002

Total number of nuclei in the cluster: 4
I Sel I Nuc ID I Image ID  I Jobname  I Status   I  Available Plex Services  I
------------------------------------------------------------------------------
I  _  I  1     I DAEMVS    I ADANUC01 I Active   I  All                      I
I  _  I  2     I DAEMVS    I ADANUC02 I Inactive I  Lock                     I
I  _  I  3     I DDZMVS    I ADANUC03 I Active   I  All                      I
I  _  I  4     I DDZMVS    I ADANUC04 I Active   I  All                      I
I     I        I           I          I          I                           I
I     I        I           I          I          I                           I
I     I        I           I          I          I                           I
I     I        I           I          I          I                           I
I     I        I           I          I          I                           I
I     I        I           I          I          I                           I
I     I        I           I          I          I                           I
I     I        I           I          I          I                           I
I     I        I           I          I          I                           I

PF1----- PF2------ PF3------ PF4------ PF6----- PF7----- PF8----- PF12-----
Help               Exit      Refresh                              Menu

The screen includes a list of nuclei participating in the cluster and information about the current status of each nucleus.

Start of instruction setTo select a nucleus for additional processing

  • Type "S" in the Sel column opposite that nucleus.

Start of instruction setTo display additional information about a nucleus

  • Type "D" in the Sel column opposite that nucleus.

For an Adabas cluster nucleus that has a nonzero nucleus ID, its entry in the parallel participant table (PPT) is displayed in a screen similar to the following:

14:04:00          ***** A D A B A S  BASIC  SERVICES *****          2014-05-02
DBID 1955                   - Display PPT Entry -                   MACA012   
                                                                              
NucID ... 1021    Active Nucleus, PLOG(s) not copied, CLOG(s) not copied      
                                                                              
                                                                              
 Name    Dataset Status              DataSet Name                             
 ------  --------------------------  ---------------------------------------- 
 WORK1                               RD.USAXXX.DB1955.WORKR1                  
 PLOGR1                              RD.USAXXX.DB1955.PLOGR1                  
 PLOGR2                              RD.USAXXX.DB1955.PLOGR2                  
 CLOGR1                              RD.USAXXX.DB1955.CLOGR1                  
 CLOGR2                              RD.USAXXX.DB1955.CLOGR2                  
                                                                              
                                                                              
                                                                              
                                                                              
                                                                              
                                                                              
                                                                              
Press 'ENTER', PF3 or PF12 to continue                                        
PF1----- PF2------ PF3------ PF4------ PF6----- PF7----- PF8----- PF12-----   
Help               Exit                                           Menu        

Nucleus File Status

From the Interval Utilization menu, the Nucleus file status (option N) can be used to determine the status of nucleus files. This is the equivalent of the DNFV operator command.

14:05:09          ***** A D A B A S  BASIC  SERVICES *****          2014-05-02
DBID  1955                 - Nucleus File Status -                  PACUN02   
NucID 1021                                                                    
                                                                              
            Locking                                                           
      File   NucID  Access count   Update count   State                       
      -----  -----  -------------  -------------  ----------------------      
      29                        0              0  Access                      
      39                        0              0  Access                      
      40                        0              0  Access                      
      41                        0              0  Access                      
      90                        0              0  Update                      
                                                                              
                                                                              
                                                                              
                                                                              
                                                                              
                                                                              
                                                                              
                                                                              
 Last page                                                                    
PF1----- PF2----- PF3----- PF4----- PF7----- PF8----- PF9-------  PF12-----   
Help     Repos    Exit     Refresh   -        +                   Menu        

In an Adabas cluster environment, the file may be locked for exclusive use by another cluster nucleus. If this is the case and the file is in the nucleus file status table, the Locking NucID column for the file shows the ID of the nucleus that has exclusive control.

The Access count / Update count fields display the number of access or update users, respectively, that refer to the specified file in their user queue elements (UQEs). These users either have specified the file in an OP command with R-option or are using the file in an as yet incomplete transaction.

A State field indicates when the file is used for access only or for access and update. The State field indicates to what extent a nucleus can use a file on its own. If the requested use exceeds the given state, the nucleus must first communicate with the other nuclei in the cluster in order to upgrade the state.

Nucleus Status Flags

From the Interval Utilization menu, a second screen , System status (option S), displays I/O counts for the ASSO, DATA, WORK, and PLOG data sets; remote and local call distribution; and other current session status information.

14:07:19          ***** A D A B A S  BASIC  SERVICES *****          2014-05-02
DBID 1955                     -  System Status  -                   PACUS12   
NucID: 1021                                                                   
                                                                              
 Physical    Reads          Writes                Call Distribution           
        -----------------------------  ---------------------------------------
 ASSO         7,529             280    No. of HQEs active .........          0
 DATA         4,946              90    No. of UQEs in User Queue ..          1
 WORK             2             379    No. of CQEs waiting in CQ ..          0
 PLOG            15             274    No. of PLOG switches .......          0
 CLOG            29              10    No. of CLOGs ...............          2
                                       No. of PLOGs ...............          2
 PLOG protection blks .         273                                           
 PLOG protection I/Os .         273    Format translations .....         577  
 WORK1 protection blks.         379    Format overwrites .......           0  
 WORK1 protection I/Os.         379    Auto-restarts ...........          13  
                                       Throw-backs for ISN .....           0  
 Logical reads ........      35,163    Throw-backs for Space....           0  
 Buffer efficiency ....           2.8                                         
                                                                  page 1 of 3 
                                                                              
PF1---- PF2---- PF3----- PF4----- PF6----- PF7----- PF8----- PF9----- PF12----
Help            Exit     Refresh                    +        FullView Menu    

Pressing PF8 displays another screen of system status information.

14:07:19          ***** A D A B A S  BASIC  SERVICES *****          2014-05-02
DBID 1955                     -  System Status  -                   PACUS12   
NucID: 1021                                                                   
                                                                              
         Call Distribution                          Commands                  
------------------------------------      -----------------------------       
User sessions ........          67        Remote ........           0         
Buffer flushes .......          91        Local .........       8,573         
Flush phases .........          91        Internal ......       6,122         
Blocks flushed .......         360        Operator ......           0         
Flush I/Os ...........         360        Total .........      14,695         
                                                                              
                                                                              
       Flush Requests Returned                     Time Elapsed               
------------------------------------      ----------------------------------  
Immediately ..........           1        Duration .... 3 days, 17:33:36      
After logical flush ..           0        Wait-time ... 3 days, 17:33:25      
After entire flush ...          98        CPU time .... 0 day, 00:00:39       
                                                                              
                                                                  page 2 of 3 
                                                                              
PF1---- PF2---- PF3----- PF4----- PF6----- PF7----- PF8----- PF9----- PF12----
Help            Exit     Refresh           -        +        FullView Menu    

Pressing PF8 again displays an additional screen that indicates if one or more of the following are in progress:

  • Online database save running;

  • ADAEND in progress;

  • Online file save running;

  • READONLY/UTIONLY transition;

  • READONLY status;

  • Update processing suspended;

  • ET-sync in progress;

  • UTIONLY status; and

  • Exclusive-DB-control utility running.

Otherwise, "Adabas operation normal" is displayed.

14:07:19          ***** A D A B A S  BASIC  SERVICES *****          2014-05-02
DBID 1955                     -  System Status  -                   PACUS12   
NucID: 1021                                                                   
                                                                              
                              Nucleus Status Flags                            
                      ------------------------------------                    
                      Adabas operation normal                                 
                                                                              
                                                                              
                                                                              
                                                                              
                                                                              
                                                                              
                                                                              
                                                                              
                                                                              
                                                                              
                                                                              
                                                                              
                                                                  page 3 of 3 
                                                                              
PF1---- PF2---- PF3----- PF4----- PF6----- PF7----- PF8----- PF9----- PF12----
Help            Exit     Refresh           -                 FullView Menu    

Cluster Usage

From the Session Monitoring menu, Cluster usage (option X) displays nucleus cluster statistics that are equivalent of those displayed using the DXCACHE, DXLOCK, and DXFILE operator commands.

The equivalent direct command is:

DISPLAY CLUSTERSTATUS
14:09:48          ***** A D A B A S  BASIC  SERVICES *****          2014-05-02
                              -  Cluster Usage -                    PACUX02   
                                                                              
                        Code    Service                                       
                        ----    ----------------                              
                         C      Cache statistics                              
                         F      File statistics                               
                         L      Lock statistics                               
                         ?      Help                                          
                         .      Exit                                          
                        ----    ----------------                              
          Code ......... _                                                    
          File Number .. 29                                                   
          Database ID .. 1955   (WIS1955)             NucID .. 1021           
                                                                              
                                                                              
                                                                              
                                                                              
                                                                              
                                                                              
Command ==>                                                                   
PF1----- PF2----- PF3------ PF4------ PF6----- PF9----- PF10----- PF12-----   
Help              Exit                         Fuse     Flist     Menu        

This section covers the following topics:

Cache Statistics

Choosing cache statistics (option C) from the Cluster Usage menu displays the following menu:

14:10:10          ***** A D A B A S  BASIC  SERVICES *****          2014-05-02
                            - Cache Statistics -                    PACUX12   
                                                                              
                  Code   Service                                              
                  ----   -----------------------                              
                    K    Cast-out / Directory                                 
                    P    Publishing requests                                  
                    X    Individual cache blocks                              
                    .    Exit                                                 
                    ?    Help                                                 
                  ----   -----------------------                              
                                                                              
     Code ......... _                                                         
     Database ID .. 1955   (WIS1955)             NucID .. 1021                
                                                                              
                                                                              
                                                                              
                                                                              
                                                                              
                                                                              
                                                                              
PF1----- PF2----- PF3----- PF4------ PF6----- PF7----- PF8-----  PF12-----    
Help              Exit     Refresh                               Menu         

The rest of this section describes each of the options on this screen.

Cast-out / Directory

Choosing cast-out / directory (option K) from the Cache Statistics menu display the following:

14:10:10          ***** A D A B A S  BASIC  SERVICES *****          2014-05-02
DBID  1955                 - Cast-out / Directory -                 PACUX12   
NucID 1021                                                                    
                                                                              
        Cast-out Directory Reads          Directory Reads                     
        ---------------------------       ---------------------------         
        Total .......         182         Total .......          10           
           Sync .....         107            Sync .....           0           
           Async ....          75            Async ....          10           
                                                                              
        Unlock Cast-out Calls                                                 
        ---------------------------                                           
        Total .......          91                                             
           Sync .....           0                                             
           Async ....          91                                             
                                                                              
                                                                              
                                                                              
                                                                              
                                                                              
                                                                              
PF1----- PF2----- PF3----- PF4----- PF7----- PF8----- PF9-------  PF12-----   
Help              Exit     Refresh                    Detail      Menu        

Counters have a multiplier column with the following values:

Value The total shown is in . . .
blank (factor of 1)
K kilo (factor of 1,000)
M mega (factor of 1,000,000)
G giga (factor of 1,000,000,000)

If a number has a multiplier shown, it has been divided by the multiplier, showing the significant digits to 9 places with no decimal point.

Press PF9 to see the entire value. This value is the exact count up to 20 digits in length.

Publishing Requests

Choosing publishing requests (option P) from the Cache Statistics menu display the following:

14:11:14          ***** A D A B A S  BASIC  SERVICES *****          2014-05-02
DBID  1955                 - Publishing Requests -                  PACUX12   
NucID 1021                                                                    
                     Publishing Request Category                              
                     ---------------------------------                        
                     Update sync .......          91                          
                     BT or CL or ET ....           3                          
                     Redo threshold ....           0                          
                     Full bufferpool ...           0                          
                     All blocks ........          97                          
                     Specific RABN .....           0                          
                     File DS blocks ....           0                          
                     All DSST blocks ...          90                          
                     File NI blocks ....           0                          
                                                                              
                                                                              
                                                                              
                                                                              
                                                                              
                                                                              
                                                                              
PF1----- PF2----- PF3----- PF4----- PF7----- PF8----- PF9-------  PF12-----   
Help              Exit     Refresh                    Detail      Menu        

All Cache Blocks

Choosing all cache blocks (option X) from the Cache Statistics menu display the following:

14:11:54          ***** A D A B A S  BASIC  SERVICES *****          2014-05-02
DBID  1955                  - All Cache Blocks -                    PACUX12   
NucID 1021                                                                    
  Reads                                 Writes                                
  --------------------------------      ----------------------------------    
  Total ............       7,460        Total ..............         373      
     Sync ..........       1,241           Sync ............         179      
     Async .........       6,219           Async ...........         194      
                                                                              
     In cache ......         105           Written .........         373      
     Not in cache ..       7,355           Not written .....           0      
     Struc. full ...           0           Struc. full .....           0      
                                                                              
  Cast-out Reads                        Other                                 
  --------------------------------      ----------------------------------    
  Total ............         360        Validates ..........      44,877      
     Sync ..........         360           Invalid .........           0      
     Async .........           0        Deletes ............           0      
                                           Timeouts ........           0      
                                        Redo processes .....           0      
                                                                              
PF1----- PF2----- PF3----- PF4----- PF7----- PF8----- PF9-------  PF12-----   
Help     Repos    Exit     Refresh  PrevBlk  NxtBlk   Detail      Menu        

Use PF7 and PF8 to scroll through the cache blocks; use PF2 to reposition.

Statistics are displayed for the following:

  • All cache blocks

  • Address converter (AC ) cache blocks

  • Data Storage (DS) cache blocks

  • Data Storage space table (DSST) cache blocks

  • File control block (FCB) cache blocks

  • Normal index (NI) cache blocks

  • Upper index (UI) cache blocks

Press PF9 from the above screen to display the following detail screen:

14:11:54          ***** A D A B A S  BASIC  SERVICES *****          2014-05-02
DBID  1955                  - All Cache Blocks -                    PACUX12   
NucID 1021                                                                    
Reads                                  Writes                                 
-------------------------------------- ---------------------------------------
Total ......                     7,460 Total .......                       373
  Sync .....                     1,241   Sync ......                       179
  Async ....                     6,219   Async .....                       194
                                                                              
  In cache..                       105   Written ...                       373
  Not in ...                     7,355   Not writ ..                         0
  Stru.full.                         0   Stru.full .                         0
                                                                              
Cast-out Reads                         Other                                  
-------------------------------------- ---------------------------------------
Total ......                       360 Validates ...                    44,877
  Sync .....                       360   Invalid ...                         0
  Async ....                         0 Deletes .....                         0
                                         Timeouts ..                         0
                                       Redo procs ..                         0
                                                                              
                                                                              
                                      Press Enter to continue                 

File Statistics

Choosing file statistics (option F) from the Cluster Usage menu for file 25 displays the following menu:

14:12:42          ***** A D A B A S  BASIC  SERVICES *****          2014-05-02
DBID  1955                - File 29 Statistics -                    PACUX22   
NucID 1021                                                                    
  Reads                                 Writes                                
  --------------------------------      ----------------------------------    
  Total ............           5        Total ..............           0      
     Sync ..........           0           Sync ............           0      
     Async .........           5           Async ...........           0      
                                                                              
     In cache ......           0           Written .........           0      
     Not in cache ..           5           Not written .....           0      
     Struc. full ...           0           Struc. full .....           0      
                                                                              
  Cast-out Reads                        Other                                 
  --------------------------------      ----------------------------------    
  Total ............           0        Validates ..........          12      
     Sync ..........           0           Invalid .........           0      
     Async .........           0        Deletes ............           0      
                                           Timeouts ........           0      
                                        Redo processes .....           0      
                                                                              
PF1----- PF2----- PF3----- PF4----- PF7----- PF8----- PF9-------  PF12-----   
Help     Repos    Exit     Refresh                    Detail      Menu        

Lock Statistics

Choosing lock statistics (option L) from the Cluster Usage menu displays the following menu:

14:13:03          ***** A D A B A S  BASIC  SERVICES *****          2014-05-02
                             - Lock Statistics -                    PACUX39   
                                                                              
Code  Service             Code  Service              Code  Service            
----  ------------------  ----  ------------------   ----  ------------------ 
  A   Buffer flush          L   Global ET sync         W   Replicat handshake 
  B   Cancel                M   Glbl upd cmd sync      X   Security           
  C   Checkpoint            N   Hold ISN               Y   Spats              
  D   Container             O   LOB tracker            Z   Unique descriptor  
  E   Delta Save (DSF)      P   Net-wrk DBID asgmt     1   User               
  F   Distributed tranID    Q   New-Data-RABN          2   Wkpt4 RABN index   
  G   ETID                  R   Online save            3   Wkpt4 PET user tbl 
  H   File-lock-table       S   Parameter              .   Exit               
  I   Format-addr-conver    T   Record read            ?   Help               
  J   Free space table      U   Recovery (online)                             
  K   GCB                   V   Recovery log(RLOG)                            
----  ------------------  ----  ------------------   ----  ------------------ 
             Code ......... _                                                 
             Database ID .. 1955   (WIS1955)             NucID .. 1021        
                                                                              
                                                                              
PF1----- PF2----- PF3------ PF4------ PF6----- PF7------ PF8----- PF12-----   
Help              Exit      Refresh                               Menu        
Û                                                                 19,031      

Each of the options on the Lock Statistics menu displays statistics for a particular lock. For each lock, the screen displays obtain and release information about the various types of that lock that are currently in use by a cluster nucleus:

  • The system may obtain locks conditionally or unconditionally, synchronously or asynchronously. A conditional request for a lock may be granted or rejected.

  • Releases may be performed synchronously or asynchronously.

Hold ISN Lock

Choosing hold ISN lock (option J) from the Lock Statistics menu displays the following:

14:13:03          ***** A D A B A S  BASIC  SERVICES *****          2014-05-02
DBID  1955                   - Hold ISN Lock -                      PACUX39   
NucID 1021                                                                    
                                                                              
     Obtains                             Alters                               
     ------------------------------      ------------------------------------ 
     Conditional ....            91      Conditional ..........             0 
        Granted .....            91        Granted ............             0 
        Rejected ....             0        Rejected ...........             0 
     Unconditional ..             0      Unconditional ........             0 
                                           Rejected-deadlock ..             0 
     Sync ...........             3                                           
     Async ..........            88      Sync .................             0 
                                         Async ................             0 
     Releases                                                                 
     ------------------------------                                           
     Issued .........            91                                           
        Sync ........             8                                           
        Async .......            83                                           
                                                                              
                                                                              
PF1----- PF2----- PF3------ PF4------ PF6----- PF7------ PF8----- PF12-----   
Help     Repos    Exit      Refresh            PrevLok   NxtLok   Menu        

Use PF7 and PF8 to scroll through the locks; use PF2 to reposition.

Estimating Sizes for the Cache Structure in a Cluster Environment

These instructions describe how to use the structure size calculator to estimate the size for the cache structure in a cluster environment. The cache structure should be made large enough to provide sufficient space for:

  • Tracking all blocks kept in the buffer pools of all connected cluster nuclei (directory elements) and

  • Keeping all changed blocks until they are written to the database (data elements).

The assignment of total cache space into directory and data elements is done via the DIRRATIO and ELEMENTRATIO ADARUN parameters.

The actual cache structure size value is dependent on coupling facility internals and may vary across different coupling facility levels. If the estimates by this structure size calculator are too far off the real allocations reported by cluster nuclei, you can tweak the directory element size value to bring the calculator more in line with the actual coupling facility being used.

Start of instruction setTo access and use the space calculator for the cache structure in a cluster environment

  1. Select option S on the Basic Services Main Menu in AOS.

    The Space Calculation menu appears.

    14:15:27          ***** A D A B A S  BASIC  SERVICES *****          2014-05-02
                                -  Space Calculation  -                 PSP0002   
                                                                                  
                                 Code    Service                                  
                                 ----    ------------------                       
                                  A      ASSO                                     
                                  C      Cluster-Cache/Lock                       
                                  D      DATA                                     
                                  F      DDFILEA                                  
                                  S      SORT                                     
                                  T      TEMP                                     
                                  W      WORK                                     
                                  ?      Help                                     
                                  .      Exit                                     
                                 ----    ------------------                       
                  Code .......... _                                               
                  Database ID ... 1955   (WIS1955)                                
                                                                                  
                                                                                  
                                                                                  
    Command ==>                                                                   
    PF1----- PF2------ PF3------ PF4------ PF6----- PF7----- PF8----- PF12-----   
    Help               Exit                                           Menu        
  2. Select option C on the Space Calculation menu.

    The Cache Structure Calculator panel appears.

    14:17:34          ***** A D A B A S  BASIC  SERVICES *****          2014-05-02
    DBID 1955             -  Cache Structure Calculator  -              PSPC002   
                                                                                  
    Smallest block size in DB ....... 2544                                        
    Largest block size in DB ........ 5724                                        
    Buffer pool size (LBP) .......... 80896_______                                
    Size proper for caching blocks .. 100000______                                
    Max nuclei in cluster ........... 3                                           
    Directory element size .......... 400                                         
    Cache structure size (in KB) .... _________                                   
                                                                                  
    For minimum calculation, leave cache structure size field empty.              
    Modify values, press Enter to provide estimates below.                        
                                                                                  
    Cache CFRM SIZE/INITSIZE ........ 2650        ( 2.5        MB)                
    ADARUN DIRRATIO ................. 67                                          
    ADARUN ELEMENTRATIO ............. 48                                          
    Cache directory elements ........ 135                                         
    Cache data elements ............. 97                                          
    Cache data element size ......... 1024                                        
                                                                                  
    PF1----- PF2------ PF3------ PF4------ PF6----- PF7----- PF8----- PF12-----   
    Help               Exit      Lock                                 Menu        
  3. Specify values for the following fields on the Cache Structure Calculator panel.

    Field Description Default
    Smallest block size Specify a value between 1024 and 32768 bytes. The smallest block size of the current Adabas Online System database ID.
    Largest block size Specify a value between 1024 and 32768 bytes. If the value of the Smallest block size field exceeds this value, then the Smallest block size value is swapped in. The largest block size of the current Adabas Online System database ID.
    Buffer pool size Specify a value between 80,000 and 999,999,999,999 bytes. The value of the LBP parameter setting for the current Adabas Online System database ID.
    Size proper for caching blocks Specify a value between 100000 - 999,999,999,999 bytes. The LBP parameter of the current Adabas Online System database ID, rounded down to nearest 100000. "Size proper" means that this does not include the overhead in the cache structure required for administering these blocks. Thus, this value specifies how much space should be available in the cache structure for keeping changed blocks between buffer flushes and for buffering blocks so that the cluster nuclei do not have to read them from the database.
    Max Nuclei in cluster Specify a value between 2 and 32. 3
    Directory element size Specify a value between 100 and 999 bytes. This value specifies how much space (including the overhead for the access paths) will be used in the cache structure by each directory element. 400
    Cache Structure size Specify a blank for the minimum calculation or specify a value between 100 and 999,999,999 (KB). Although this value is given as an output field, you may want to propose a cache structure size, to see how to allocate the cache space (directory and data elements). blank
  4. Press Enter after all values in the previous step are specified.

    The following output fields on the screen are filled.

    Field Description
    Cache CFRM SIZE/INITSIZE The recommended cache structure SIZE or INITSIZE specification in the coupling facility resource management policy.
    ADARUN DIRRATIO The recommended ADARUN DIRRATIO parameter settings for the cluster nuclei.
    ADARUN ELEMENTRATIO The recommended ADARUN ELEMENTRATIO parameter settings for the cluster nuclei.
    Cache directory The estimated directory and data element counts resulting from the SIZE/INITSIZE and DIRRATIO settings.
    Cache data elements The estimated directory and data element counts resulting from the SIZE/INITSIZE and ELEMENTRATIO settings.
    Cache data element size This (accurate) value depends only on the largest Asso/Data/Work block size in the database.

Estimating Sizes for the Lock Structure in a Cluster Environment

These instructions describe how to use the structure size calculator to estimate the size for the lock structure in a cluster environment. The lock structure should be made large enough to provide sufficient space for:

  • Keeping the lock record elements for all locks held at the same time, and

  • Avoiding too much false contention between locks on different resources.

The number of lock table entries and record elements are shown in the results for comparison with the related cluster nucleus message (ADAX70) and to aid your own calculations.

The actual lock structure size value is dependent on coupling facility internals and may vary across different coupling facility levels. If the estimates by this structure size calculator are too far off the real allocations reported by cluster nuclei, you can tweak the lock record element size value to bring the calculator more in line with the actual coupling facility being used.

Start of instruction setTo access and use the space calculator for the lock structure in a cluster environment

  1. Select option S on the Basic Services Main Menu in AOS.

    The Space Calculation menu appears.

  2. Select option C on the Space Calculation menu.

    The Cache Structure Calculator panel appears.

    14:17:34          ***** A D A B A S  BASIC  SERVICES *****          2014-05-02
    DBID 1955             -  Cache Structure Calculator  -              PSPC002   
                                                                                  
    Smallest block size in DB ....... 2544                                        
    Largest block size in DB ........ 5724                                        
    Buffer pool size (LBP) .......... 80896_______                                
    Size proper for caching blocks .. 100000______                                
    Max nuclei in cluster ........... 3                                           
    Directory element size .......... 400                                         
    Cache structure size (in KB) .... _________                                   
                                                                                  
    For minimum calculation, leave cache structure size field empty.              
    Modify values, press Enter to provide estimates below.                        
                                                                                  
    Cache CFRM SIZE/INITSIZE ........ 2650        ( 2.5        MB)                
    ADARUN DIRRATIO ................. 67                                          
    ADARUN ELEMENTRATIO ............. 48                                          
    Cache directory elements ........ 135                                         
    Cache data elements ............. 97                                          
    Cache data element size ......... 1024                                        
                                                                                  
    PF1----- PF2------ PF3------ PF4------ PF6----- PF7----- PF8----- PF12-----   
    Help               Exit      Lock                                 Menu        
  3. Press PF4 to access the Lock Structure Calculator panel:

    14:16:57          ***** A D A B A S  BASIC  SERVICES *****          2014-05-02
    DBID 1955              -  Lock Structure Calculator  -              PSPL002   
                                                                                  
    Max files in database (MAXFILES) ...... 1000                                  
    Max number of parallel users (NU) ..... 200_____                              
    Number of hold queue elements (NH) .... 800                                   
    Number of threads (NT) ................ 25                                    
    Unique descriptor pool size (LDEUQP) .. 50000                                 
    Lock record element size .............. 260                                   
    Lock structure size (in KB) ...........                                       
                                                                                  
    For minimum calculation, leave lock structure size field empty.               
    Modify values, press Enter to provide estimates below.                        
                                                                                  
    Lock CFRM SIZE/INITSIZE ............... 1478786   ( 1444.1    MB)             
    Number of lock table entries .......... 16777216                              
    Number of lock record elements ........ 5305996    Required min .. 5240000    
                                                                                  
                                                                                  
                                                                                  
                                                                                  
    PF1----- PF2------ PF3------ PF4------ PF6----- PF7----- PF8----- PF12-----   
    Help               Exit      Cache                                Menu        
  4. Specify values for the following fields on the Lock Structure Calculator panel.

    Field Description Default
    Max files in database Specify a value between 3 and 5000. This is the same as the MAXFILES parameter of the ADADEF and ADAORD utilities. The MAXFILES parameter setting of the current AOS database ID.
    Max number of parallel users Specify a value between 20 and 16,777,215. The NU parameter setting of the current AOS database ID.
    Number of hold queue elements Specify a value between 20 and 16,777.215. . The NH parameter setting of the current AOS database ID.
    Unique descriptor pool size Specify a value between 1 and 999,999,999. The LDEUQP parameter setting of the current AOS database ID.
    Lock record element size Specify a value between 100 and 999. This parameter specifies how much space (including the overhead for the access paths) will be used by each lock record element in the lock structure. 260
    Lock structure size Specify a blank for the minimum calculation or specify a value between 100 and 999,999,999 (KB). Although this value is given as an output field, you may want to propose a lock structure size, to see how to allocate the lock table entries and lock table elements. blank
  5. Press Enter after all values in the previous step are specified.

    The following output fields on the screen are filled.

    Field Description
    Lock CFRM SIZE/INITSIZE The recommended lock structure SIZE or INITSIZE specification in the coupling facility resource management policy.
    Number of lock table entries The calculated count of lock table entries resulting from the SIZE/INITSIZE setting.
    Number of lock record elements The estimated count of lock record elements resulting from the SIZE/INITSIZE setting. You must actually start a cluster nucleus with the specified parameters to see how many lock record elements it gets from the lock structure. The number on the right side is the minimum number of lock record elements required to be available by the starting cluster nuclei.

Maintain the User Table

Note:
This option is available in Adabas nucleus cluster environments only.

A new function has been added to the Session Opercoms menu to support the CLUFREEUSER command. When option V (User Table Maintenance) is selected, the following screen is displayed:

15:10:47          ***** A D A B A S  BASIC  SERVICES *****          2014-05-02
                         - User Table Maintenance -                 PACIV02   
                                                                              
                       Code    Service                                        
                       ----    -------------------------                      
                        C      Begin CLUFREEUSER process                      
                        ?      Help                                           
                        .      Exit                                           
                       ----    -------------------------                      
         Code ......... _                                                     
         TNA .......... 0______                                               
         UID .......... ___________________                                   
         Force ........ _                                                     
         Global ....... _                                                     
                                                                              
         Database ID .. 1955  (WIS1955)              NucID .. 1021            
                                                                              
                                                                              
                                                                              
                                                                              
Command ==>                                                                   
PF1----- PF2------ PF3------ PF4------ PF6----- PF7----- PF8----- PF12-----   
Help               Exit                                           Menu        

The CLUFREEUSER command is only valid in cluster environments. It can be issued against the local nucleus only or, with the Global option, against all active and inactive nuclei in the cluster.

The command is used to delete leftover user table elements (UTEs) in common storage that are no longer associated with user queue elements (UQEs) in a nucleus where

TNA is a decimal number specifying the timeout value in seconds. UTEs that are not used during the time specified may be deleted if other conditions are fulfilled. If TNA is not specified, UTEs may be deleted without regard to their recent use.
UID is a character string or hexadecimal byte string as follows:
cccccccc where the argument is 1-8 letters, digits, or embedded '-' signs without surrounding apostrophes.
'cccccccc' where the argument is 1-8 characters with surrounding apostrophes.
X'xxxxxxxxxxxxxxxx' where the argument is an even number of 2-16 hexadecimal digits enclosed by X' '.
A character string must be enclosed in apostrophes if it contains characters other than letter, digits, or embedded '-' signs. If a specified character string is less than 8 characters long, it is implicitly padded with blanks. If a specified hexadecimal string is shorter than 16 hexadecimal digits, it is implicitly padded with binary zeros.
If the last 8 bytes of a user's 28-byte communication ID match a specific user ID or user ID prefix, that user's UTE may be deleted if other conditions are fulfilled.
If UID not specified, UTEs may be deleted regardless of their user IDs.
FORCE Delete leftover UTEs even if the users are due a response code 9 (ADARSP009), subcode 20. If FORCE is not specified, such UTEs are not deleted. Before using the FORCE parameter, ensure that the users owning the UTEs to be deleted will not expect any of their transactions to remain open. Specify FORCE on this screen by marking the Force field with any character.
GLOBAL Delete leftover UTEs throughout the Adabas cluster if they are no longer associated with UQEs and are eligible according to the other specified parameters. Additionally and subject to the other rules, delete leftover UTEs if their assigned nuclei have terminated since their last use. If GLOBAL is not specified, only UTEs assigned to the local nucleus and used since the nucleus start are eligible for deletion. Specify GLOBAL on this screen by marking the Global field with any character.