IBM Business Analytics

 View Only

Has anyone successfully connected Cognos Analytics to a DB2 for z/OS?

  • 1.  Has anyone successfully connected Cognos Analytics to a DB2 for z/OS?

    Posted Wed July 20, 2022 10:34 AM

    We are trying to connect to a DB2 for z/OS database from within Cognos Analytics v 11.1.7. We have a successful connection, but are unable to load the schemas. We can see the schemas, but when trying to load the metadata, we receive the below error:

    MSR-GEN-0026 The schema "ACT121D" is either empty, or not accessible using the current signon.

    CA is hosted with IBM and our DB2 z/OS is internal to our company. Seems odd we can connect and see the schemas but are unable to load. We can connect to this mainframe using the same ID using internal database tools like, DataGrip and dBeaver.

    Has anyone had this loading metadata issue?



    ------------------------------
    MICHAEL JANDORA
    ------------------------------