 |
» |
|
|
|
SYSTEM.CALL is a pseudotable that contains information
about current internal (DBCore) calls, such as whether a
user's process is running, waiting for a lock, waiting
for a page to be freed, and so forth. You can use SYSTEM.CALL
to determine which users are accessing the DBEnvironment.
SYSTEM.CALL supports an unlimited number of users,
transactions, and sessions. Table 8-3 System.Call |
Column Name | Type | Length | Description |
|---|
| USERID | CHAR | 20 | DBEUserID
| | CID | INTEGER | 4 | Unique connection identifier
| | SID | INTEGER | 4 | Session identifier. If the same USERID has multiple connections
to the same DBEnvironment from the same application (including
ISQL), all connections have the same SID.
If the user has multiple connections to the same DBEnvironment
from separate applications, each application (or ISQL session)
will have a different SID.
For more information about multiple DBEnvironment connections,
see the section "Using Multiple Connections and Transactions
with Timeouts" in the "Using ALLBASE/SQL" chapter of the ALLBASE/SQL Reference Manual.
| |
FUNCTION
|
INTEGER
|
4
| Internal function code:
- 1
start session - 2
terminate session - 3
begin transaction - 4
end transaction - 5
abort transaction - 6
status - 7
relation lock - 8
checkpoint - 9
open index scan - 10
open thread scan - 11
open relation scan - 12
next - 13
close scan - 14
fetch TID - 15
fetch first - 16
insert - 17
delete - 20
define DBEFileSet - 19
drop DBEFileSet - 20
associate DBEFileSet - 21
disassociate DBEFileSet - 22
update - 23
define table - 24
drop table - 25
alter table - 26
create index - 27
drop index - 28
set index clustering - 29
set index uniqueness - 30
read counters - 31
sort - 32
get statistics - 33
read account - 34
create DBEFile - 35
drop DBEFile - 43
display parameter - 44
display directory data - 45
start server - 46
terminate server - 47
terminate DBCORE - 48
start DBCORE - 49
open list scan - 50
savepoint - 51
restore - 52
begin archive - 53
end archive - 54
abort archive - 55
change DBEFile type - 56
trace on - 57
trace off - 58
log memo - 59
define parent relationship - 60
define child relationship - 61
drop parent/child relationship - 65
relation to relation - 66
rename DBEFile - 67
update session info - 68
modify scan - 69
verify predicate - 70
extend DBEFile - 71
retrieve single tuple - 72
define scratch space - 73
drop scratch space - 74
add a new log - 75
purge an existing log - 76
display log info - 77
get backup flag status - 78
reset backup flag - 79
resume recovery - 80
terminate recovery - 81
reset backup flag - 82
version id - 83
delete a thread - 84
quiesce the database - 85
unquiesce the database - 86
check index - 87
open log scan - 88
transmit log - 89
apply log - 90
close log scan - 91
get synchronization checkpoint information - 92
modify synchronization checkpoint information - 93
alter integrity deferral - 94
migrate MARSCH for dynamic space expansion - 95
bind parent/child relationship - 96
set timeout - 97
increment table version - 98
get table version number - 99
put section to offline heap - 100
get section from offline heap - 101
purge section from offline heap - 102
open recovery scan - 103
close recovery scan - 104
fetch from recovery scan - 105
get tran info - 106
log persistent information - 107
forget record - 108
detach transaction - 109
alter table type - 110
add to columns - 111
fix DBCore structures through SQLMigrate - 112
switchlog - 113
parallel scan - 114
truncate table - 115
alter transaction attributes - 116
detach - 117
attach - 118
open status scan - 119
fetch from status scan - 120
close status scan
| | XID |
INTEGER
|
4
|
Unique transaction identifier
| |
STATUS
|
CHAR
|
20
| Internal status:
- 30
Running - 31
Waiting on LOCK - 32
Waiting on LATCH - 33
Waiting for PAGE - 35
Waiting for SERVICE - 36
Waiting (Other) - 37
Throttle Wait
|
Example | |
SELECT * FROM System.Call;
------------+--------+-----------+-----------+-----------+------------------
USERID |CID |SID |FUNCTION |XID |STATUS
------------+--------+-----------+-----------+-----------+------------------
JOHN@BROCK | 108| 108| 6|-2091903712|Running
---------------------------------------------------------------------------
Number of rows selected is 1
U[p], d[own], l[eft], r[ight], t[op], b[ottom], pr[int] <n>,or e[nd]> e
|
|
