How to install reporting data model package and sample reports in RRDI 5.0.2
db2 create database RICM using codeset UTF-8 territory en
db2 connect to RICM
db2 update db cfg for RICM using LOCKTIMEOUT 240
db2 update db cfg for RICM using APPLHEAPSZ 1024
db2 connect reset
db2 connect to RICM
db2 create bufferpool BP32K pagesize 32K
db2 create bufferpool BP4K pagesize 4K
db2 create system temporary tablespace STT32K pagesize 32K managed by system using ('STT32K') bufferpool BP32K
db2 create user temporary tablespace UTT4K pagesize 4K managed by system using ('UTT4K') bufferpool BP4K
db2 create regular tablespace RUT4K pagesize 4K managed by system using ('RUT4K') bufferpool BP4K
db2 connect to RICM
db2 grant dbadm on database to user db2admin
db2 grant CONNECT on database to user RPTUSER
Accepted answer
Hi Robert,
You can refer the below link to upload the data package and sample reports in RRDI
Comments
Thanks for the quick response, Shradha. Unfortunately, I'm getting the following error when trying to load:
CRRRA0042E: An error occurred while loading the archive: 'Cognos_Report_Server_Archive_Files'
Do you have any guidance on how to troubleshoot this?
Thanks,
Robert
Not sure why you faced this error, may be you can check for details in cogserver.log.
However as a workaround, you can deploy the archives manually as well. Please refer the below link
I was able to successfully validate on the Load Cognos Archives page, and received the following message:
The credentials were validated successfully. Click Get Application List to get a list of applications from which archives can be downloaded or click Get Available Archives to get a list of currently available archives...
However, the "Get Application List" button is disabled, and only the "Get Available Archives" button is enabled. I manually downloaded the Cognos_Report_Server_Archive_Files.zip from the JTS Admin Reports Download page and copied to the Cognos\Deployment folder, but when I tried to load it, that is when I got the error in my last comment. If I try to import the file from Cognos Admin, I get an error that it is an invalid deployment file.
I tried it again and it worked. Not sure what I did differently.
Thanks for your help.