 |
» |
|
|
|
SYSTEM.ACCOUNT is a pseudotable that contains information about I/O
resource usage by users currently accessing the DBEnvironment.
This table is initially empty, and ALLBASE/SQL
updates it whenever a user queries the DBEnvironment,
including accessing a system catalog view.
SYSTEM.ACCOUNT supports an unlimited number of users,
transactions, and sessions. Table 8-2 System.Account | 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)
has 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.
| |
NPA
|
INTEGER
|
4
|
Number of page accesses
| |
NLB
|
INTEGER
|
4
|
Number of log bytes written
| |
NTP
|
INTEGER
|
4
|
Number of temporary pages allocated
| |
NPP
|
INTEGER
|
4
|
Number of permanent pages allocated
|
Example | |
SELECT * FROM System.Account;
--------------------+-----------+-----------+-----------+-----------
USERID |CID |SID |NPA |NLB
--------------------+-----------+-----------+-----------+-----------
JOHN@BROCK | 108| 108| 23| 0
--------------------------------------------------------------------
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
+-----------+-----------
|NTP |NPP
+-----------+-----------
| 0| 0
------------------------
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
|
|
