Report database RICM schema
![]()
Bin Chen (4●1●10●11)
| asked Jul 26 '12, 2:39 p.m.
retagged Sep 28 '12, 9:31 a.m. by Kelly Raposo (46●3)
Hi, the whole RRDI 2.0 installation process did not seem to mention anything about RICM user or schema.
What schema it creates?
My RICM database does not seem to have any thing added by the installation process.
|
6 answers
![]()
Actually, the RRDI Setup does not create any tables in the RICM database. It just configures the database for use by Cognos. With DB2, this includes creating the necessary buffer pools and table spaces as described in the Cognos documentation. Once the Cognos Report Server starts, it creates all the tables and other schema elements it needs. That database is used strictly by Cognos for its internal storage. It schema is internal Cognos knowledge, and subject to change by Cognos. Therefore, RRDI has no knowledge of it.
Mike Fox |
![]()
Benjamin Silverman (4.1k●6●10)
| answered Aug 01 '12, 10:07 a.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER
Hello,
Did you run the RRDI setup server to complete the configuration of the application after the install? The setup wizard has steps that will create or populate the databases with the necessary tables and schemas. The setup wizard is outlined in this topic. If you haven't run it already, make sure you run the server.config before entering the setup wizard. Hope it helps, |
![]()
Mike, yes, it does create a bunch of tables and this happens when you run setup wizard.
|
![]() The tables and other structures are created in the content store data base when the Cognos report server starts. It i part of the Cognos initialization process. This would be done as part of the RRRDI install for 1.0.2.x and the Setup process for RRDI 2.0.x. The name "RICM" is the default, but not required. You specify the name during the install process for 1.0.2.x or on the Content Store Setup page for 2.0.x. When you get the "Content Manager not runnng" error, did you get any other errors that might have led this condition? You should also run the Cognos Configuration utility and verify that the content store database is configured correctly (name, location, credentials, etc) and test connectivity. Mike |
Your answer
Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.