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