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