Skip to end of metadata
Go to start of metadata

x_cons <database_name> show regions all

Shows information about the critical sections (regions). If you use show regions only regions are displayed, which have an owner or waiting tasks.

Index  Region    Owner    Get-Cnt    Tas-Cnt      Coll.    Waits Excl   Coll %
    1  PAGER                20420          0         97       42    0   0.48 %
    2  CONFIG                   0          0          0        0    0   0.00 %
    3  CONV1               924707         20        606        2    0   0.07 %
    :
   10  CONV8               924857         22        549      119    0   0.06 %
   11  DATACACH                 0          0          0        0    0   0.00 %
   12  DCOM                     0          0          0        0    0   0.00 %
   13  DIAGCACH             12906          0          0        0    0   0.00 %
   14  FBM                1453287          1        212      174    0   0.01 %
   15  GARBAGE                985          0          0        0    0   0.00 %
   16  LOCKINIT           2512511         26         89        0    0   0.00 %
   :
   24  LOGQUE4                 10          0          0        0    0   0.00 %
   25  LOGINFO                302          0          0        0    0   0.00 %
   26  LVC_EMCY                 0          0          0        0    0   0.00 %
   27  MONITOR                  0          0          0        0    0   0.00 %
   28  SERVER              190848          0          3        0    0   0.00 %
   29  SRVTASK               6677          0         88        1    0   1.32 %
   30  SURROGAT            291763          0          0        0    0   0.00 %
   31  CONVINDX               112          0          0        0    0   0.00 %
   32  KNLWAIT                  4          0          0        0    0   0.00 %
   33  TRACE                    0          0          0        0    0   0.00 %
   34  COMP_END                 0          0          0        0    0   0.00 %
   35  LOCKPAR                  0          0          0        0    0   0.00 %
   36  CLSTERIO             10812          0        188        0    0   1.74 %
   :
   47  SAVE2                   56          0          0        0    0   0.00 %
   48  DATA1              2412446         65        295        0    0   0.01 %
  :
   81  DATA34             3358244       6013       5320        0    0   0.16 %
  :
  111  DATA64             2300501         17        183        1    0   0.01 %
  112  TRANS1             1654206          0          6        0    0   0.00 %
  :
  119  TRANS8             2564560        618       6115        0    0   0.24 %
  120  TAB9               7636104        254       1771        0    0   0.02 %
  :
  135  ROW24              1340953          0          1        0    0   0.00 %

  • Region: Region name
  • Owner: If the critical section is held by a task, the Task ID appears here. If the tasks are waiting for this critical section in the region queue, then the following lines of the list of tasks with IDs will be displayed. If tasks are waiting for this critical region in the region queue, then a list of these tasks appears in the following lines.
  • Get-Cnt: Number of hits on this critical region.
  • Tas-Cnt: Number of wait tasks. It specifies the number of conflicts that occurred when the region administration function was accessed (simultaneous entry/exit of tasks running in different UKTs).
  • Coll.: The absolute number of collisions on a critical section.
  • Waits: Wait number, how often a task was waiting in the queue. For MAXCPU=1, this value corresponds to the number of collisions.
  • Coll %: Collision rate on this critical region.

Further Information

SAP MaxDB Regions
XCONS Options for Displaying Information about the Database
Region