| column | sysmaster | description
|
| sid | syssesprof | session id |
| lockreqs | syssesprof | number of times a lock was requested |
| locksheld | syssesprof | number of locks held |
| lockwts | syssesprof | number of times had to wait for a lock |
| deadlks | syssesprof | number of times had a dead lock |
| lktouts | syssesprof | number of times a lock wait timed out |
| logrecs | syssesprof | number of logical log records written by this session |
| isreads | syssesprof | isam read operations |
| iswrites | syssesprof | isam write operations |
| isrewrites | syssesprof | isam re-write operations |
| isdeletes | syssesprof | isam delete operations |
| iscommits | syssesprof | isam commit operations |
| isrollbacks | syssesprof | isam rollback operations |
| longtxs | syssesprof | number of long transactions |
| bufreads | syssesprof | number of times read a buffer |
| bufwrites | syssesprof | number of times write to a buffer |
| seqscans | syssesprof | number of times tables were sequentially scanned |
| pagreads | syssesprof | number of times a page was read |
| pagwrites | syssesprof | number of times a page was written |
| total_sorts | syssesprof | total number of sorts |
| dsksorts | syssesprof | sorts that had to be performed on disk |
| max_sortdiskspace | syssesprof | maximum disk space used by a sort |
| logspused | syssesprof | number of bytes of logical log space used |
| maxlogsp | syssesprof | maximum log space used by session |
| | | |
| username | syssessions | user who owns the session |
| userid | syssessions | user id of owner of the session |
| pid | syssessions | process id of client |
| hostname | syssessions | host of client process |
| tty | syssessions | tty of client process |
| connected | syssessions | time stamp when session connected |
| feprogram | syssessions | identify of client software |
| pooladdr | syssessions | session pool address |
| is_wlatch | syssessions | 1=session waiting for a latch |
| is_wlock | syssessions | 1=session waiting for a lock |
| is_wbuff | syssessions | 1=session waiting for a buffer |
| is_wckpt | syssessions | 1=session waiting for a check point |
| is_wlogbuf | syssessions | 1=session waiting for a logical log buffer |
| is_wtrans | syssessions | 1=session waiting for a transaction |
| is_monitor | syssessions | 1=process is monitor |
| is_incrit | syssessions | 1=process is in critical section |
| state | syssessions | flags describing state of session |
| | | |
| sqs_dbname | syssqlstat | name of database connected to |
| sqs_iso | syssqlstat | isolation level of sql statement |
| sqs_lockmode | syssqlstat | lock mode of sql statement |
| sqs_sqlerror | syssqlstat | sql error, if any |
| sqs_isamerror | syssqlstat | isam error, if any |
| sqs_feversion | syssqlstat | version of client on front end |
| sqs_statement | syssqlstat | current sql statement text |
| | | |
| lockmode | infx | description of session lock mode |
| isolevel | infx | description of isolation level |
| waitfor | infx | descriptive text of what is being waited for |
| class | infx | class for status of session e.g. good, bad, warn |
| condate | infx | decoded connection time stamp |
| location | infx | description of where session comes from (host/tty) |
| sql_statement | infx | sql being executed |
| sql_short | infx | short description of sql e.g. select, update, insert |