Db2 sample databases

You can setup the sample databases in an IBM® DB2® database.

The Db2 sample database and associated files are located in <cognos_samples_installation_location>/ webcontent/samples/datasources/Db2. Extract GS_DB.tar.gz. This creates the GS_DB folder with the following sub-folders.

data: This folder contains the database files.
logs: This folder contains the logs that are created when the scripts are run.
unix: This folder contains the Unix and Linux® scripts.
win: This folder contains the Microsoft Windows scripts.

IBM Db2 samples

The data files for Db2move (a database movement tool command) and the scripts to add constraints are in the data directory.

If you use WinZip to extract the Db2 move file on in a Microsoft Windows environment, ensure that the TAR file smart CR/LF conversion option is not selected.

After you extract the Db2 move file, restore the schemas to a database named GS_DB.

To add views, constraints, user privileges, and stored procedures to GS_DB, prepare and run the gs_db_modify files that are included with the samples in the following order:

Update the user name and password in gs_db_modify.sql and save it.
Run gs_db_modify.bat

Note: If the script file attempts to create a stored procedure where the procedure does not exist an error is generated. This error does not affect the samples.

Set the Db2CODEPAGE environment variable to a value of 1208.

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.

Memory requirements are affected by the size and type of your database system. The GO sample database whose tables are organized by column might require more memory than the typical row-based setup.