You can create Informix databases with or without logging enabled. If logging is disabled, then Non-Transactional mode must be used. Because data logs are not retained during Non-Transactional execution of SQL calls, data recovery is not possible during accidental or unscheduled shut-down of the database server.
Disabled logging also prevents transactions—enclosed in BEGIN-Tran and END-Tran statements—from occurring. This means that Non-Transactional mode cannot be used in XA (two-phase commit) transactions.
The Outbound non-Transactional Adapter Properties listed in the following table include outbound parameters used by the external database.
Table 1–15 Outbound Informix non-Transactional Adapter Connectivity Map Properties
Name |
Description |
Required Value |
---|---|---|
Description |
Enter a description for the database. |
A valid string. The default is INFORMIX non-Transactional Connection Pool Datasource. |
ClassName |
Specifies the Java class in the JDBC driver that is used to implement the non-Transactional ConnectionPoolDataSource interface. |
A valid class name. The default is com.SeeBeyond.informix.jdbcx.informix.InformixDataSource. |