mf.esxa Properties

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