 |
» |
|
|
|
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 | Unique session identifier | | 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 | 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
|
|
