Question
Can I view the SQL statements that HVR is running with some type of tracing enabled?
Environment
Local Data Processing
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>