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-19
Param Caching
Message Attribute:
STATEMENT:QueryParamValues
Sequence Number: 0/0
Message Info:
StatementId:SQL_CUR_MFC00000001
QueryId:MXID01223001061212175852220031727
000000000111SUPER.SUPER00_20_SQL_CUR_MFC00
000001 StatementType:SQL_SELECT_NON_UNIQUE
SQLValues:{ZACOAAKabcdefghi
CAcAGEA3wAwADEAMgAzADQANQA2ACA=AAHa123456
CAQADYANwA4AGEA3w==IAT01 12:23:34.987654
DAK1988-07-25NAE2333NAJ123456789NAM987654s,
. 12345}
Limitations of SQLValues
SQLValues have the following limitations:
•
Logs parameter value only for select query type.
•
Truncates the parameter value on exceeding 800 bytes.
•
Logs empty string SQLValues:{}when the total length of the query parameter
message exceeds 3.4 KB. The message length of three bytes reserves a byte for
data tag and other two bytes for parameter length. The total length of the query
parameter message is calculated for 'n' number of parameter value with ni
parameter length as:
If (n1 + 3) + (n2 + 3) + (n3 + 3) + (n4 + 3)... (Nn + 3) > 3400 , then
SQLValues:{}is logged.
11-08-19 17:16:31 \LLSW2.$Y0NN TANDEM.ODBCMX.G06 020007 A NonStop
Process Service error
Total Length of the Input Param values 3415 exceeded MAX length 3400 has
occurred.
Event Type: 1
Component Name: ODBC/MX Server
Object Reference: TCP:$ZTC0/33338:NonStopODBC
•
Logs an empty string SQLValues:{}for Insert, Update, or Delete query type.
Reading SQLValue
You can read the SQL query parameter value in either of the ways:
•
Start EMSDIST TYPE PRINTING with indent 0 and redirect the output to a file. A
sample java program is available as a downloadable sample, which you can
decode to obtain the actual data as per the data tag. HP recommends to start the
MXCS service on a different collector other than $0, and you can use the same
collector to start EMSDIST.
•
Start EMSDIST TYPE CONSUMER and read it using SPI. For more information,
see SPI Programmer Manual, and EMS manual.