IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

JDBC driver for connecting java with IMS


IBM Mainframe Forums -> IMS DB/DC
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
karthickpearl

New User


Joined: 13 Apr 2010
Posts: 35
Location: Chennai

PostPosted: Thu Mar 31, 2011 1:37 pm
Reply with quote

Hi Buddys...

I am trying to connect IMS DB in our mainframe with a java program from the desktop.

To do this it seems we need a driver (JDBC) for Java and the name of that driver is
-IMS Universal DL/I driver - imsudb.jar
-IMS Universal JDBC driver - imsudb.jar
-JDR resource adapter - imsutm.jar

I searched in the internet but nowhere I could find the downloadable file.

From some forum I got to know that there is a Unix service running in Mainframe Z OS, and we can FTP those jars from a HFS(Hierarchial File System) path /usr/lpp/ims/ims10/imsjava/IBM/. But in our mainframe we could not find those Jar files in this path. But we could navigate till usr/lpp/ folder.

Can anyone suggest a solution for me for this problem? (If possible with a link to download those Jars)
Back to top
View user's profile Send private message
enrico-sorichetti

Superior Member


Joined: 14 Mar 2007
Posts: 10873
Location: italy

PostPosted: Thu Mar 31, 2011 1:59 pm
Reply with quote

people trying to use advanced techniques should have the minimum skill of reading the manuals and searching
something You seem to lack

everything You might want to know is clearly written in the manuals
for example here
publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/Shelves/DFSSH0H1
proceeding to IMS V10 Installation Guide here
publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/DFSIVGH0/CCONTENTS?SHELF=DFSSH0H1&DN=GC18-9710-00&DT=20070913105533

the best way would be to check with Your support to see if all the IMS components have been properly installed

if the /usr/lpp is empty Your installation might severely flawed/INCOMPLETE and little can be done from a forum
the IMS JAVA stuff is a separate FMID
THE JAVA FMID AND THE JDBC ARE THERE JUST WAITING TO BE MOVED TO THE PROPER PLACE

Code:
Entry Type:  HFS
Entry Name:  DFSJJDBC

To return to the previous panel, enter END .

To select an entry from a zone, enter S next to the zone.

* - Entry not found in zone.
** - Zone could not be allocated or is not initialized.

-------------------- Status -----------------------------------
ZONE     FMID     RMID     LASTUPD  UPDTYPE  DISTLIB  SYSLIB
-------- -------- -------- -------- -------- -------- -------- --------
GLOBAL   *
IMS101D  JMK1016  UK34430  JMK1016           ADFSJHFS SDFSJHFS
IMS101T  JMK1016  UK34430  JMK1016           ADFSJHFS SDFSJHFS



additional info can be found by googling for ibm ims java drivers download
it gave plenty of info and links for various ims and java related additional downloads
Back to top
View user's profile Send private message
karthickpearl

New User


Joined: 13 Apr 2010
Posts: 35
Location: Chennai

PostPosted: Fri Apr 01, 2011 6:20 pm
Reply with quote

Hi Enrico,

If I've had a chance to read through all those manuals then there's no point in me asking doubts in an experinced forum like this.

More over since we could not get the Jar file from our mainframe system I thought there might be some secondary options that IBM would have given for such helpless users and thats why I asked for any other possiblities to have that file.

Any thank you very much for your timely reply. Its was informative.
Back to top
View user's profile Send private message
Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 8696
Location: Dubuque, Iowa, USA

PostPosted: Fri Apr 01, 2011 6:40 pm
Reply with quote

You're not likely to find much help on this forum. Only your site support group has the knowledge to help you. They can tell you if they installed the IMS Unix System Services components, and if so whether they installed into the default /usr/lpp/ims directory or not. This could be as simple as a permissions issue on /usr/lpp/ims -- but, again, only your site support group can look at the permissions for this directory AT YOUR SITE and tell you if they're 755, 644, or what. It is not out of the bounds of reason, too, that they installed into some other directory entirely.
Back to top
View user's profile Send private message
enrico-sorichetti

Superior Member


Joined: 14 Mar 2007
Posts: 10873
Location: italy

PostPosted: Fri Apr 01, 2011 6:48 pm
Reply with quote

an interesting document
ftp.software.ibm.com/software/emea/de/events/ad/16/6-Java-Workshop-Handouts.pdf
and the last file
ftp.software.ibm.com/software/emea/de/events/ad/16/6-best_of_ims_java_workshop_project_interchange_with_jcl.zip

contains the jars You asked for

but I would carry on lots of investigations before proceeding
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> IMS DB/DC

 


Similar Topics
Topic Forum Replies
No new posts Calling Java method from batch COBOL ... COBOL Programming 5
No new posts Using Java/C/C++ to retrieve dataset ... Java & MQSeries 6
No new posts building java class with zip4j.jar on... Java & MQSeries 0
No new posts Getting Error while trying to establi... DB2 3
No new posts Getting TWA in CICS program while con... CICS 14
Search our Forums:

Back to Top