0 Replies Latest reply on Apr 15, 2019 5:26 AM by Francois Sammour

    DDM for IBM DB2 for iSeries Access ODBC

    Francois Sammour Active Member



      hope you can help.


      Please find the below summary of DDM for IBM DB2 for iSeries Access ODBC.


      Created an IBM DB2 Service for ODBC and added the DB2 Database.

      Assigned the Security rule and Connection rule.

      Created the connection from Informatica Domain to the DDM DB2 and tested successfully.

      Imported the objects using this DDM DB2 connection into Informatica project.

      Data viewer and mapping execution ends with error


      Error Message: LDTM_0072 RR_4036 Error connecting to database [IBM][CLI Driver] SQL1598N An attempt to connect to the database server failed because of a licensing problem, SQL STATE=42968.


      Created the DDM Service for ODBC.


      Need help on configuring the IBM iSeries Access ODBC Driver to the DDM and also on creating the ODBC connection database on DDM to perform the masking based on UserName.