Monitoring

Data Virtualization Manager server provides powerful diagnostic tools that can record critical events for individual transactions. This information can be used to diagnose, debug, and correct problems.

Data Virtualization Manager server provides the following trace options:
  • Server Trace
  • Instrumentation Server (IS)
  • Server Trace Archival Facility
  • SQL Tracing

Server Trace

The Server Trace adds Data Virtualization Manager server trace records to a trace buffer maintained in virtual storage. When the session is finished, the trace records are automatically saved in a VSAM data set.

Trace records are written for the following actions:
  • SQL operations
  • IMS calls
  • CICS calls
  • Communication events (LU 6.2, TCP/IP, and messages)
  • Thread attach and detach events
  • Remote Procedure Call (RPC) events
  • Message events
  • Errors (abends)

A Remote Procedure Call (RPC) can add its own trace messages to the trace for diagnostic purposes.

Using Trace Browse, you can perform the following actions:

  • Display formatted columns of information, such as user ID and time
  • Use FIND and LOCATE commands to search for data or a specific time and date
  • Use the DISPLAY command to display additional columns of information
  • Use the STATUS command to display the Trace Browse status area

In general, the Server Trace can accommodate the complete record of all client/server processing for several days. However, using hierarchical storage management, you can maintain an unlimited history of data. The Server Trace data collection routines support collection of all the data required for auditing, capacity planning, and trend analysis of usage patterns. You can set security for the Server Trace filter functionality to prohibit viewing of sensitive data by a non-authorized user.

Instrumentation Server

Using the Instrumentation Server (IS), you can run multiple instances of the server in a sysplex and route trace information to a single repository so that you have a global view of all activity.

Server Trace Archival Facility

Use the Server Trace Archival Facility to back up, or archive, active trace information. The archive consists of a large block of virtual storage, which can be backed up by a data-in-virtual (DIV) linear data set. This block of virtual storage is sub-divided into the following parts:

  • The status area occupies the first 4 KB page of the virtual storage and contains checkpoint information about the trace area and information about the most recent trace archive.

  • Event blocks begin in the second 4 KB page of the virtual storage area. Each event block occupies 896 bytes of storage. Each server event is recorded in the next available slot, beginning with the first slot, continuing to the end of the event blocks, and wrapping around to the beginning of the event block.

  • Vector tables each begin on a 4 KB page boundary, and are located after the event blocks in the trace storage. Each vector table contains index information that allows views of the trace to be filtered without searching through the entire virtual storage area occupied by each individual event block.

SQL Trace

The SQL Trace program provides details about all of the SQL statements that applications issue. The information that is displayed in the SQL Trace program is derived from the main SDB log by using connection IDs as the selection criterion.

When you select an active session, the SQL Trace displays the current information. To refresh the information, press Enter.