Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

How to Communicate with IMS V5 via DB2 V5?

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
Susan Talbot

New User


Joined: 17 Dec 2010
Posts: 36
Location: KY

PostPosted: Mon Dec 20, 2010 8:30 pm    Post subject: How to Communicate with IMS V5 via DB2 V5?
Reply with quote

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
View user's profile Send private message

enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10211
Location: italy

PostPosted: Mon Dec 20, 2010 8:39 pm    Post subject: Reply to: How to Communicate with IMS V5 via DB2 V5?
Reply with quote

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 icon_biggrin.gif

if you post more details we shall be able to provide better answers!
Back to top
View user's profile Send private message
Susan Talbot

New User


Joined: 17 Dec 2010
Posts: 36
Location: KY

PostPosted: Mon Dec 20, 2010 9:10 pm    Post subject:
Reply with quote

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
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10211
Location: italy

PostPosted: Mon Dec 20, 2010 11:47 pm    Post subject: Reply to: How to Communicate with IMS V5 via DB2 V5?
Reply with quote

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
View user's profile Send private message
Susan Talbot

New User


Joined: 17 Dec 2010
Posts: 36
Location: KY

PostPosted: Tue Dec 21, 2010 12:47 am    Post subject:
Reply with quote

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
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Tue Dec 21, 2010 1:06 am    Post subject:
Reply with quote

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
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10211
Location: italy

PostPosted: Tue Dec 21, 2010 1:24 am    Post subject: Reply to: How to Communicate with IMS V5 via DB2 V5?
Reply with quote

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
http://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 icon_cool.gif

Dick! everything is out of date there!
Back to top
View user's profile Send private message
Bill O'Boyle

CICS Moderator


Joined: 14 Jan 2008
Posts: 2502
Location: Atlanta, Georgia, USA

PostPosted: Tue Dec 21, 2010 1:25 am    Post subject: Reply to: How to Communicate with IMS V5 via DB2 V5?
Reply with quote

Although ODBA (Open Database Access) is referenced in the following link, for DB2 1.9, you may want to review ODBA compliance for your particular DB2 and IMS version/releases -

http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic=/com.ibm.db29.doc.inst/db2z_ivpodbastproc.htm

I had a customer use this, but I'm unsure of the minimum version/releases required, as I'm not a DB2 nor IMS Systems person.

However, it might be worth a shot.... icon_wink.gif

Bill
Back to top
View user's profile Send private message
Gary Jacek

New User


Joined: 17 Dec 2007
Posts: 44
Location: Victoria, BC, Canada

PostPosted: Tue Dec 21, 2010 1:52 am    Post subject:
Reply with quote

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
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Tue Dec 21, 2010 2:28 am    Post subject: Reply to: How to Communicate with IMS V5 via DB2 V5?
Reply with quote

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
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Excel Macro to communicate with ZScop... Sreenisha Testing & Performance analysis 0 Wed Apr 09, 2014 4:59 pm
No new posts How to communicate with PSB Through P... pingte IMS DB/DC 11 Mon Apr 30, 2007 3:28 pm
No new posts When can we use CAF to communicate DB... Muthukumar.PLindia DB2 2 Mon Jul 03, 2006 11:09 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us