This component provides diagnostics on the various SQL operations invoked by the switch modules when executing SQL applications
that have been deployed under Enterprise Server.
The following table lists the properties of the
mf.esxa component, and shows the event information that can be included in the trace for each property. Although you can create your
own trace files, Micro Focus recommends that you use the configuration files supplied with the switch module source files
as the basis for tracing.
- ALL
- Enables or disables all of the other properties.
- MSSQL
- SQL Server switch module events:
| Event Level
|
Event ID
|
Event Description
|
| INFO
|
1
|
Initialization of module
|
| ERROR
|
2
|
Incorrect XA open string provided
|
| INFO
|
3
|
SQL CONNECT
|
| INFO
|
4
|
Microsoft Distributed Transaction Coordinator (DTC) initialization
|
| INFO
|
5
|
XA_START
|
| INFO
|
6
|
Enlist in DTC transaction
|
| INFO
|
7
|
XA_COMMIT
|
| INFO
|
8
|
XA_ROLLBACK
|
| INFO
|
9
|
XA_CLOSE
|
| INFO
|
10
|
XA_END
|
| INFO
|
11
|
De-enlist from DTC transaction
|
| INFO
|
12
|
XA_OPEN
|
| INFO
|
13
|
XA_CLOSE
|
| INFO
|
14
|
XA_RECOVER
|
| INFO
|
15
|
XA_FORGET
|
| INFO
|
16
|
XA_COMPLETE
|
| INFO
|
17
|
Register an XA data source with the current transaction
|
| INFO
|
18
|
XA_PREPARE
|
- ODBC
- Generic ODBC switch module events:
| Event Level
|
Event ID
|
Event Description
|
| INFO
|
21
|
BEGIN TRANSACTION
|
| INFO
|
22
|
SQL COMMIT
|
| INFO
|
23
|
SQL ROLLBACK
|
| INFO
|
24
|
SQL DISCONNECT
|
| INFO
|
26
|
Initialization of module
|
| ERROR
|
27
|
Incorrect XA Open String
|
| INFO
|
28
|
SQL CONNECT
|
| INFO
|
29
|
SQL SYNCPOINT
|
| INFO
|
30
|
RESET CONNECTION
|
| INFO
|
31
|
EXECUTE AS
|
| INFO
|
32
|
REVERT
|
| INFO
|
33
|
SET XA TRIGGER (for dynamic registration)
|
| INFO
|
34
|
SYNC ROLLBACK
|
| INFO
|
35
|
RESET HOST CONNECTION
|
| INFO
|
36
|
SET CURRENT CONNECTION
|
| INFO
|
37
|
SET ISOLATION LEVEL
|
- DB2
- DB2 switch module events:
| Event Level
|
Event ID
|
Event Description
|
| INFO
|
41
|
XA_START
|
| INFO
|
42
|
XA_END
|
| INFO
|
43
|
XA_OPEN
|
| INFO
|
44
|
XA_CLOSE
|
| INFO
|
45
|
XA_COMMIT
|
| INFO
|
46
|
XA_ROLLBACK
|
| INFO
|
47
|
XA_PREPARE
|
| INFO
|
48
|
Call to IBM DB2 LUW XA initialization
|
| INFO
|
49
|
Register an XA data source with the current transaction
|
| INFO
|
51
|
SET ISOLATION LEVEL
|
| ERROR
|
61
|
Incorrect XA Open String
|
| INFO
|
62
|
SQL CONNECT
|
| INFO
|
63
|
SQL COMMIT
|
| INFO
|
64
|
SQL ROLLBACK
|
| INFO
|
65
|
SQL DISCONNECT
|
| INFO
|
66
|
Before SQL CONNECT
|
| INFO
|
67
|
Before SQL COMMIT
|
| INFO
|
68
|
Before SQL ROLLBACK
|
| INFO
|
69
|
Before SQL DISCONNECT
|
- ORA
- Oracle switch module events:
| Event Level
|
Event ID
|
Event Description
|
| INFO
|
81
|
XA_START
|
| INFO
|
82
|
XA_END
|
| INFO
|
83
|
XA_OPEN
|
| INFO
|
84
|
XA_CLOSE
|
| INFO
|
85
|
XA_COMMIT
|
| INFO
|
86
|
XA_ROLLBACK
|
| INFO
|
87
|
XA_PREPARE
|
| INFO
|
88
|
Load of Enterprise Server callback module
|
| INFO
|
89
|
Load of Oracle client-side support
|
| INFO
|
90
|
Call to Oracle XA initialization entry point
|
| INFO
|
91
|
XA_RECOVER
|
| INFO
|
92
|
Register an XA Data Source with the current transaction
|
| INFO
|
93
|
SET ISOLATION LEVEL
|
| ERROR
|
101
|
Incorrect XA Open String
|
| INFO
|
102
|
SQL CONNECT
|
| INFO
|
103
|
SQL COMMIT
|
| INFO
|
104
|
SQL ROLLBACK
|
| INFO
|
105
|
SQL DISCONNECT
|
| INFO
|
106
|
Before SQL CONNECT
|
| INFO
|
107
|
Before SQL COMMIT
|
| INFO
|
108
|
Before SQL ROLLBACK
|
| INFO
|
109
|
Before SQL DISCONNECT
|
- XDB
- XDB switch module events:
| Event Level
|
Event ID
|
Event Description
|
| INFO
|
160
|
XA_START
|
| INFO
|
161
|
XA_END
|
| INFO
|
162
|
XA_OPEN
|
| INFO
|
163
|
XA_CLOSE
|
| INFO
|
164
|
XA_COMMIT
|
| INFO
|
165
|
XA_ROLLBACK
|
| INFO
|
166
|
XA_PREPARE
|
| INFO
|
167
|
Load XDB functions
|
| INFO
|
168
|
RESET CONNECTION
|
- XDBOPC
- XDB one-phase switch module events:
| Event Level
|
Event ID
|
Event Description
|
| INFO
|
180
|
CONNECT
|
| INFO
|
181
|
COMMIT
|
| INFO
|
182
|
ROLLBACK
|
| INFO
|
183
|
CLOSE
|
| INFO
|
184
|
Before CONNECT
|
| INFO
|
185
|
Before COMMIT
|
| INFO
|
186
|
Before ROLLBACK
|
| INFO
|
187
|
Before CLOSE
|
- PGSQL
- PostgreSQL switch module events:
| Event Level
|
Event ID
|
Event Description
|
| INFO
|
201
|
Initialization of module
|
| ERROR
|
202
|
Incorrect XA open string provided
|
| INFO
|
203
|
SQL CONNECT
|
| INFO
|
204
|
Microsoft Distributed Transaction Coordinator (DTC) initialization
|
| INFO
|
205
|
XA_START
|
| INFO
|
206
|
Enlist in DTC transaction
|
| INFO
|
207
|
XA_COMMIT
|
| INFO
|
208
|
XA_ROLLBACK
|
| INFO
|
209
|
XA_CLOSE
|
| INFO
|
210
|
XA_END
|
| INFO
|
211
|
De-enlist from DTC transaction
|
| INFO
|
212
|
XA_OPEN
|
| INFO
|
213
|
XA_CLOSE
|
| INFO
|
214
|
XA_RECOVER
|
| INFO
|
215
|
XA_FORGET
|
| INFO
|
216
|
XA_COMPLETE
|
| INFO
|
217
|
Register an XA data source with the current transaction
|
| INFO
|
218
|
XA_PREPARE
|