Configuring access to native VSAM
No modifications are required to configure the SQL interface for native VSAM. However, you should verify that the server has access to native VSAM. Optionally, you can control the data buffer (BUFND) and the index buffer (BUFNI) values for VSAM files either globally or for individual requests.
Before you begin
The server must already be installed.
About this task
The SQL interface for native VSAM provides seamless, real-time controlled access to native VSAM data. It allows ODBC, JDBC, and web clients to access native VSAM data in a relational model 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 native VSAM. The result is a relational result set, with no host programming required.
You can use a post-read exit routine in the member AVZGNASB in the hlq.SAVZSAMP module to improve performance by limiting the number of records processed by IBM Data Virtualization Manager for z/OS.