-1

Need to perform data reconciliation between DB2 and IMS.

Need help on connecting Python to IMS database.

Can JDBC connection help?

Richard Tran
  • 438
  • 3
  • 10
Amruta Mujumdar
  • 1
  • 1

1 Answers1

2

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
Richard Tran
  • 438
  • 3
  • 10