You can create VSAM 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 parameters used by the external database.
Table 1–29 Outbound VSAM non-Transactional adapter Connectivity Map Properties
Name |
Description |
Required Value |
---|---|---|
Description |
Enter a description for the database. |
A valid string. The default is VSAM 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.cac.jdbc.ConnectionPoolDataSource |