MX Release 3.2 (H06.25+, J06.14+)

• 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.

Collecting Server Statistics

Configuring Statistics Collection

You must use a user ID that has OPERATOR permission to perform management tasks.

1. Configure an alternate collector, using the EMSACOLL command. For details on the EMSACOLL

command, see the EMS Manual.

2. Start the alternate collector before starting the MX connectivity service.

3. Use the MXOAS command to start the MX connectivity service, and pass the name of the

alternate collector to the server in the -RMC parameter. See “Starting Statistics Collection”

(page 40).

Starting Statistics Collection

You must use a user ID that has OPERATOR permission to perform management tasks.

1. Using NSM/web, expand Data Source Configurations.

2. Click a data source name.

3. Click on the Resource Statistics tab.

4. Check one or more statistics options.

5. Click Apply.

Statistics collection begins for all available servers and connected servers.

For more information about a screen, click Help.

Stopping Statistics Collection

You must use a user ID that has OPERATOR permission to perform management tasks.

1. Using NSM/web, click Data Source Configurations.

2. Click on a data source name.

3. Click the Resource Statistics tab.

40 Starting, Configuring, and Managing MXCS