Spaces
Apps
Templates
Create
HVR Knowledge Base
Overview
Apps
draw.io Diagrams
Space shortcuts
How-to articles (2)
Pages
Expert Notes
•
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
Error Messages
•
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 Hamblin
Version comment
Like
{"serverDuration": 24, "requestCorrelationId": "6e64ae4a3572e441"}