Field Name | Start | Length | Display | Type | Default Column Header | Description |
---|
SQLVMID | 1 | 8 | | A/N | MACHINE USERID | User ID creating the record |
SQLDUSER | 9 | 8 | | A/N | VM USERID | VM user ID |
SQLDUIDN | 17 | 8 | | A/N | SQL USER IDENTIFIER | SQL user identifier |
SQLDACNT | 25 | 8 | | A/N | ACCOUNT NUMBER | User data account number |
SQLDBASE | 33 | 8 | | A/N | DATABASE NAME | User data database name |
SQLEDATE | 41 | 6 | | A/N | END DATE | End date |
SQLETIME | 47 | 6 | | A/N | END TIME | End time |
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) |