HVR Knowledge Base

Apps

draw.io Diagrams

Space shortcuts

How-to articles (2)

Best Practice for Monitoring and Managing HVR Remote Listener Processes

Can HVR agents use an environment variable in their /Path parameter?

How can we monitor replication latency?

How does HVR deal with non-logged unrecoverable operations (like direct-path inserts (insert /*+ APPEND */) above the HWM into "NOLOGGING" tables)?

How much network bandwidth will HVR consume?

How much system resources will HVR consume?

How to Configure HVR Services for High Availability in an Oracle Cluster

How to Convert Datatypes or Substitute Column values With Expressions?

How to resolved Ingres date to/from Oracle/SQL Server dates that have values that differ by a number of hours off

How to Use a /RefreshCondition help to join 2 tables (or more).

How to use Soft Delete function to keep track of deleted rows?

HVR High Availability Replication on Amazon Web Services

HVR HUB - Sizing and Availability

HVR Initialize (formerly HVR Load) - what options to use and when

If an HVR Process Stops for Some Reason How Can We Alert This to Ourselves?

Implement Type 2 Slowly Changing Dimension (SCD) with additional Capture Time column

Integration error even after performing manual refresh. What can be the cause?

Is it best practice to have a dedicated server for each target or is it possible to have multiple Agents sitting on a single server

Primary Key, Replication Key and Distribution Key for HVR

Scripts to check Oracle Database for Log-based Capture

The $HVR CONFIG directory - is this just for log files? How much disk space is needed?

What could be the cause of Integration errors?

What does HVR Online Refresh do?

What happens when the Capture or Integrate process is stopped for any reason, will the replication process catch up once it has been restarted? catch up once it has been restarted?

What is the best strategy to have single capture and have a regular target table and a timekey table for every captured table

What will happen if the source database has a very high log generation?

Which server do I choose for the HVR HUB installation?

Why does the refresh or compare job file get deleted from the folder $HVR_CONFIG_job ?

Workaround Redshift Reserve Words and Permissions

Why we need distributor database (for Sqlserver) for HVR?

Why use an agent installation

Why does the publication on<TestDB> require the snapshot agent to run every hour? This creates GB’s of unused files. The log reader agent is used both by the HVR publication db and the publication team. This is logical as there can be only one log reader

Why does hvrmaint alert notify about a channel that does not have latency?

What is Difference Between HVR Job States, PENDING and UNSUSPEND in the Scheduler?

Why does HVR's log based capture need SQLServer's Replication Components?

Why does HVR kill capture & integrate agents when suspending a job

While adding tables to channel - Is it required to specify schema name in the hvradapt command even when TableProperties action is defined to point to non-dbo schema?

Which indexes_constraints are temporarily dropped_disabled during HVR refresh?

When we connect to a RAC source with a SCAN name – how do we get the exact node name?

When the Scheduler is set to archive file for hvr.out, where does it go?

When does HVR use temp files, where do they go and how big are they?

What is the HVR hub?

What is the default unit (bytes, Kb, Mb, GB) considered when no suffix is provided for the value in HVR_SORT_BYTE_LIMIT?

What are the performance Implications of enabling the Integrate action option /Resilient when doing continuous integration?

What are Orphans (HVR)?

Using HVR_THROW_WARN

What are ".cache" files in the HVR router directory?

Troubleshoot missing data

Table compare reports identical when data is not identical with Oracle source(172 chars) replicating to Postgres (50 chars).

Scheduler was running but now hvr services started than stops. What is the issue?

A method to create multiple integrate jobs in the same channel for parallelism

SQL Server to SQL Server, Refresh Operation Causes Primary Key Constraint Violations

SQL Server Log-based Сapture Options

Can HVR SQL statements be traced?

Recovery of the hvrstats scheduled job after loss or accidentally deleting from HVR hub and the repository tables remain intact.

Oracle RAC throws an error message for VIP and not the physical address on the machine when hvr agent is not running on it.

Recommended command to kill hvrscheduler in linux hub

Is the SQL Server distribution database required by HVR for log-based Capture?

Can hvr_op be used in expression where a calculation is performed?

Instructions to delete a manually created control file that does not have expiration time

Capture job does not see an update statement in SQL Server database

Capture job seems to get suspended by online refresh job, will I lose transactions?

DB2i binary columns (CCSID encoded) to MSSQL varchar

Do the existing CDC tables and articles get dropped in SQL Server when HVR initialize is done?

Does HVR change grants and privilege on the tables while doing refresh with options drop and recreate selected?

Does HVR replicate case-sensitive tables or column names?

Does HVR support capture from VSAM and ISAM in Mainframes

Filter all deletes from being propagated to integrate location

How can companies within one org view all the tickets created by the users in same account?

How can HVR row-wise compare say a table is identical, but bulk_checksum say it's different?

hvrtopology script to display HVR version information

HVR catalog table HVR_STIN<Channel Name>_<Target Location> contains different values for column TRAILER_CAP_LOC and LEADER_CAP_LOC when there is only one location in the channel

HVR: Steps to take when database user's password changes for source and Target location

HVR different behavior when using (Db)Integrate /Dbproc and refresh

HVR GUI Tips and Tricks

HVR provided access to the product download site but I never received the email notification

HVR takes too much CPU time on the source machine

HVR SQL Server Requirements for Capturing from Always On AG Target

HVR Statistics from the GUI page doesn't load on Windows

Configuring HVR Capture to co-exist with native MS SQL Server Native Replication or native MS Change Data Capture (CDC) tables

Audit Tables and Slowly Changing Dimensions

Querying the HVR repository table HVR_STATS

Securing HVR using SSL/TLS

Remote SSH tunneling for HVR

CVE-2021-44228 log4j Vulnerability for HVR

PostgreSQL ssl connect

How-To Articles

HVR Documentation

How-to articles (2)

HVR Knowledge Base
Expert Notes

restrictions.empty

Audit Tables and Slowly Changing Dimensions

Created by Samjad Kollanandy

Last updated: Dec 08, 2020 by Sara HamblinVersion comment

{"serverDuration": 24, "requestCorrelationId": "6e64ae4a3572e441"}