Posts

Showing posts from January, 2017

Configure a Netezza connection using ODBC on UNIX

Image
Install the Netezza ODBC driver, and Netezza client libraries. Note If you are running a PowerCenter 32-bit Integration Service, make sure the Netezza 32-bit ODBC driver and client are installed and accessible. If you are running a PowerCenter 64-bit Integration Service, make sure the Netezza 64-bit ODBC driver and client are installed and accessible. Set the following environment variables: NZ_ODBC_INI_PATH Set NZ_ODBC_INI_PATH to $INFA_HOME/ODBCn.n/ Add $INFA_HOME/ODBCn.n/lib:{NetezzaInstallationDir}/lib64 to the shared library environment variable. Solaris LD_LIBRARY_PATH Linux LD_LIBRARY_PATH AIX LIBPATH HP-UX SHLIB_PATH For instance, use the following syntax for Solaris: LD_LIBRARY_PATH Add $INFA_HOME/ODBCn.n/lib:{your Netezza path}/lib64 to the library path ODBCINI Set ODBCINI to ${NZ_ODBC_INI_PATH}/odbc.ini Set the ODBCINI environment variable so that it points to the location of the odbc.ini file. Note If this variable is not set it will look for .odbc.ini in the us...

E4) Cannot connect to admin server at host and post 5498 - ​ Cognos TM1 client not able to connect to TM1 admin server .

Image
​​ Cognos TM1 client not able to connect to TM1 admin server . You must refresh your SSL Certificate or your TM1 System. http://www-01.ibm.com/support/docview.wss?uid=swg21991793 http://www-01.ibm.com/support/docview.wss?uid=swg21991787 http://www-01.ibm.com/support/docview.wss?uid=swg21991790 http://www-01.ibm.com/support/docview.wss?uid=swg21990588 http://www-01.ibm.com/support/docview.wss?uid=swg21990869

How to uninstall the Cognos Content Database

Technote (troubleshooting) Problem(Abstract) If you configured your IBM Cognos environment to use the Cognos Content Database, otherwise known as Derby, as your Content Store and you would like to uninstall it and use a supported database application for you Content Store. Resolving the problem 1) - On the computer where you installed Cognos Content Database, go to the  cognosroot_location \bin directory, and type the following command: On Windows, type derby.bat uninstall This command removes the Cognos Content Database service. On UNIX, type derby.sh stop This command stops the Cognos Content Database service. 2) - In the  cognosroot_location  directory, delete the derby10.* directory. 3) - In the  cognosroot_location \bin directory, delete the following files: On Windows, derby.bat On UNIX, derby.sh and derbyenv.sh 4) - On Windows, in the  cognosroot_location \logs directory, delete the derby.service file. 5) - In the  cognosroot_location  directory, open the cmplst.txt file in a te...