AVZ.SESSIONS
The AVZ.SESSIONS table contains one Interval record for each SQL user for each recording interval. It also contains Sessions records that have the total information for the entire connection.
| Column | Description |
|---|---|
| USERID | User ID associated with the record. |
| CLIENT_SYSTEM | Client PC name. |
| PROTOCOL | Either TCP/IP or LU 6.2. |
| RECORD_TYPE | Either Session or Interval. |
| TOTAL_CPUTIME | Total CPU time. |
| SRB_CPUTIME | SRB CPU time. Time is included in TOTAL_CPUTIME. |
| DATABASE_CPUTIME | Total database CPU time that is used by IMS and DB2. This field does not reflect CPU usage by RPCs that access IMS and DB2. |
| NETWORK_CPUTIME | Total network CPU time trappable within Data Virtualization Manager server.
Note: Network CPU time cannot be trapped within Data Virtualization Manager server. Therefore, this field may not reflect the total CPU time.
|
| REXX_CPUTIME | Total CPU time that is used by running SEF REXX programs. |
| RPC_CPUTIME | Total CPU time that is used by RPCs. This time includes CPU time that is used in DB2 and IMS if the RPCs accessed these databases. |
| SSL_CPUTIME | SSL processing CPU time. |
| ENCLAVE_CPUTIME | Total CPU time that is associated with the WLM enclave.
Note: Other CPU times in this record may also be associated with the Enclave CPU time. Also, other tasks may have contributed CPU time to the same Enclave.
|
| ZIIP_QUALIFIED | Enclave zIIP qualified CPU time. |
| ZIIP_CPU | Enclave zIIP CPU time. |
| ZIIP_ON_CP | Enclave zIIP time on CP. |
| OTHER_CPUTIME | All of the unaccountable CPU time. |
| SMFID | The SMFID as defined within Data Virtualization Manager server. |
| PRODUCT_SUBSYSTEM | The 4-character IBM Data Virtualization Manager for z/OS subsystem ID. |
| DRIVER_VERSION | The IBM Data Virtualization Manager for z/OS Driver version. |
| DRIVER_DATE | The IBM Data Virtualization Manager for z/OS Driver date. |
| CONNECTION_ID | The unique Data Virtualization Manager server connection ID. |
| LOGON_TIME | Time the user logged on. |
| LOGOFF_TIME | Time the user logged off. For Interval records, this value is NULL. |
| INTERVAL_START | Interval start time. For Sessions records, this value is NULL. |
| CONNECT_TIME | Number of seconds the user was connected. For Interval records, this value is NULL. |
| BYTES_READ | Total number of bytes of data that is read from the client workstation. |
| BYTES_WRITTEN | Total number of bytes written to the client workstation. |
| COMMIT_COUNT | Total number of commits performed. |
| ROLLBACK_COUNT | Total number of rollbacks performed. |
| SQL_COUNT | Total number of SQL queries run. |
| RPC_COUNT | Total number of RPCs run. |
| ABEND_CODE | Abend for the session, if one occurred. For Interval records, this value is NULL. |
| IP_ADDRESS | For TCP/IP connections, this is the IP address of the client workstation; otherwise, this value is NULL. |
| LU_NAME | For LU 6.2 connections, the LU name that is used for the connection. |
| ORIGINAL_USERID | Original user ID, recorded in case it was changed by a SEF rule. |
| PLAN | DB2 plan that is used. |
| DATABASE | DB2 subsystem to which the user is connected. |
| DB_GROUP_MEMBER | DB2 group attachment member name. |
| APPLICATION | Application name. The client’s ODBC connection information sets this value. |
| USERPARM | Optional userparm from the client. The client’s ODBC connection information sets this value. |
| ELAPS_READ_TIME | The total number of read operations from Data Virtualization Manager server to the Client. |
| TOTAL_READ_COUNT | The total time (in seconds) that those reads were outstanding. If you ignore the transmission times, the time is the user response time. |