SQL/MX Connectivity Service Manual for SQL/MX Release 3.2 (H06.25+, J06.14+)

For more information about a screen, click Help.
Using NSM/web, you can see the enabled or disabled status of traces on the Data Sources Status
tab.
Stopping Server Tracing
You must use a user ID that has OPERATOR permission to perform management tasks.
1. Do one of the following:
a. Using NSM/web, click MXCS Services.
b. Expand MXCS Services and click a service name.
2. Click the Data Source Status tab.
3. Clear the Tracing column for the data sources you want to stop tracing.
4. When finished, click Apply.
For more information about a screen, click Help.
Using NSM/web, you can see the enabled or disabled status of traces on the Data Sources Status
tab.
Viewing Trace Information
The EMS alternate collector collects the ODBC/MX server trace information and stores it in EMS
log, message 21034. For a list of data collected in a server trace, see “Server data collected:”
(page 46). See message “Trace Event Message Format” (page 48) or the message format.
Example Server Trace Log for the Connect Function
The following example shows the trace messages returned for the connect function. The first message,
regarding entering the connect function, shows the date and time of entry and contains the input
parameters. The second message, regarding exiting the connect function, shows the exit date and
time and contains the exit parameters.
01-09-25 15:31:00 \TEST.$Y8499 TANDEM.ODBCMX.G10 021034 ODBC/MX
Trace
Session ID: $YIJ:2:$Y8499:20019251531
Function: EnterConnect
Sequence Number: 0
UserDescType:2 DomainName:
UserName:super.super Datasource:TEST
Catalog:CAT Schema:SCH AccessMode:0
AutoCommit:1 IsolationLevel:2
RowSetSize:0 Component0:7 Major0:3
Minor0:51 Build0:65583 Component1:8
Major1:3 Minor1:0 Build1:0
DialogueId:1827180711
01-09-25 15:31:00 \TEST.$Y8499 TANDEM.ODBCMX.G10 021034 ODBC/MX
Trace:
Session ID: $YIJ:2:$Y8499:20019251531
Function: ExitConnect
Sequence Number: 0
ExceptionNr:0 ExceptionDetail:1879411928
Component0:260 Major0:2 Minor0:2
Build0:919 Component1:3 Major1:1 Minor1:0
Build1:0 Catalog:CAT Schema:SCH
Resource Statistics 47