In my answer I'm assuming the VSAM is on z/OS rather than z/VSE. Here are some IBM options, not necessarily in order:
1. IBM InfoSphere Classic Federation Server for z/OS http://www.ibm.com/software/data/infosphere/classic-federation-server-z/ Classic Federation Server provides both JDBC and ODBC access to VSAM (and other z/OS-based data stores, both IBM and non-IBM). It installs directly on z/OS, so there are no extra boxes to install, manage, backup, secure, or otherwise worry about. Just connect directly from whatever reporting tool, desktop tool, etc. you want to use. (Including Cognos for System z.) 2. IBM Scalable Architecture for Financial Reporting (SAFR) http://www.ibm.com/systems/z/advantages/dataserving/solutions/safr/ Despite the "F" in SAFR, it doesn't have to be financial information. SAFR aggregates reporting requests and screams through VSAM and other data stores (including tape archives!) on z/OS once, answering scores or hundreds of report requirements. If you're not just worried about access but also want business answers, I'd look at SAFR. (Possibly in combination with Classic Federation Server.) 3. CICS VSAM Transparency (plus DB2 for z/OS) http://www.ibm.com/software/htp/cics/vt/ CICS VT allows you to move all your data from VSAM into DB2 without changing any of your application code. Whereupon you can directly access DB2 from your favorite reporting tool(s), desktop tool(s), etc. 4. As a side note, if you were wondering about writing Java code that accesses VSAM, you can do that directly on z/OS at no additional charge using the Java SDK for z/OS (and specifically the JRIO methods, which are part of JZOS). - - - - - Timothy Sipples IBM Consulting Enterprise Software Architect Based in Tokyo, Serving IBM Japan / Asia-Pacific E-Mail: [email protected] ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
