Displays status information about OpenEdge processes. The menu options allow you to choose all processes or a subset. Depending on your selection, the status display contains a set of the columns described in the following table.

Table 1. PROMON Processes/Clients Status display columns
Column name Description
Usr:Ten

The user number and tenant ID of the process.
Name The user name of the process.
Domain

The domain name of the user of the process.
Type

The process type. Table 1 lists the possible types.
Wait

The wait type. Table 2 describes the possible types. If no value is displayed, the process is not waiting on any database-related events.

Wait Info The ID of a resource on which the process is waiting if the Wait field has a value. For example, if waiting on a record lock, Wait Info contains rowid : partition.
Login TimeStart Time The time when the process logged into the database.
Trans id The user's transaction ID.
Tx Start Time The time when the transaction started.
Trans State

The state of the transaction. Table 2 lists the possible states.
Pid The process ID number.
Serv The server number serving the remote client.
Poll Time The interval at which the user checks for identification.
Complete seq The sequence number of the last notification completed by the user.
In progress seq The sequence number of the last notification sent to the user.
Last poll time The time the user last checked for notifications.
Schema Timestamp The Unix Epoch timestamp of the user's schema cache.
Notify version The internal version identifier that shows the notifications that the client supports.

For certain wait values, an additional field is displayed. The following table lists the possible values.

Table 2. PROMON Processes/Clients Status Wait column additional values
Wait type Additional information
REC Row (record) lock rowid
SCH Type of schema lock:
  • 12 — share lock
  • 10 — exclusive lock
TRAN Transaction commit taskid
RGET Row get lock rowid
BKSH Share lock on database buffer dbkey
BKEX Exclusive lock on database buffer dbkey
BIRD Before-image buffer read from disk dbkey (bi)
BIWR Before-image buffer write to disk dbkey (bi)
AIRD After-image buffer read from disk dbkey (ai)
AIWR After-image buffer write to disk dbkey (ai)
TXS Transaction end share lock

2 — TXE update

3 — TXE commit
TXB Transaction end update mode lock

1 — TXE share

2 — TXE update

3 — TXE commit
TXE Transaction end commit mode lock

1 — TXE share

2 — TXE update

3 — TXE commit
TXX Transaction end exclusive lock

1 — TXE share

2 — TXE update

3 — TXE commit

The Processes/Clients menu choices are:

  • All Processes — Displays status information about OpenEdge processes. The following example shows a sample Processes/Clients Status display. 
    08/04/15        Status: All Processes by user number
18:06:31

  Usr:Ten   Name      Domain     Type       Wait   Wait Info  Trans id    Login time     Schema Timestamp
    0:0     dba                  BROK       --           0:0        0   08/04/15 15:23                  0
    5:4     lobtenant lobtenant  SELF/ABL   --           0:0        0   08/04/15 17:59         1312480672
    6:2     tenant2   tenant2    SELF/ABL   --        4267:0        0   08/04/15 17:59         1312480680
    9:0     dba                  MON        --           0:0        0   08/04/15 16:10         1312474208
  • Blocked Clients — Displays the list of clients waiting for a database-related resource. The following example shows a sample Blocked Clients Status display. 
    08/04/15        Status: Blocked Clients by user number
18:06:31

  Usr:Ten   Name      Domain     Type       Wait   Wait Info  Trans id    Login time     Schema Timestamp
    6:2     tenant2   tenant2    SELF/ABL   REC       4267:0        0   08/04/15 17:59         1312480680
  • Active Transactions — Displays status information about active transactions. The following example shows a sample Active Transactions Status display.
    08/04/15        Status: Active Transactions by user number
18:06:31

  Usr:Ten   Name      Domain     Type       Login time     Tx start time Trans id Trans State
   6:ST     st_barb        1    SELF/ABL    08/04/15 23:50 08/04/15 23:53    475      Active
  • Local Clients — Displays status information about local client processes. The following example shows a sample Local Clients status display.
    08/17/15       Status: Local Clients by user number
19:21:09

Usr:Ten    Name      Domain   Type      Wait   Wait Info   Trans id  Login time        Pid  Schema Timestamp
  6       shannon             SELF/ABL   --                0         08/17/15 19:21  10664        1318879261
  • Batch Clients — Displays status information about local and remote batch client processes. The following example shows a sample Local Batch Clients Status display.
    
09/16/15        Status: Batch Clients by user number for all tenants
15:18:12

Usr:Ten   Name      Domain    Type      Wait     Wait Info  Trans id   Login time    Pid    Schema Timestamp
  5       shannon       -4     SELF/ABL   --        0:0        29371  09/16/15 15:17 6451        1438728061
  • Remote Clients — Displays status information about remote client processes. The following example shows a sample Remote Clients Status display.
    09/09/15        Status: Remote Clients by user number for all tenants
20:20:02

Usr:Ten  Name     Domain   Type      Wait    Wait Info  Trans id   Login time    Serv IPV# Remote Address  Schema Timestamp
 24      shannon      -3   REMC/ABL   --       0:0        29369  09/09/15 20:19    1 IPV4 192.168.197.28        1438728061
  • Background Processes — Displays status information about background database processes. The following example shows a sample Background Processes Status display.
    08/25/15      Status: Background Processes Status
16:10

Usr:Ten   Name   Domain   Type    Start time          Pid
0:0       SYSTEM      0   BROK    08/25/15 10:31    16140
5:0       rgw         0   MON     08/25/15 11:12    16145
6:0       ortiz       0   BIM     08/25/21 11:45    16170
  • Connected Tenants — Displays status information about connected tenants.
    10/27/11            Currently Connected Tenants
00:14:21

     Sel     Tenant Id    Name             User Count
       1           -1     super_tenant           1
  • User Notification Processes — Displays status information about users with Database Client Notification enabled.
    12/10/19        Status: User Notification Processes
15:09:06

  Usr:Ten   Name      Domain     Type      Wait            Wait Info  Trans id  Poll time   Complete seq   In progress seq   Last poll time   Schema Timestamp  Notify version

    6:2     pjones         4      SELF/ABL   --               0:0            0         90              5                 9   12/10/19 13:34         1576002082               1
   23:ST    bdixon         1      REMC/ABL   --               0:0            0         90             15                19   12/10/19 15:09         1576004248               1
   24:1     jsmith         2      REMC/ABL   --               0:0            0         90             15                19   12/10/19 15:09         1576004248               1
  • Connection Details — Displays the extended name, as provided in the .lg file. For multi-session PAS connections, the connection details identify each session with a unique identifier, for example, AS-4 for the first user shown.
    For example, the connection string 0:oe1xc7stg03:32441:AS-4 contains this information:
    • 0 – Container PID when PAOSE is running in a container. This currently always holds value 0.
    • oelxc76stg03 – Hostname where PASOE is running.
    • 32441 – PID of PASOE MS Agent.
    • AS-4 – ID of ABL session running in PASOE MS Agent 32441.
    12/13/21        Status: Connection Details  
17:13:24        

  Usr:Ten   Name      Domain  Type          Pid     Tid    SPid    STid  Login time     Connection Details

    2       chan         -4  REMC/PASN   32441   32447   32449   32474 12/13/21 17:13  0:oelxc76stg03:32441:AS-4
    4       chan         -4  REMC/PASN   32441   32447   32478   32511 12/13/21 17:13  0:oelxc76stg03:32441:AS-7
    6       chan         -4  REMC/PASN   32441     593     595     603 12/13/21 17:13  0:oelxc76stg03:32441:AS-8
    8       chan         -4  REMC/PASN   32441     593     607     620 12/13/21 17:13  0:oelxc76stg03:32441:AS-9
    9       chan         -4  REMC/PASN   32441     621   32449     622 12/13/21 17:13  0:oelxc76stg03:32441:AS-10
   10       chan         -4  REMC/PASN     650     658   32478     659 12/13/21 17:13  0:oelxc76stg03:650:AS-4
   11       chan         -4  REMC/PASN     650     658     595     663 12/13/21 17:13  0:oelxc76stg03:650:AS-7
   12       chan         -4  REMC/PASN     650     658     607     665 12/13/21 17:13  0:oelxc76stg03:650:AS-8
   13       chan         -4  REMC/PASN     650     669   32449     670 12/13/21 17:13  0:oelxc76stg03:650:AS-9
   14       chan         -4  REMC/PASN     650     672   32478     675 12/13/21 17:13  0:oelxc76stg03:650:AS-10

OpenEdge Monitor Session End.