Technical Blog Post
Abstract
Making your life easier: Installing TCR 3.1 with Non-Root Creating Configuring Content Store
Body
C. CREATING AND CONFIGURATION THE CONTENT STORE
NOTE: it is a blog following the one "Installing TCR 3.1 with non-root user" (https://ibm.biz/Bd4j94) although you can use it to create and configure the Content Store manually in case you need it.
The content store is the database used by reporting services and where is store our TCR configuration: Schedule, plan.... and it is needed for running our reports correctly.
Installing with root user this step can be avoided since it is installed and configured during Reporting Services installation but when we install JazzSM as non root user, the installation for Reporting Services may fails with the following error:
-------------------------------------------------------------------------------------------------------------------------------------------
Error during "post-install configure" phase:
Failed in configuring Reporting Services Database.
/home/non_root_user_home/opt/IBM/JazzSM/install/fsconfig.xml:227:
The following error occurred while executing this line:
/home/non_root_user_home/opt/IBM/JazzSM/install/reporting_services/reporting_services_config.xml:17:
The following error occurred while executing this line:
/home/non_root_user_home/opt/IBM/JazzSM/install/reporting_services/reporting_services_config.xml:23:
The following error occurred while executing this line:
/home/non_root_user_home/opt/IBM/JazzSM/install/reporting_services/tcr_db_config.xml:54:
The following error occurred while executing this line:
/home/non_root_user_home/opt/IBM/JazzSM/install/reporting_services/tcr_db_config.xml:66:
The following error occurred while executing this line:
/home/non_root_user_home/opt/IBM/JazzSM/install/reporting_services/tcr_db_config.xml:123:
The following error occurred while executing this line:
/home/non_root_user_home/opt/IBM/JazzSM/install/reporting_services/tcr_db_config.xml:142:
Failed in configuring Reporting Services Database.
-------------------------------------------------------------------------------------------------------------------------------------------
To resolve this issue we are going to have to create and configure the ContentStore manually.
NOTE: the user account “non-root” that we are going to use for the installation will be “tcr”.
Default path for root user = /opt/IBM/JazzSM/
Default path for non-root = /home/name_user_no_root/IBM/JazzSM . So, in our case /home/tcr/IBM/JazzSM
NOTE: All package image will be downloaded in /home/tcr/software_ibm/
FOLLOW THESE STEPS:
1. Go to REPORTING_HOME from user_home_directory and run the following command as non-root user:
./TCR_generate_content_store_db2_definition.sh <db_name> <user_name>
WHERE:
DB_name = The name of the database to create for the Cognos Content Store. The database name can have up to 8 characters
User_name= The user name to connect to the Content Store, that is, the database owner.
In our case , we run from /home/tcr/software_ibm/tcr/TCRInstaller/ContentStoreDatabase with “tcr” user the script:
#./TCR_generate_content_store_db2_definition.sh tcrdb db2inst1
This command generates the tcr_create_db2_cs.sql script in:
/home/tcr/software_ibm/tcr/TCRInstaller/ContentStoreDatabase
2. Now we run the tcr_create_db2_cs.sql script by using the following command as db2 instance user (db2inst1):
“db2 -vtf <user_home_dorectory>/<REPORTING_HOME>/tcr_create_db2_cs.sql”
db2 –vtf /home/tcr/software_ibm/tcr/TCRInstaller/ContentStoreDatabase/tcr_create_db2_cs.sql
3. If it is executed correctly then we will receive the following message:
"The CREATE DATABASE command completed successfully."
And we will be able to connect to the “TCRDB” database with db2inst1 using the command:
db2 connect to tcrdb user db2inst1 using <password>
NOTE: NEXT STEP IN "Installing JazzSM 1.1.0.1 and Webphere 8.5.0.1"
Thanks for reading , Fran.
Check out all our other posts and updates:
Academy Blogs: http://ibm.co/1sPj9E8
Academy Videos: http://bit.ly/1wFKveY
Academy Google+: http://bit.ly/1sR5QTV
Academy Twitter Handle: http://bit.ly/1CknfoF
UID
ibm11276780