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 will contain a set of the columns described in the table below.

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 the process is waiting on 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 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 which notifications the client supports.

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

Table 2. PROMON Processes/Clients Status Wait column additional values
Wait type Additional information
REC rowid
SCH Type of schema lock:
  • 12 — share lock
  • 10 — exclusive lock
TRAN taskid
RGET rowid
BKSH dbkey
BKEX dbkey
BIRD dbkey (bi)
BIWR dbkey (bi)
AIRD dbkey (ai)
ARWR dbkey (ai)
TXS

2 — TXE update

3 — TEX commit
TXB

1 — TXE share

2 — TXE update

3 — TXE commit
TXE

1 — TXE share

2 — TXE update

3 — TEX commit
TXX

1 — TXE share

2 — TXE update

3 — TEX commit

The Processes/Clients menu choices are:

  • All Processes — Displays status information about OpenEdge processes. The following 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 — The clients listed are waiting for a database-related resource. The following shows a sample Blocked Clients Status display. The clients listed are waiting for a database-related resource. 
    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 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 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 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 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 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
  • 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