Cognos Analytics

Cognos Analytics

Connect, learn, and share with thousands of IBM Cognos Analytics users! 


#Product
#Analytics
#CognosAnalytics
#Analyticstools
#TechXchange Partner
#TechXchange Session
#TechXchange Presenter
#AI
 View Only

  • 1.  Content Store on Informix

    Posted 09/28/20 09:05 AM
    What is the correct way to create the content store on an Informix server? I am currently following this process based on the documentation but the test connection spins forever and never succeeds. I can connect to it using other tools such as SQuirreL using the latest Informix JDBC drivers.

    [informix@32ecb69e7b90 ~]$ export DB_LOCALE=en_us.utf8
    [informix@32ecb69e7b90 ~]$ export CLIENT_LOCALE=en_us.utf8
    [informix@32ecb69e7b90 ~]$ export GL_USEGLU=1
    [informix@32ecb69e7b90 ~]$ env
    CLIENT_LOCALE=en_us.utf8
    LD_LIBRARY_PATH=/opt/ibm/informix/lib:/opt/ibm/informix/lib/esql:
    LANG=C.utf8
    BASEDIR=/opt/ibm
    INIT_LOG=/opt/ibm/data/init_status.log
    HOSTNAME=32ecb69e7b90
    GL_USEGLU=1
    SCRIPTS=/opt/ibm/scripts
    ONCONFIG=onconfig
    DB_LOCALE=en_us.utf8
    INFORMIXSERVER=informix
    container=oci
    PWD=/home/informix
    INFORMIX_KSTORE=/opt/ibm/data/kstore
    HOME=/home/informix
    INFORMIX_FILES_DIR=/opt/ibm/files
    INFORMIX_DATA_DIR=/opt/ibm/data
    TERM=xterm
    INFORMIXDIR=/opt/ibm/informix
    SHLVL=1
    INFORMIXSQLHOSTS=/opt/ibm/informix/etc/sqlhosts
    LICENSE=accept
    INFORMIX_CONFIG_DIR=/opt/ibm/config
    INFORMIX_HOME=/home/informix
    PATH=:/opt/ibm/informix/bin:/opt/ibm/informix/jvm/jre/bin:.:/home/informix/.local/bin:/home/informix/bin:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin
    _=/usr/bin/env
    [informix@32ecb69e7b90 ~]$ dbaccess - -
    > create database cs in csdb with log mode ANSI;

    Database created.

    ------------------------------
    Robert Hofstetter
    ------------------------------

    #CognosAnalyticswithWatson


  • 2.  RE: Content Store on Informix

    Posted 09/30/20 01:54 AM

    Hi Rob - good to hear from you.

    Looks like you have included the prerequisites as documented. If you are using the informix JDBC drivers this should not apply but maybe worth testing? https://www.ibm.com/support/pages/test-informix-content-store-fails-content-manager-unable-access-content-store-verify-your-database-connection-parameters-and-then-contact-your-administrator 

    I presume it doesn't start either - maybe the log has an error.



    ------------------------------
    Luke Peterson
    Business Analytics Advocate
    IBM
    ------------------------------



  • 3.  RE: Content Store on Informix

    Posted 10/05/20 11:00 AM
    Luke,

    Hello. You are correct that at first I was using TCP port until I saw that article and realized it was using the DRDA port so opened that up. I installed with the quick start option and did some investigation. Maybe that is part of the problem I'm having because I have not re-installed without that. I just removed the built-in connection and tried creating a new connection to a separate Informix database on another server since that included the DB2 driver anyway. I think I'll try that next.

    Thanks,
    Rob Hofstetter

    ------------------------------
    Robert Hofstetter
    ------------------------------

    Original Message


  • 4.  RE: Content Store on Informix

    Posted 10/05/20 01:06 PM
    I determined the root cause of the problem. Apparently the developer edition doesn't pre-configure the DRDA connection properly. The sqlhosts has it listed as informix_dr mapped to 9089 but the onconfig does NOT define informix_dr as an alias. Once I added that it worked like a charm.

    ------------------------------
    Robert Hofstetter
    ------------------------------

    Original Message


Related Content