Executing database scripts (IBM DB2)

To create a repository, you must:

•	Run the load_as_sys.cmd script to create the repository.

•	Run the load.sql script to create the tables etc. for the repository.

Prerequisites

•	The login details for the database administration user must be available. By default, the database administration user that creates a schema (that is, an OpenText StreamServe repository) is the schema owner of that schema.

•	The ZIP file with the database scripts is generated in Control Center and unpacked using an archiving application, such as WinZip.

Post requisites

•	Do a sanity check to make sure the repository was created according to your configurations.

•	Since the scripts contain passwords, it is recommended to delete the scripts after you have created the repository.

•	A database alias and a node are automatically cataloged when you execute the scripts. Unless there are specific reasons for keeping them, it is recommended to uncatalog the database alias and the node. For more information, see OpenText StreamServe IBM DB2 Database Guidelines.

•	To effectuate prepared database parameters and do a basic tuning of the runtime repository, you must restart the IBM DB2 instance. For more information, see OpenText StreamServe IBM DB2 Database Guidelines.

To execute the scripts

1	In DB2 CLP, go to the directory where the unpacked ZIP file resides.

2	Run the following command to create the repository:

db2 -vf load_as_sys.cmd -z <Log file>

3	Check the log file use the logging features of DB2 CLP.

If the creation failed due to an already existing node and this node is connected to a remote host other than the configured host, you can either change the node name (STRS_<Number>, maximum 8 characters in total) in the load_as_sys.cmd script, or manually uncatalog the already existing node. Then re-run the script as described in step 3.

4	Run the following command as the schema owner to create the tables etc. for the repository:

db2 -td@ -vf load.sql -z <Log file>

5	Check the log file.