> -----Original Message----- > From: IBM Mainframe Discussion List > [mailto:[EMAIL PROTECTED] On Behalf Of Brad Carson > Sent: Monday, February 26, 2007 10:22 AM > To: [email protected] > Subject: VSAM Transparency, Transactional VSAM Services, or IAM > > > Everyone, >
<snip> > > 1. DFHSMStvs - Transactional VSAM services - Would need to setup VSAM > record level sharing and all CF logstreams. Also require JCL changes > and coding changes for committing a LUW. > > 2. VSAM transparency - move data into DB2 and setup proper mapping to > DB2 tables. Again have some JCL changes and coding for commits. > > 3. IAM - Innovation access method - Convert VSAM files to IAM files. > > Our long term goal is to perform a proper DB2 conversion but that is > years (and $$) away, or so I'm told by the applications people. > > What are your thoughts on this issue? > Have any of you done this? > Are their other pit falls to look out for? > > Thanks for your time. > > > Brad S. Carson Brad, One option that you did not list, which we use, is SYSB from H&W Computing. Perhaps you considered it and decided against it. It generally "just works" (my kind of product). It does not require code changes. It does require JCL changes. It effectively "function ships" file I/O to the appropriate CICS region, as specified in the JCL. In any of the above cases, I have a philosophical objection. If you need to go to DB2, or some other RDMS, then "just do it" and don't "mess around". Yes, I do understand why management likes "interim" solution. But I've noticed that "interim" solutions often turn into "semi-permanent" solutions (hey, why bother? What we have now works. Why continue on to RDMS nirvana?). The "permanent" solution often ends up being a conversion off of the mainframe because it is easier to justify an entirely new solution than to "upgrade" a "old solution". Everybody knows that the synonyms for "old" are "bad", "junk", "obsolete", "not cost effective", "hard to sell", and so on. Everybody loves a "new" car. Except for those who love to rebuild the classics. -- John McKown Senior Systems Programmer HealthMarkets Keeping the Promise of Affordable Coverage Administrative Services Group Information Technology The information contained in this e-mail message may be privileged and/or confidential. It is for intended addressee(s) only. If you are not the intended recipient, you are hereby notified that any disclosure, reproduction, distribution or other use of this communication is strictly prohibited and could, in certain circumstances, be a criminal offense. If you have received this e-mail in error, please notify the sender by reply and delete this message without copying or disclosing it. ---------------------------------------------------------------------- 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
