The content store is a database that Content Manager uses
to store global configuration data, global settings (such as the language
and currency formats shown in the user interface), connections to
data sources, and product-specific content. Design models and log
files are not stored in the content store. You must create the content
store before you can use IBM Cognos 8.
Before you begin
Before beginning this task, install the
Rational® Common Reporting offering.
About this task
Create a database instance and an associated user account
for the content store. The user must have the proper permissions to
create and delete tables in the database.
Procedure
- Open a command prompt, and change the directory to C:\Program Files\IBM\RCPR\AppServer\bin.
- Run the command, stopServer.bat RationalInsightServer
-profileName RationalInsight, to stop the server.
- Open the DB2 control center by clicking .
- Create a new database named RICM:
- In the left panel, right-click the All Database folder, and then click .
- In the Database name field, type RICM, accept the other defaults, and click Next.
- In the Specify where to store your data page, accept the defaults, and click Next.
- In the Specify the locale for this database page, ensure that UTF-8 is selected for the Code set field, and click Next.
- Review the actions that will take place, and click Finish.
- Update the application heap size and lock time for the
RICM database:
- Under the All Database folder,
right-click the RICM database, and then click Configure Parameters.
- In the Application section, click
the value field for LOCKTIMEOUT, and then click
the button next to the field.
- In the Change Database Configuration Parameter window, unselect the None field.
- In the Lock timeout field, type 240, and click OK.
- Scroll to the Performance section,
click the value field for APPLHEAPSZ, and then
click the button next to the field.
- In the Change Database Configuration Parameter window, type 1024 in the Application
heap size field, and then click OK.
- Click Apply, and then close the
window.
- Create a 32 KB buffer pool for the system temporary tablespace:
- Expand the RICM database.
- Click the Buffer Pools folder.
- In the lower, right pane, click Create New
Bufferpool.
- In the Buffer pool name field,
type a name.
- Ensure the Page size field is 32.
- Accept the other defaults, and click OK.
- Create a second buffer pool of 4 KB for the user temporary
and regular user tablespace:
- Expand the RICM database.
- Click the Buffer Pools folder.
- In the lower, right pane, click Create New
Bufferpool.
- In the Buffer pool name field,
type a name.
- Ensure the Page size field is 4.
- Accept the other defaults, and click OK.
- Create a system temporary tablespace with the 32 KB buffer
pool:
- Expand the RICM database.
- Click the Table Spaces folder.
- In the lower, right pane, click Create New
Tablespaces.
- In the Specify a name for your new table
space page, type a name in the Table space
name field, and then click Next.
- In the Specify the type of table space page, select System temporary, and then click Next.
- Select the 32 KB buffer pool, and click Next.
- In the Specify the extent and prefetch sizes
for this table space page, select the settings based on
your project, and click Next.
- In the Describe hard drive specifications page, select the settings based on your project, and click Next.
- Review the actions that will take place, and then click Finish.
- Create a user temporary tablespace with the 4 KB buffer
pool:
- Expand the RICM database.
- Click the Table Spaces folder.
- In the lower, right pane, click Create New
Tablespaces.
- In the Specify a name for your new table
space page, type a name in the Table space
name field, and then click Next.
- In the Specify the type of table space page, select User temporary, and then click Next.
- Select the 4 KB buffer pool, and click Next.
- In the Specify the extent and prefetch sizes
for this table space page, select the settings based on
your project, and click Next.
- In the Describe hard drive specifications page, select the settings based on your project, and click Next.
- Review the actions that will take place, and then click Finish.
- Create a regular user tablespace with the 4 KB buffer pool:
- Expand the RICM database.
- Click the Table Spaces folder.
- In the lower, right pane, click Create New
Tablespaces.
- In the Table space name field,
type a name, and then click Next.
- Select Regular, and click Next.
- Select the 4 KB buffer pool, and click Next.
- In the Specify the extent and prefetch sizes
for this table space page, select the settings based on
your project, and click Next.
- In the Describe hard drive specifications page, select the settings based on your project, and click Next.
- In the Specify the dropped table recovery
option page, accept the defaults, and click Next.
- Review the actions that will take place, and then click Finish.
- A user account with the proper permissions to the RICM
database must exist. In the next task, Adding the content store object,
you configure the report server to use this user account to access
the database. To ensure that the user account exists:
- Expand the RICM folder.
- Open the User and Group Objects folder, and click DB Users.
- Modify an existing user account, or create a new user
account:
- To modify an existing account, double-click the user account in
the upper, right pane, and then skip to step e.
- To create a new user account, in the lower, right pane, click Add New User, and then continue with step d.
- In the Database tab, type a user
name in the User field or select one from the
list.
- In the Authorities section, select Connect to database, Create tables, and Create schemas implicitly.
- Click the Table Space tab.
- Click Add Tablespace, select
the three created table spaces, System Temporary, User Temporary, and Regular User, and then click OK.
Note: Use
Shift+Click for multiple selections.
- Highlight the three table spaces, and then click Grant All.
- Ensure that No Grant option is
selected, and click OK.
- Click OK.
Note: You
can also change privileges for an existing user by clicking the user
name, and then clicking Change User Privileges.
Tip: As an administrator, follow best practices
by backing up the RICM database regularly.
- Create a schema for the database user account:
- Expand the RICM folder, and click
the Schemas folder.
- In the lower, right pane, click Create New
Schema.
- In the Create Schema window, type
a name in the Schema name field.
- In the Authorization name field,
select the user that Rational Common Reporting will use to access the RICM database, and click OK.
- In the upper, right pane, right-click the name of the
created schema, and select Privileges.
- Ensure that the RICM database user, selected in step
d, has permission to create, drop, and alter the schema.
- If the user does not have the correct permissions, add
the user, highlight the user, and select Grant All.
- Select the No Grant option.