SQL/MX Connectivity Service Manual for SQL/MX Release 3.1 (H06.23+, J06.12+)

Starting, Configuring, and Managing MXCS
HP NonStop SQL/MX Connectivity Service Manual for SQL/MX Release 3.1—663856-001
3-17
Param Caching
For information on configuring statistics collection, see Configuring Statistics Collection
on page 3-20
Param Caching
Param Caching is an enhancement of resource statistics which allows logging SQL
query parameter value as part of resource statistics information during the start of the
SQL Execute operation.
Configuring SQLValues
To configure SQLValues:
1. Set SQLExecuteStat in Data Source to ON.
2. In Data Source of type set, add the SELECT_INPUT_PARAM_LOG environment.
The SELECT_INPUT_PARAM_LOG takes either TRUE or FALSE as values. By
default, this attribute is not enabled.
CS>add evar $XYZ."TDM_Default_DataSource".SELECT_INPUT_PARAM_LOG, type set,
value 'TRUE';
-- ADD EVAR $XYZ.TDM_Default_DataSource.SELECT_INPUT_PARAM_LOG Successful
CS>add evar $XYZ."TDM_Default_DataSource".SELECT_INPUT_PARAM_LOG, type set,
value 'FALSE';
-- ADD EVAR $XYZ.TDM_Default_DataSource.SELECT_INPUT_PARAM_LOG Successful
3. To set the SELECT_INPUT_PARAM_LOG attribute using NSM/web, set the
SELECT_INPUT_PARAM_LOG attribute to TRUE in NSM/web SET tab for data
source.
Logging Format for SQL Values
The logging format for two arbitrary SQL Query parameter values is:
SQLValues:{TXABCDEF}
Where:
T: 'Z', one byte indicates that the value is a sequence of Tag-Length-Value (TLV)
X: A total length of three bytes encoded in Base64
TLV Sequence:
A: One byte indicates the data tag for the first parameter value
B: Two bytes for the data length encoded in Base64
C: Data value for the first parameter value
D: One byte indicates the data tag for the second parameter value
E: Two bytes for data length encoded in Base64