Use this procedure to restore backup files.
Procedure
- On the computer where IBM® Cognos® BI is installed, go to
the sql server, oracle,
or db2 directory located in c10_location/webcontent/samples/datasources.
- If required, copy the backup files for the samples databases
to your database backup directory.
- Restore the samples databases using your database management
tool.
Tip: - For SQL backup files, restore the database from a device, and
ensure that the restore locations are correct for the .ldf and .mdf database
files. For more information, see the Microsoft SQL Server documentation or the IBM Cognos Knowledge Base on the IBM Cognos Customer
Center (http://www.ibm.com/software/data/cognos/customercenter/).
- For DB2®, when you create
the GS_DB database, create a buffer pool with a page size of 16 KB
and an associated tablespace.
- For each database, create at least one user who has select
permissions for all the tables in the restored databases.
Results
You can now create the data source connections in the portal.
