Steps to restore backup files for the samples databases

Use this procedure to restore backup files for the databases required for the sample packages and reports.

Procedure

  1. 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.
  2. If required, copy the backup files for the samples databases to your database backup directory.
  3. 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 Knowledge Base, which is available on the IBM Support Portal (www.ibm.com/support/entry/portal/support).
    • For DB2®, when you create the GS_DB database, create a system default buffer pool with a page size of 32 KB and an associated regular tablespace. Ensure that the system temporary tablespace is also 32 KB.
  4. 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.
Parent topic: Restore backup files for the samples databases