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 |