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. Note that when setting the trace options, the only item that needs to be enabled is
mftrace.level.mf.esxa. That is, the sub-properties are
not used for tracing this component.
- ESMSSQL
-
| 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
|
Begin DTC Transaction
|
| INFO
|
6
|
Enlist in DTC Transaction
|
| INFO
|
7
|
DTC Commit
|
| INFO
|
8
|
DTC Rollback
|
| INFO
|
9
|
SQL DISCONNECT
|
| INFO
|
10
|
End DTC Transaction
|
- ESODBCXA
-
| 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
|
SQL RESET CONNECTION
|
- ESDB2XA
-
| Event Level
|
Event ID
|
Event Description
|
| INFO
|
41
|
xa_start()
|
| INFO
|
42
|
xa_end()
|
| INFO
|
43
|
xa_open() - database connection
|
| 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
|
- ESDB2OPC
-
| Event Level
|
Event ID
|
Event Description
|
| 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
|
- ESORAXA
-
| Event Level
|
Event ID
|
Event Description
|
| INFO
|
81
|
xa_start()
|
| INFO
|
82
|
xa_end()
|
| INFO
|
83
|
xa_open() - database connection
|
| 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
|
- ESORAOPC
-
| Event Level
|
Event ID
|
Event Description
|
| 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
|
