A friend of mine develops applications using COBOL and DB2. To save money,
management at his company is considering converting DB2 to Oracle. My friend is
neither for or against the idea, but has some concerns about how this might
affect him. I know nothing about Oracle or z/Linux, so I thought I'd pass his
questions on and see if anyone on this list might be able to help him:
1) Has anyone ever gone through this, and if so did it actually save money?
2) Would z/Linux have to be used for application development, and if so how
steep is the learning curve for someone who is used to using ISPF?
3) Do existing COBOL/DB2 programs need to be re-compiled; e.g. do any of the
SQL statements have to be changed?
4) Would his personal JCL and Spufi libraries need to be converted? For
example, if he has JCL that unloads records from a DB2 table, would he have to
modify it to extract the same records from an Oracle table?
5) If conversion is required (whether it be for SQL in COBOL or for Spufi
libraries or JCL libraries etc), are there any vendor tools that can help with
the conversion?
6) Would different vendor tools be required for things like editing Oracle
tables versus DB2 tables, and if so do most of the major vendors have tools
available that are comparable to their DB2 tools?
7) Any there any tips/tricks/gotchas that anyone might want to pass along?
Thanks in advance,
Dave Salt
SimpList(tm) - try it; you'll get it!
http://www.mackinney.com/products/SIM/simplist.htm
_________________________________________________________________
Attention all humans. We are your photos. Free us.
http://go.microsoft.com/?linkid=9666046
----------------------------------------------------------------------
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
