On 27 Feb 2007 08:53:36 -0800, in bit.listserv.ibm-main you wrote: >If your long term goal really is DB2, then start now. Going through an >interim step simply makes the eventual conversion far more expensive. > >"If you can't afford to do it right the first time, then when will you >be able to afford to do it over?" > >But be aware that there may be political games being played here. The >opposition to DB2 has no intention of ever actually allowing the >conversion. They are just saying so to stall and to mislead upper >management.
The fun with ANY relational data base management system is that it requires more CPU and memory. It also requires careful planning because things like multi-record type files should be converted into separate tables, 1 for each record type. You need someone who understands database and the implications of how certain things are done. There are many benefits including making the data more easily available to end users but they require more than just loading the VSAM files as DB2 tables. > >My $0.02 >HTH and good luck. > > >-----Original Message----- >From: IBM Mainframe Discussion List [mailto:[EMAIL PROTECTED] >Behalf Of Brad Carson >Sent: Monday, February 26, 2007 10:22 AM >To: [email protected] >Subject: VSAM Transparency, Transactional VSAM Services, or IAM > >Everyone, > >Management here has decided that we need to review different products >that would allow us the bring our CICS regions up while nightly >processing is still running. As a member of a management assigned SWAT >team to investigate products, our team has decided to focus on the >following three products that would allow concurrent VSAM update from >batch and CICS: > >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 >Manager z/Series Technical Support >Enterprise Systems >Laboratory Corporation of America >(336) 436-8294 > ---------------------------------------------------------------------- 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
