The VSAM configuration parameters, accessed from the Connectivity Map, are organized into the following sections:
The VSAM Outbound Adapter Properties include outbound parameters used by the external database.
Table 1–28 Outbound Adapter — JDBC Connector Settings
Name |
Description |
Required Value |
---|---|---|
Description |
VSAM Connection Pool Datasource. |
A valid string. |
ClassName |
Displays the Java class in the JDBC driver that is used to implement the ConnectionPoolDataSource interface. |
A valid class name. The default is: com.cac.jdbc.ConnectionPoolDataSource Note – Do not change this value. |
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 |