There are six post-installation steps and I get stuck on step one, Updating NCIM (Mandatory).
The instruction provided by the FP3 README file is simple, I am supposed to run the updatePrecisionGUIDb.sh against my db2 database. After I run the command I get some errors.
After reading the script, I understand that it uses $NCHOME/precision/scripts/sql/db2/updatePrecisionGUIDb.sql to update the db2 database, but all db2 database command in this file are wrong in syntax :
1. db2 command does not end with ';'
2. db2 does not like carriage returns or line feeds.Make your commands be on one long line or use "\" for multiple lines.
ok, so causes found, we just need to remove all ending '';' from all db2 commands, and append "\" at the end of each statement of those those multi-line db2 commands,or simply make them one big line.
After this the updatePrecisionGUIDb.sh script runs happily.
To make your life easier, I've attached the modified $NCHOME/precision/scripts/sql/db2/updatePrecisionGUIDb.sql below.