|
Field Name |
Start |
Length |
Display |
Type |
Default Column Header |
Description |
|---|---|---|---|---|---|---|
|
SQLDBASE |
29 |
8 |
|
A/N |
DATABASE NAME |
SQL/DS Database name |
|
SQLUSRID |
37 |
8 |
|
A/N |
USER IDENTIFIER |
SQL/DS User identifier |
|
SQLVMID |
45 |
8 |
|
A/N |
MACHINE USERID |
SQL/DS Database machine user ID |
|
SQLPROG |
53 |
8 |
|
A/N |
LAST ACTIVE MODULE |
SQL/DS Access module last active |
|
SQLACTV |
61 |
4 |
9,999,999,999 |
BINP |
ACTIVE TIME |
SQL/DS time that the user was connected (in seconds) |
|
SQLCPU |
65 |
4 |
9,999,999,999 |
BINP |
CPU USAGE |
SQL/DS processor time used in milliseconds |
|
SQLBUFF |
69 |
4 |
9,999,999,999 |
BINP |
BUFFER READS |
Number of looks into the page buffer |
|
SQLRECTYP |
75 |
1 |
|
A/N |
REC TYPE |
Record type-code (U) |
|
SQLRECID |
76 |
3 |
|
A/N |
REC ID |
Record identifier (SQL) |
|
SQLACTV$ |
185 |
4 |
99,999,990.99 |
BINP |
COST FOR CONNECT TIME |
Cost for active time |
|
SQLCPU$ |
189 |
4 |
99,999,990.99 |
BINP |
COST FOR CPU USAGE |
Cost for CPU usage |
|
SQLPBUF$ |
193 |
4 |
99,999,990.99 |
BINP |
COST FOR BUFFER READS |
Cost for page buffer reads |
| Copyright © 2011 CA. All rights reserved. | Tell Technical Publications how we can improve this information |