MX Release 3.2.1 (H06.26+, J06.15+)

TotalFetches:4 TotalCloses:3 TotalExecDirects:3

TotalErrors:1 TotalWarnings:2

• SQL Statement — The first message contains information for the SQL Statement option and

shows that an SQL SELECT statement was prepared for execution. Note that no detailed

statistics are given for that statement - just the query itself, and the time of execution.

• SQLPrepare — The second message contains information for the SQLPrepare option and

shows that an SQL SELECT statement was prepared at 9:27. This time matches the time for

the SELECT statement returned by SQL Statement. This entry also contains the SQLPrepare

statistics for that SELECT statement. Note that to obtain complete statistics information for SQL

statements, you must select the SQL Statement option and the option for each specific statement

for which you want statistics.

• Session Summary — The third message contains information for the Session Summary option.

This message shows statistics for the entire user session, from client connect to client disconnect.

For detailed definitions of statistics that are collected, see the online help for NSM/web.

For information on configuring statistics collection, see “Configuring Statistics Collection” (page 40).

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

F: Data value for the second parameter value

The list of available data tags are:

38 Starting, Configuring, and Managing MXCS