After installing the refreshed version of ITNM 3.9, I had to run a script (as root) to install Informix. This script is in $NCHOME/precision/install/scripts and it is named "install_ids_root.ksh". Unfortunately, the documentation does not contain sufficient warnings about this script, so here's my hard-earned knowledge:
(Note: Updated 10/10/12 as I learned more)
Assume for the moment that your NCHOME is /opt/netcool/ibm owned by "netcool" with group ownership of "ncoadmin", and your precision domain is called TEST.
1) Make sure (at least on AIX) that /usr/sbin is in your PATH since the script will attempt to create users (informix, ncim) with the "useradd" command.
If you create these users yourself, make sure that they have valid passwords that matched what you gave the installer for the database password
(if you've forgotten that password, it's in ../data/ids.properties as explained in step 4)
2) Make sure the path to $NCHOME/platform is at least r-xr-xr-x
3) Make sure to have the precision domain set in your environment, e.g. export PRECISION_DOMAIN=TEST
4) Run the script with "-f ../data/ids.properties" - that file has various settings (like NCHOME) taken from the installer session.
If things go wrong, you can use: "$NCHOME/Uninstall_ITNM -i" to wipe out Informix and try again. If you are prebuilding the informix and ncim users you'll have to do it again.
By the way, there are several important environmental variables to set for Informix, Here's a snippet from
the .profile (or .bashrc) file for the "netcool" and "informix" users:
# If Informix Dynamic Server is installed, add commands to PATH
if [ -x $NCHOME/platform/$PLATFORM/informix ]; then
inpath $INFORMIXDIR/bin || PATH=$PATH:$INFORMIXDIR/bin
Once the Informix database is built, you should be able to connect to it with Informix's "dbaccess" command. For starters,
log in (or su) as the Informix user (make sure it has the environment variables set as shown above.) Informix uses system identification - if you are on the same host and have already authenticated
yourself as "informix" it will automatically authenticate you to the database.
Try "dbaccess itnm" - If all goes well, you'll be in the client and able to access basic information such as the dbspaces that have been built. In my case, there was another glitch....
The host (we'll call it "itnmhost") was multi-homed. The Informix install created the etc/sqlhosts.ITNM file with a line that looked like:
ITNM onsoctcp *itnmhost 9088
I could not authenticate to the database (Error 951) - Neither the "informix" user nor "ncim" user worked. However once I removed the asterisk before the host name and made the line:
ITNM onsoctcp itnmhost 9088
This fixed the problem. Now I could connect to the database and populate it with the $NCHOME/precision/scripts/sql/informix/populate_informix_database.sh script. (The installation guide does not do a good job of explaining that you need to do this if you are installing Informix after running the ITNM installer.)
Lastly, while still authenticated as the "informix" user, I gave the regular "netcool" connection privileges:
$ dbaccess itnm -
grant connect to 'netcool';
This allows me to run the dbaccess command as the netcool user without have to use a "connect' statement to authenticate to Informix (while on the same host.)