Creating the Cognos Content Store from the command line

If the target environment does not have a browser or graphical environment, use the command line to create the database for the Cognos® Content Store.

Before you begin

Review your target environment to ensure that it meets the hardware and software requirements for Jazz™ for Service Management and its related software. See Hardware and software requirements.
Decide whether to install as a root user or non-root user, see Installing as a root user or non-root user.
Ensure that you have downloaded and extracted the Reporting Services installation media for your platform to your target machine, for example, Install_Imgs_Home/TCRCognos, where Install_Imgs_Home/ refers to the common root directory to which the installation media are extracted.
Restriction: You cannot generate the SQL script, which creates the DB2® database for the Cognos Content Store, from the directory of the mounted DVD.
Ensure that you have write permissions to the Install_Imgs_Home/TCRCognos/ContentStoreDatabase directory, so that you can generate the SQL script for creating the DB2 database for the Cognos Content Store in this directory.
Create a separate database user with administrative privileges to own the Cognos Content Store.
See DB2 users and groups in the IBM® DB2 Information Center for Linux, UNIX, and Windows.

See Required user accounts for installation of DB2 server products (Windows) in the IBM DB2 Information Center for Linux, UNIX, and Windows.
Ensure that you have installed DB2. You can use an existing DB2 installation if the version of DB2 is supported by Jazz for Service Management.
- If installing Jazz for Service Management as a root user, see Setting up DB2 as a root user.
- If installing Jazz for Service Management as a non-root user, see Setting up DB2 as a non-root user.

About this task

You can create the database for the Cognos Content Store in the same DB2 instance or on a new database server.

Procedure

Open a command window. Change to the Install_Imgs_Home/TCRCognos/ContentStoreDatabase directory, and run the following scripts:
- On Windows systems
```
TCR_generate_content_store_db2_definition.bat database_name user_name 
```
- On UNIX systems
```
./TCR_generate_content_store_db2_definition.sh database_name user_name 
```
This command generates the tcr_create_db2_cs.sql script in the Install_Imgs_Home/TCRCognos/ContentStoreDatabase directory. When you run this SQL script, it creates the DB2 database for the content store.
database_name

The name of the database to create for the Cognos Content Store. The database name can have up to 8 characters. To avoid potential problems, do not use special characters such as @, #, and $ in the database name.

user_name
The user name to connect to the content store, that is, the database owner.
The user name can be:
- The common administrator user name that is created during the full installation.
- The database administrator that is created during DB2 setup on the Jazz for Service Management database server in a custom installation scenario.
- The user name associated with the user account that is created on the database server for the content store.

Open the command window for DB2. Run the SQL script that you generated: db2 -vtf path_sqlscript_filename, for example: AIX operating systems

/opt/IBM/SQLLIB/BIN>
db2 -vtf Install_Imgs_Home/TCRCognos/ContentStoreDatabase/tcr_create_db2_cs.sql

c:\Program Files\IBM\SQLLIB\BIN>
db2 -vtf Install_Imgs_Home/TCRCognos/ContentStoreDatabase/tcr_create_db2_cs.sql