If you're currently using Derby as a content store in your production TCR environment, then I'm afraid this is not a supported configuration.

IBM have issued a flash about this, the details of which can be found here - http://www-01.ibm.com/support/docview.wss?uid=swg21609287

Derby is recommended for demonstration/testing purposes only, it's just not designed to be used in a production or enterprise level environment. If you are using Derby at present, we would strongly advise you to change away from this to one of the supported databases as quickly as you can.

Although TCR 2.1.1 is already an old product , we can still find customers with this version installed and using Derby like their Content store. In these cases the best practice should be install the newest TCR

version 3.1.x but I also know that sometimes it is not possible and we have to install a parallel env. and we need to mount another environment 2.1.1 like our production env. before upgrading to TCR 3.1 .

In this blog I'm going to show you a step by step about how to install TCR 2.1.1 in a single machine and how configure the Content Store from Derby to DB2 database. To avoid to have a very very long

blog I will split it in two: Installing TCR and Configuring Content Store for DB2

TCR installs an embedded lightweight database (Derby) to house reporting artifacts. The derby database is not supported in production and it is recommended to use an relational database such as
DB2. So, it is strongly recommends to migrate from derby database to a relation DB.

1. Create the database with endoding=UTF-8 and protocol TCP/IP

We can use this script template to create the content store. Replace the database_name with the name of the database, for example TCRDB and userID with the user that tcr will use to connect to the content
store, for example cognos. The database user account must exist for the product function and you must run the script as a user with sufficient privileges to access and create database:

1.2 create a script with the above template named: create_database.bat/sh

1.3 from “command window/DB2” we run the script with Administrator or db2admin or from “command line processor” (DB2) run the above sentences.

2. Set up database connectivity for the content store database :

2.1 if you are using type 2 jdbc connectivity , install the DB2 client on the Content manager if you are using type4 jdbc connectivity for DB2, you are not required to install the DB2 client in the content manager.

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):

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.

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