How can Python connect to IMS database?

1.5k Views Asked by At

Need to perform data reconciliation between DB2 and IMS.

Need help on connecting Python to IMS database.

Can JDBC connection help?

1

There are 1 best solutions below

0
On

It looks like the IMS JDBC driver should work with the Python JayDeBeApi. The code would look similar to the following:

import jaydebeapi
conn = jaydebeapi.connect('com.ibm.ims.jdbc.IMSDriver', ['jdbc:ims://<host>:<port>/<psb_name>', '<user>', '<password>'],'</to/path/imsudb.jar>',)  

You will probably need an IMS System Programmer to set up the necessary backend address spaces along with the IMS catalog:

  1. IMS Connect (The IMS TCP/IP Gateway)
  2. IMS Open Database Manager
  3. IMS SCI/OM