|
View previous topic :: View next topic
|
| Author |
Message |
Susan Talbot
New User
Joined: 17 Dec 2010
Posts: 36
Location: KY
|
|
|
|
I want to query an IMS database from DB2. Does anyone know if this is possible on these old versions?
If not, is there a way to get at IMS data from outside the mainframe?
No version upgrade is on the horizon unfortunately. |
|
| Back to top |
|
 |
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007
Posts: 10873
Location: italy
|
|
|
|
if You have all the infrastructure in place a normal IMS user program or an unload
will be able ( once all the proper data format conversion has been taken care of )
to produce a sequential dataset usable on any platform !
as far as DB2 access You should check the IMS manuals to see how to set up
DB2 access from IMS ( not the other way around )
You will execute DFSRRC00 anyway ( if the access is feasible )
both DB2 V5 and IMS v5 are more than 10 years old
are You running zOS or OS/390 ???
as far as accessing IMS data from outside the mainframe...
well the questions needs a bit more of details to be answered
the technically correct but useless reply might be ... it depends 
if you post more details we shall be able to provide better answers! |
|
| Back to top |
|
|
Susan Talbot
New User
Joined: 17 Dec 2010
Posts: 36
Location: KY
|
|
|
|
we are using z/OS V9. Why DB2 and IMS are so old is beyond me.
| Quote: |
as far as accessing IMS data from outside the mainframe...
well the questions needs a bit more of details to be answered
the technically correct but useless reply might be ... it depends |
What do you need to know? What I am really trying to do is avoid having to more code on the mainframe right now. Going from IMS to DB2 won't help. Gotta go the other way if possible. If it is not possible, then I would like to be able to query IMS without writing a COBOL program on the mainframe[/i][/quote] |
|
| Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007
Posts: 10873
Location: italy
|
|
|
|
| Quote: |
| Going from IMS to DB2 won't help. Gotta go the other way if possible. |
nonsense statement!
the sense of my previous post was that if You have a program properly written
it can access at the same time IMS databases and DB2 tables..
to do so the program will not be executed under DSN control
but under DFSRRC00 control!
DB2 and IMS are not railroad stations where You can go ( having the right ticket) from one to the other
so You cannot go from DB2 to IMS, nor from IMS to DB2
but if You expect to access data without writing any code, You are out of luck!
if the business need is that great there are ( expensive IIRC ) products that provide a bridge ! |
|
| Back to top |
|
|
Susan Talbot
New User
Joined: 17 Dec 2010
Posts: 36
Location: KY
|
|
|
|
| Quote: |
| DB2 and IMS are not railroad stations where You can go ( having the right ticket) from one to the other |
No, not like railroad stations. Think of how you can access SQL server from Oracle. Something like that.
Also, I did not say I did not expect to write code, I said without writing COBOL on the mainframe.
I am a COBOL programmer and like COBOL. But I was speaking of connecting directly to IMS to query it, the way you can DB2 via a jdbc connection. |
|
| Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
Hello and welcome to the forum,
Suggest spending time in the documentation for the releases of IMS and DB2 that are being used and see if these provide any insight. BTW/fwiw z/OS 1.9 is rather out of date. . .
| Quote: |
| But I was speaking of connecting directly to IMS to query it |
Unless there is some purchased "front end", i suspect you will need to use DFSRRC00.
Suggest you speak with your database support people and learn if there is any existing application code that uses both IMS and DB2 in the same module on your system. This could be used as a "model" and the compile/link/bind process could be used for your module(s).
One reason your database products are farther out of date than the operating system might be because management wants to move to SQL Server and/or Oracle. . . |
|
| Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007
Posts: 10873
Location: italy
|
|
|
|
the question as posed, without any negotiation loopholes,
and given the prehistoric software level
has only one possible answer ....
NO
for a question posed in a better way with a bit more details
someone might have been willing to spend more time asking questions and helping You to investigate things, like for example
publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic=/com.ibm.db29.doc.apsg/db2z_writeexternalprocims.htm
I knew and inferred perfectly well what you meant ( i am not that dumb ),
since from the name You look like an E1Ler i thought that You should have been able to express better Your requirements 
Dick! everything is out of date there! |
|
| Back to top |
|
|
Bill O'Boyle
CICS Moderator
Joined: 14 Jan 2008
Posts: 2501
Location: Atlanta, Georgia, USA
|
|
| Back to top |
|
|
Gary Jacek
New User
Joined: 17 Dec 2007
Posts: 64
Location: Victoria, BC, Canada
|
|
|
|
IMS V5.1 brings back memories of APPC LU6.1/LU6.2 Adapter.
Trust me, you would be much happier upgrading to IMS V10.1 and using ODBA/DB2 Stored Procedure SQL calls, IMS Connect, IMS SOAP.
If your desktop is running something newer than Windows 95, then you should ask "why not upgrade IMS"? |
|
| Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
Hi Enrico,
| Quote: |
| Dick! everything is out of date there! |
Yup, it surely is . . .
And the same people who will not fund the time/effort/money to keep the environment current are most likely the same ones who want "newer" things done for the user departments.
d |
|
| Back to top |
|
|
|
|
