CODEWITHSUNDEEP
pythonjdbcims-db
Amruta Mujumdar
Amruta Mujumdar

Reputation: 1

How can Python connect to IMS database?

Need to perform data reconciliation between DB2 and IMS.

Need help on connecting Python to IMS database.

Can JDBC connection help?

Upvotes: -1

Views: 1678

Answers (1)

Richard Tran
Richard Tran

Reputation: 418

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

Upvotes: 2

Related Questions