IBM Support

Making your life easier: Installing TCR 3.1.2.1 with Non-Root Creating Content Store

Technical Blog Post


Abstract

Making your life easier: Installing TCR 3.1.2.1 with Non-Root Creating Content Store

Body

 

 

 

D. CREATING MANUALLY THE CONTENT STORE FOR TCR 3.1.2.1

 

NOTE: it is a blog following the one "Installing  TCR 3.1.2.1 with Non-Root user account" (https://ibm.biz/Bd4eWr)  although you can use it to create and configure the Content Store manually in case you need it.

 

What is the content store? :

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.

 

We are going to install the CS manually since our TCR installation will be performed with non-root user , "fran", and Reporting services installation will fail with 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.

-------------------------------------------------------------------------------------------------------------------------------------------

 

NOTEtcruser = our instance owner user for db2 and TCRDB = will be our Content Store database

 

1. Go to the path were TCR was downloaded and uncompesed, in our case


/home/fran/Desktop/tcr3121/TCRCognos/ContentStoreDatabase


2. Now run the script, TCR_generate_content_store_db2_definition.sh , with non-root user:

 

image

 

3. Now we run the scrip generated in the previous point: tcr_create_db2_cs.sql with our db2 instance user, tcruser.

 

-------------------------------------------------------------
[tcruser@ITM63lab bin]$ db2 -vtf tcr_create_db2_cs.sql
CREATE DATABASE TCRDB ALIAS TCRDB USING CODESET UTF-8 TERRITORY US
DB20000I The CREATE DATABASE command completed successfully.
CHANGE DATABASE TCRDB COMMENT WITH 'IBM Cognos Content Store'
DB20000I The CHANGE DATABASE COMMENT command completed successfully.
CONNECT TO TCRDB
Database Connection Information
Database server
= DB2/LINUXX8664 10.5.3

SQL authorization ID = TCRUSER
Local database alias = TCRDB
UPDATE DATABASE CONFIGURATION USING APPLHEAPSZ 1024 DEFERRED
DB20000I The UPDATE DATABASE CONFIGURATION command completed successfully.
UPDATE DATABASE CONFIGURATION USING LOCKTIMEOUT 240 DEFERRED
DB20000I The UPDATE DATABASE CONFIGURATION command completed successfully.
CONNECT RESET
DB20000I The SQL command completed successfully.
CONNECT TO TCRDB
Database Connection Information
Database server
= DB2/LINUXX8664 10.5.3
SQL authorization ID = TCRUSER
Local database alias = TCRDB
CREATE BUFFERPOOL TCRDB_08KBP IMMEDIATE SIZE 1000 PAGESIZE 8K
DB20000I The SQL command completed successfully.
CREATE BUFFERPOOL TCRDB_32KBP IMMEDIATE SIZE 1000 PAGESIZE 32K
DB20000I The SQL command completed successfully.
CONNECT RESET
DB20000I The SQL command completed successfully.
CONNECT TO TCRDB
Database Connection Information
Database server
= DB2/LINUXX8664 10.5.3
SQL authorization ID = TCRUSER
Local database alias = TCRDB
CREATE SYSTEM TEMPORARY TABLESPACE TSN_SYS_TCRDB IN DATABASE PARTITION
GROUP IBMTEMPGROUP PAGESIZE 32K BUFFERPOOL TCRDB_32KBP
DB20000I The SQL command completed successfully.
CREATE USER TEMPORARY TABLESPACE TSN_USR_TCRDB IN DATABASE PARTITION
GROUP IBMDEFAULTGROUP PAGESIZE 8K BUFFERPOOL TCRDB_08KBP
DB20000I The SQL command completed successfully.
Installing TCR 3.1.2.1
Page 10
Fran Martínez
April 2016
CREATE REGULAR TABLESPACE TSN_REG_TCRDB IN DATABASE PARTITION GROUP
IBMDEFAULTGROUP PAGESIZE 8K BUFFERPOOL TCRDB_08KBP
DB20000I The SQL command completed successfully.
CONNECT RESET
DB20000I The SQL command completed successfully.
CONNECT TO TCRDB
Database Connection Information
Database server
= DB2/LINUXX8664 10.5.3
SQL authorization ID = TCRUSER
Local database alias = TCRDB
CREATE SCHEMA tcruser AUTHORIZATION tcruser
DB20000I The SQL command completed successfully.
COMMENT ON SCHEMA tcruser IS 'IBM Cognos Content Store'
DB20000I The SQL command completed successfully.
GRANT CREATETAB,BINDADD,CONNECT,IMPLICIT_SCHEMA ON DATABASE TO USER
tcruser
DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL0554N An authorization ID cannot grant a privilege or authority to itself.
SQLSTATE=42502
GRANT CREATEIN,DROPIN,ALTERIN ON SCHEMA tcruser TO USER tcruser WITH GRANT
OPTION
DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL0554N An authorization ID cannot grant a privilege or authority to itself.
SQLSTATE=42502

GRANT USE OF TABLESPACE TSN_USR_TCRDB TO USER tcruser
DB21034E The command was processed as an SQL statement because it was not a

valid Command Line Processor command. During SQL processing it returned:
SQL0554N An authorization ID cannot grant a privilege or authority to itself.
SQLSTATE=42502
GRANT USE OF TABLESPACE TSN_REG_TCRDB TO USER tcruser
DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL0554N An authorization ID cannot grant a privilege or authority to itself.
SQLSTATE=42502
CONNECT RESET
DB20000I The SQL command completed successfully.
-------------------------------.

 

4. We check that the TCRDB database was created and it can be connected


4.1 [tcruser@ITM63lab bin]$ db2 connect to TCRDB


Database Connection Information
Database server
= DB2/LINUXX8664 10.5.3
SQL authorization ID = TCRUSER
Local database alias = TCRDB


4.2 [tcruser@ITM63lab bin]$ db2 list tables for schema TCRUSER


           Table/View               Schema Type Creation time
------------------------------- --------------- ----- --------------------------
0 record(s) selected.

 

 

Thanks for reading, Fran.

 

image

 

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

 

[{"Business Unit":{"code":"BU004","label":"Hybrid Cloud"},"Product":{"code":"","label":""},"Component":"","Platform":[{"code":"","label":""}],"Version":"","Edition":""}]

UID

ibm11083603