Hvrrouterconsolidate

Last updated on Dec 23, 2020

Contents

Name

Hvrrouterconsolidate - Merge small tx files in router directory.

Synopsis

hvrrouterconsolidate [-options]... hubdb [chn]

Description

If capture jobs run without integrate jobs then many transaction files (matching *.tx_integloc) will accumulate in $HVR_CONFIG/router/hub/chn. These files can cause extra CPU load in other jobs. Small transaction files will also accumulate in $HVR_CONFIG/jnl/hub/chn if action Integrate /JournalRouterFiles is defined. Command hvrrouterconsolidate will merge many of these smaller files together.

Consolidation is unsafe while an integrate job is running; for this reason hvrrouterconsolidate will only consolidate router files for integrate jobs which have scheduler job_state as SUSPEND or FAILED or PENDING (unless option -f supplied).

If the channel name is not supplied then router consolidation will be done for all channels.

Note that consolidation will not merge all small files; the algorithm instead processes files in batches of 10, 100, 1000 etc...

The argument hubdb specifies the connection to the hub database. For more information about supported hub databases and the syntax for using this argument, see Calling HVR on the Command Line.

Options

This section describes the options available for command hvrrouterconsolidate.

Parameter

Description

-bbase

Base/radix. Otherwise 10 files are grouped.

-f

Consolidate files for all jobs, not just ones where job_state is inactive. Only used when the scheduler is not running.

-j

Journals only, ignore /router directory.

-hclass

Location class of the hub database. Valid values for class are db2db2iingresmysqloraclepostgresqlsqlserver, or teradata. For more information, see Calling HVR on the Command Line.

-llocscope

Specific locations only. Value can have form loc or !loc

-Nnrows

Max num rows. Larger files won't be joined.

-p

Only print OS commands, no execution.

-r

Router files only, ignore /jnl directory.

-sfsize

No consolidate if new file would exceed fsize.

Default is 20Mb.

-udbuser

Database user name.