Problem Summary
Can I view the SQL statements that HVR is running with some type of tracing enabled?
Answer
HVR’s SQL statements can be traced by setting the environment variable HVR_SQL_TRACE. It can have 3 values: 1 (low), 2 (medium) and 3 (high) reflecting the amount of tracing produced.
There are several ways to set the environment variable:
- Add an Environment action to the channel with /Name=HVR_SQL_TRACE and /Value=value. After this, an HVR Initialize step is necessary to regenerate the job scripts (hvrload -oj option).
- Add the environment variable to the (x)inetd configuration on Linux / Unix or supply it to the hvrremotelistener service using a -E HVR_SQL_TRACE option during the service creation on Windows.
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:
$ hvr -EHVR_EXPORT=HVR_SQL_TRACE=1 -EHVR_SQL_TRACE=1 $HVR_CONFIG/job/<hub>/<chn>/<chn>-cap-<loc>