|
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 76 lists the possible types.
|
|
Wait
|
The wait type. Table 77 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 79 lists the possible states.
|
|
Pid
|
The process ID number.
|
|
Serv
|
The server number serving the remote client.
|
|
Schema Timestamp
|
The Unix Epoch timestamp of the user’s schema cache.
|
|
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
|
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.
|
09/26/16 Status: User Notification Processes
00:14:21 Usr:Ten Name Domain Type Wait Wait Info Trans id Poll time Notifications Last poll time Schema Timestamp 5 kmonico -4 SELF/ABL -- 0:0 0 12 R:- 09/26/16 10:12 1474899129 8 kmonico -4 SELF/ABL -- 0:0 0 12 R:- 09/26/16 10:12 1474899132 12 kmonico -4 SELF/ABL -- 0:0 0 12 R:- 09/26/16 10:12 1474899143 16 kmonico -4 SELF/ABL -- 0:0 34090 12 -:R 09/26/16 10:12 1474899147 |