Cognos Analytics

 View Only
Expand all | Collapse all

When creating a data connection for a DB2 database from the Administrator Console, where do i get the information to add in "DB2 database name" in the CLI tab?

  • 1.  When creating a data connection for a DB2 database from the Administrator Console, where do i get the information to add in "DB2 database name" in the CLI tab?

    Posted Fri July 24, 2020 10:41 AM
    Im trying to migrate the packges and reports form a Cognos 10 to Cognos 11.0. But because i got the error:

    RSV-VAL-0010 Failed to load the report specification. QE-DEF-0285 The logon failed. QE-DEF-0325 The logon failed for the following reason: RQP-DEF-0068 Unable to connect to at least one database during a multi-database attach to 1 database(s) in: ISIM UDA-SQL-0432 Unable to locate the gateway "libcogudajd-d2".

    when i validate them I thougth to create the Datasource connection from the Administrator Console to have the connection be the same as in Cognos 10.
    I though that i had to use the database name of the db i want to connect to for the field "DB2 database name", but after testing i get the error:

    .UDA-SQL-0129 Invalid login information was detected by the underlying database.[IBM][CLI Driver] SQL1013N The database alias name or database name database_name could not be found.

    I saw in the previous installation where this worked that in the Cognos server there was a database that was a perfect copy of the database we were connecting to get the reports. And if i create a database with the same name and credentials in the machine where cognos 11 is installed this error doensn't happen, But i ca0 find the reason for this working.

    How should i configure this step?
    If i use the original connection that i created the first time to make a model and a report it works just fine. So i don understand why this errors are happening.

    Thank you.

    ------------------------------
    Alejandro Gutierrez
    ------------------------------

    #CognosAnalyticswithWatson


  • 2.  RE: When creating a data connection for a DB2 database from the Administrator Console, where do i get the information to add in "DB2 database name" in the CLI tab?

    Posted Tue July 28, 2020 08:44 AM

    The name you specify in the UX will be the one the Db2 CLI will look for.

    If you have not correctly catalog it using the Db2 commands then DB2 CLI will be unable to resolve it.

    [IBM][CLI Driver] SQL1013N The database alias name or database name database_name could not be found.



    ------------------------------
    NIGEL CAMPBELL
    ------------------------------