Hvrstatistics

Contents

Name

hvrstatistics - Extract statistics from HVR scheduler logfiles.

Since HVR 5.3.1/25, hvrstatistics is replaced with Hvrstats.

Synopsis

hvrstatistics [-options]... [hubdb]

Description

hvrstatistics displays the statistics from HVR scheduler logfiles. The first argument hubdb specifies the connection to the hub database. For more information about supported hub databases, see Calling HVR on the Command Line.

hvrstatistics cannot process files containing more than 12 months of data.

Options

This section describes the options available for command hvrstatistics.


Parameter

Description

-btime

Only lines after (begin) time. Argument must have one of the following formats YYYY-MM-DD HH:MI:SS or YYYY-MM-DDTHH:MM:SS+TZD or YYYY-MM-DDTHH:MM:SSZ.

-cchn

Only parse output for specific channel chn. Alternatively, a specific channel can be omitted using form -c!chn.

This option can be specified multiple times.

-etime

Only lines until (end) time. Argument must have one of the following formats YYYY-MM-DD HH:MI:SS or YYYY-MM-DDTHH:MM:SS+TZD or YYYY-MM-DDTHH:MM:SSZ.

-ffile

Parse scheduler log file file, instead of default $HVR_CONFIG/log/hubdb/hvr.out.

-gcol

Summarize totals grouped by col which can be either channel, location, job, table, year, month, day, hour, minute or second.

This option can be specified multiple times, which will subdivide the results by each column. Additionally, a reasonable subdivision of time-based columns can be specified, e.g.: -s "10 minutes" or -s "6 hours"

-i

Incremental. Only lines added since previous run of hvrstatistics. The position of the last run is stored in file $HVR_CONFIG/files/hvrstatistics.offset.

-Iname

Incremental with variable status file. Only lines added since previous run of hvrstatistics. The position of the last run is stored in file $HVR_CONFIG/files/hvrstatistics_name.offset.

-lloc

Only parse output for specific location loc. Alternatively, a specific location can be omitted using form -l!loc.

This option can be specified multiple times.

-r

Resilient. Do not show log file output lines which cannot be matched.

-ssep

Print parsed output in CSV-matrix with field separator sep. This allows the input to be imported into a spreadsheet.

-Scol

Summarize totals grouped by col which can be either channel, location, job, table, year, month, day, hour, minute or second.

This option can be specified multiple times, which will cause the same data to be repeated in multiple blocks, but with each block divided by a different column.

-v

Verbose trace messages.

For list of all statistics metrics, see Metrics for Statistics.

Examples

HVR Statistics can be run from inside the HVR GUI, or it can be run on the command line. The following screenshot shows an example of the HVR Statistics inside the GUI.

On the command line, to count total rows replicated for each location and table, use the following:

hvrstatistics -g location -g table myhub

Sample output:

Location cen
  Table order
     Captured rows           :     25
  Table product
     Captured rows           :    100
  Capture cycles             :      6
  Routed bytes               :  12053
Location dec01
  Table order
     Integrated updates      :     25
     Integrated changes      :     25
  Table product
     Integrated updates      :    100
     Integrated changes      :    100
  Integrate cycles           :      7
  Integrate transactions     :      4


To create a CSV file with the same data use option -s as follows:

hvrstatistics -g location -g table -s"," myhub > stats.csv


If this CSV file was imported into a spreadsheet (e.g. Excel) it would look this:

Location

Table

Capture cycles

Captured rows

Routed bytes

Integrate cycles

Integrate transactions

Integrated updates

Integrated changes

cen

order

25

cen

product

100

cen

6

12053

decen

order

25

25

decen

product

100

100

decen

7

4

Files

HVR_CONFIG







files








hvrstatistics.offset





State file for incremental statistics (option -i).