Hello !

I am trying to get an IMS MPP Cobol/DB2 program to run in IMS but it seems that IMS can't connect to DB2.

I have done a IMS gen for my prpogram and transaction, done PSB and ACB generation.

I have defined a SSM member specifying DBBG as DB2 subsystem.

When I run or debug my IMS transaction I get a U3042 abend when doing the SQL statement in my program.

I am not an IMS expert but probably I have to defined or specify something more but I don't know.

ANy tips are welcome !

Bo Nilsson

IBM Systems Middleware

Sweden

Bo,

    This is probably not an RD&T issue; it appears to be base configuration issue with IMS. Forums particular to IMS and DB2 are the best places for these types of questions. 2 Forums that I would suggest for IMS and DB2 are "Information Management System (IMS) Application Development" and "DB2 for z/OS."

     Having said that, I suspect your issue has to do with not making your DB2 load modules available to IMS. The following 2 links in the IBM Knowledge Center may help you with your specific problem. If these don't work, pursue the IMS and DB2 forums referenced above.

http://www-01.ibm.com/support/knowledgecenter/SSEPEK_11.0.0/com.ibm.db2z11.doc.inst/src/tpc/db2z_makeloadmodsavail2ims.html?lang=en-us

http://www-01.ibm.com/support/knowledgecenter/SSEPH2_13.1.0/com.ibm.ims13.doc.sdg/ims_dd_statements.htm (see DFSESL DD statement here)

            Bebe

Hello !

By adding DB2 loadlibs to the //STEPLIB for the IMS CTL region and adding //DFSESL DD pointing to DB2 loadlibs

solved the connection problem from my IMS MPP program to DB2.

Thanks !

Bo Nilsson

IBM Systems Middleware

Sweden