I read your response about trying to access a Microsoft SQL server database from the mainframe. I am not a CICS programmer and I have no experience with SQL server. However, the one thing that struck me is that you did not recommend to the person asking that he/she consider either: 1. Moving the data to a DB2 data base on practically any platform, or 2. Moving the data to DB2 on the mainframe, leaving it accessible to users on other platforms. I cannot guess whether either of those choices is feasible but they probably should be considered. (We all know which platform has the best record for availability.)In my experience, businesses sometimes let its user community run wild developing "mini-apps" and then task their IT pros with integrating the "mini-app" with the enterprise apps. Trying to span all possible platforms and use their data does not lend itself to very efficient integration. So, where's the question in this? I'll ask it this way, "Why not move the data to the mainframe?"
An interesting comment. Coming from the background that I undoubtedly do, I think that data should always be accessible from any platform. I know that the Java community has adopted this idea from the enhancements made to JDBC 2.0 (and CICS can use JDBC function to talk to DB2 or any other data provider at that provided, a suitable JDBC driver is supplied). However, I admit a bias towards DB2 on a mainframe on a RAH basis but readers must make up their own minds and it's not my place to interefere!
CICS Technical Strategist -- CICS expert at Search390.com
Editor's note: Do you agree with this expert's response? If you have more to share, post it in one of our .VO7aaqqaAFk.0@/search390>discussion forums.
Dig Deeper on IBM system z and mainframe systems
Related Q&A from Robert Crawford
For better mainframe capacity planning, how do I convert CPU hours to MIPS? And is there a way to calculate the relationship between MIPS and MSUs? Continue Reading
I have two years of experience in mainframe technology, currently working as a mainframe developer. I want to change to Java technology. Continue Reading
I want to replicate DB2 from the mainframe to an AIX box since it's cheaper and the copy can be used for testing. Is this possible? Continue Reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.