 |
Access VSAM data from remote systems |
One of the most common data access method in VSE is VSE/VSAM (Virtual Storage Access Method). VSAM data has its own format and structure which is foreign for other systems.
An actual business need is the integration of VSAM data into distributed processes. Therefore, emphasis was placed on enabling real time access to VSAM data via modern and standard technologies and methods.
|
Overview |
For real time access to VSAM data from a remote platform the Java-based Connector was developed. It is build of 2 components:
The real time access to the VSE/VSAM data can be implemented in three ways:
Access to the VSAM dataset can be done directly from the VSE Connector Server, or via CICS, if the VSAM dataset is already opened in CICS.
To access VSAM data from a remote site, the structure of the records must be defined. This process is called 'mapping' and can be done with the VSE Maptool, VSE Navigator or IDCAMS command RECMAP. The VSE Maptool allows to import the mapping directly from your COBOL pr PL/I copybooks. Once the mapping is defined, access to the VSAM dataset can be done using the VSAM Java Beans, or via the VSAM JDBC Driver using SQL.
Real time Access to VSE/VSAM:
|
Benefits |
Having real time access to VSAM data, distributed processes can take advantage and faster decisions can be taken, based on the data:
-
Real time access - access the data when you need them a,s you need them.
-
Translation between the EBCDIC format (VSE) to ASCII format on the remote platform is done.
-
Standard, relational interface to VSAM data (JDBC) enables standard programs to integrate VSAM data in their business logic.
|
Software requirements |
The following software requirements must be meet in order to implement this solution:
-
VSE/ESA 2.5 or later
-
-
VSE Connector Server running on VSE
-
Linux, Windows, AIX, Unix on remote system
-
-
Note: WebSphere is NOT required to run the VSE Java-based connector. However, the connector can be deployed into WebSphere as an Resource Adapter or as an JDBC Provider, if you wish to access VSAM from a web application.
|
How to get started |
To get started, following Steps need to be done:
-
Start VSE connector server on VSE (release STARTVCS from the reader queue or create it from ICCF library 59, skeleton SKVCSSTJ).
-
-
-
Create the mapping information to define the VSAM record structure (using VSE Maptool , VSE Navigator or VSE IDCAMS Command RECMAP).
-
Use the different ways (JDBC, Java Beans, Scripts) to access your data.
Note: The VSE connector client contains descriptions and samples for accessing VSAM data.
|
Additional information |
Additional information for this solution scenario can be found:
| 
