Configuring access to IMS databases

IBM Data Virtualization Manager for z/OS provides seamless, real-time controlled access to IMS database data. It allows ODBC, JDBC, Data Virtualization Manager client, and web clients to access IMS database data in a relational model by using simple SQL-based queries. This interface can be used with traditional client/server applications, desktop productivity tools that use ODBC, JDBC, and two-tier and three-tier web implementations. Using the interface, applications can use standard ODBC or JDBC facilities to make SQL requests directly to an IMS database. The result is a relational result set with no host programming required.

For a key field that allows using either an index (HIDAM) or a randomizer (HDAM), IBM Data Virtualization Manager for z/OS uses DBCTL. For unkeyed fields, IBM Data Virtualization Manager for z/OS uses IMS Direct as both IMS Direct and IMS DBCTL need to scan the data.