Can HVR SQL Statements be Traced?

Question

Can I view the SQL statements that HVR is running with some type of tracing enabled?

Environment

HVR

Answer

HVR's SQL statements can be traced by setting the environment variable HVR_SQL_TRACE. The values accepted for this environment variable are:

• 1 - low amount of tracing is produced
• 2 - medium amount of tracing is produced
• 3 - high amount of tracing is produced

There are multiple ways/methods to set the environment variable:

Method 1
Define an Environment action for the channel with /Name=HVR_SQL_TRACE and /Value=value. After defining this action, HVR Initialize must be performed to regenerate the job scripts (hvrinit -oj option).

Method 2
Add the environment variable to the xinetd configuration on Linux/Unix or supply it to the hvrremotelistener service using the -E HVR_SQL_TRACE option during the service creation on Windows.

Method 3
If you want to use this tracing while running replication jobs on the command line, it can be supplied as an -E option to the HVR executable: plaintext hvr -EHVR_EXPORT=HVR_SQL_TRACE=1 -EHVR_SQL_TRACE=1 $HVR_CONFIG/job/hub/channel/channel<strong>-cap-</strong>loc