Hvrrouterconsolidate
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 db2, db2i, ingres, mysql, oracle, postgresql, sqlserver, 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. |