InfoSphere Optim

 View Only
  • 1.  issue creating DB Alias for DB2 LUW for IBM OPtim

    Posted Wed April 20, 2022 01:44 PM
    Hi,

    We are having issues creating DB alias for DB2 database.
    We have Optim (64 bit) available on windows(64 bit) machine and DB2 DB(64 bit) available on Linux (64 bit) machine. we have done below steps as of now.

    1. install ODBC for DB2 on windows
    2. setup ODBC for DB2 connection on windows machine.
    3. validate or test connection (successful)
    4. create Optim DB Alias for DB2 by providing details User name, password, connection string (name from ODBC connection)
    5. when click on next  we  get error - "An unknown internal error occurred in function RDB_GethConn. RC=-1"

    PFB screenshots. 
    ODBC connection successful.


    Optim DB Alias Error.


    ------------------------------
    rajesh guttikonda
    ------------------------------

    #InfoSphereOptim
    #Optim


  • 2.  RE: issue creating DB Alias for DB2 LUW for IBM OPtim

    IBM Champion
    Posted Wed April 20, 2022 02:43 PM
    Rajesh,

    Rather than use ODBC, why not use the DB2 Connect software that as that is what Optim is expecting.  It is free for use with DB2.

    Jimmy Wilson

    ------------------------------
    Jimmy Wilson
    ------------------------------



  • 3.  RE: issue creating DB Alias for DB2 LUW for IBM OPtim

    Posted Wed April 20, 2022 02:56 PM
    Hey Jimmy,

    Thanks for your quick response. is there any documentation for this DB2 DB alias configuration?

    ------------------------------
    rajesh guttikonda
    ------------------------------



  • 4.  RE: issue creating DB Alias for DB2 LUW for IBM OPtim

    IBM Champion
    Posted Wed April 20, 2022 03:42 PM
    Hi Rajesh,

    There would be multiple pieces of documentation required.  

    First - You would need to catalog the DB2 database on all necessary servers and workstations.  That would be a part of the DB2 documentation based on the platform.

    Second - Once the DB2 database is cataloged, you would go through normal DBAlias configuration process but instead of trying ODBC, you would select DB2 LUW and then the appropriate database release version.  The connection would be the catalog information from the first step.

    I can't really look up the documentation right now but if you can't figure it out, please let me know.

    Jimmy Wilson

    ------------------------------
    Jimmy Wilson
    ------------------------------



  • 5.  RE: issue creating DB Alias for DB2 LUW for IBM OPtim

    Posted Wed April 20, 2022 05:42 PM
    Thanks Jimmy i was able to setup DB alias DB2 by creating catlog.

    ------------------------------
    rajesh guttikonda
    ------------------------------



  • 6.  RE: issue creating DB Alias for DB2 LUW for IBM OPtim

    Posted Wed May 18, 2022 09:10 AM

    Hi Jimmy,

    I'm facing something similar. I tried to create a DS Alias. It's an AS400 System catalogued in Db2 Connect. JDBC connection tested is passed. But, when Finished configuration it fails.

    Log shows this:
    An unknown internal error occurred in function RDB_GethConn. RC=-1

    Am I doing OK trying to resgister iSeries system in this way?



    Regards.



    ------------------------------
    Adrian Castrillo
    ------------------------------



  • 7.  RE: issue creating DB Alias for DB2 LUW for IBM OPtim

    Posted Wed May 18, 2022 01:51 PM
    Hello Adrian,
    I'm sorry but Optim does not support an iSeries DB Alias. The attached link documents the required setup of IBM InfoSphere Federation Server (aka Db2 LUW) connectivity to iSeries.  You would create Nicknames in the federation server and Optim would connect to the federation server to access iSeries data. 


    The link below to IBM RedBook "Implementing an InfoSphere Optim Data Growth Solution" provides some information on configuring Optim to use the InfoSphere Federation Server. 



    --
    Paul Wirth
    Optim Technical Specialist
    ABMartin LLC
    304-620-4265





  • 8.  RE: issue creating DB Alias for DB2 LUW for IBM OPtim

    Posted Wed May 18, 2022 09:10 AM

    Hi Jimmy,

    I'm sorry for entering discussion this way.

    I'm facing something similar. I catalogued an iSeries System on Db2 Connect (connection works perfectly). Now, I'm trying to create a DS Alias on my Optim environment. However, I received this error:
    An unknown internal error occurred in function RDB_GethConn. RC=-1
    db2diag doesn't shows error messages and even JDBC connectin test is passed.
    Am I doing this connection well, or maybe this is not the way to use iSeries with Optim?

    Regards!



    ------------------------------
    Adrian Castrillo
    ------------------------------