AVZ.SERVICES
The AVZ.SERVICES table shows statistics information for Services.
| Column | Description |
|---|---|
| ORIGINAL_URL | The URL where the Web Service is stored. |
| CLIENT_USERID | The user ID of the client that sent the request. |
| CLIENT_SYSTEM | The system that sent the request. |
| CLIENT_AUTH_USAGE | The authentication mechanism used. |
| REQUEST_TYPE | The type of service request: Web Service, Terminal Service, or WSCICSCONN request. |
| RECORD_TYPE | The type of record this is: Interval Summary, Virtual Directory Summary, Web Service Summary, Operation Summary, or Session Detail. |
| RECORD_COUNT | Transaction count for Summary records. |
| TOTAL_CPUTIME | Total CPU time used. CPU time may also be accounted for in the Enclave 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. CPU time may also be accounted for in the Enclave CPU time. |
| NETWORK_CPUTIME | Total network CPU time trappable within Data Virtualization Manager server. CPU time may also be accounted for in the Enclave CPU time.
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. CPU time may also be accounted for in the Enclave CPU time. |
| USER_PGM_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. CPU time may also be accounted for in the Enclave CPU time. |
| SSL_CPUTIME | Total CPU time that is used in processing SSL routines. CPU time may also be accounted for in the Enclave 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. CPU time may also be accounted for in the Enclave CPU time. |
| CONNECTION_ID | The unique Data Virtualization Manager server connection ID. |
| GMT_LOGON | Time the user logged on in Greenwich Meridian Time. |
| LOGON_TIME | Time the user logged on. |
| CONNECT_TIME | The number of seconds the user was connected. |
| INTERVAL_START | The adjusted interval start time. |
| BYTES_READ | Total bytes read. |
| BYTES_WRITTEN | Total bytes written. |
| HTTP_STATUS | The HTTP Status code that is returned for this request. |
| SMFID | The SMFID as defined within Data Virtualization Manager server. |
| PRODUCT_SUBSYSTEM | The name of the IBM Data Virtualization Manager for z/OS subsystem ID. |
| SERVER_CODE | Overall return code for the transaction. |
| SERVER_REASON | Associated reason code, if any. |
| SERVER_ABEND | Abend code for the transaction, if one occurred. |
| IP_ADDRESS | For TCP/IP connections, this is the IP address of the client workstation; otherwise, this value is null. |
| PORT | TCP/IP port number for this connection. |
| VIRTUAL_DIRECTORY | Alternate name (50 characters max) used to uniquely identify a virtual directory. |
| WEB_SERVICE | The name of the Web Service invoked. |
| NAME_SPACE | The namespace of the Web Service invoked. |
| OPERATION | The Operation of the Web Service invoked. |
| TARGET_SYSTEM | The name of the Target System used to process this request. |
| SOAP_FAULT | Some of the text of the Soap Fault message generated, if any. |