Creating a statistics repository manually

To create a statistics repository manually, you must first generate the database scripts for the repository in Control Center and then execute the scripts in an external tool.

When you generate the database scripts from Control Center, the scripts are saved in the following directory:

<Base directory>\<Version>\root\config\database\<Statistics Repository>-<GUID>.zip

Where:

•	<Base directory> – Is the path specified for Design Center Projects during the Framework and StreamServer installation. For example: C:\ManagementGateway

•	<Statistics Repository> – Is the name of the statistics repository.

•	<GUID> – Is a globally unique identifier for the ZIP file.

To generate database scripts

1	In the Repositories folder, right-click the statistics repository and select Create Database.

2	In the Operation area, select Create scripts for later use.

3	Select the statistics repository from the drop-down list.

4	Click Start to generate the scripts. When the scripts are generated, you can save a local copy of the scripts.

Executing the database scripts (Microsoft SQL Server)

To create a statistics repository, you must:

•	Run the load_as_sys.sql script to create the database.

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

Prerequisites

•	The login details for the system administrator user (sa) are available.

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

To execute the database scripts

1	Open the appropriate SQL Server tool. For example, Microsoft® SQL Server® Management Studio or SQLCMD.

2	Log in as the system administrator user (sa).

3	Run the load_as_sys.sql script.

4	Run the load.sql script in the database created in step 3 above.

Post requisites

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

•	Since the scripts contain passwords, we recommend that you delete the scripts after you have created the statistics repository.

•	You must now connect the application domains to the statistics repository. See Connecting application domains to the statistics repository.

Executing the database scripts (Oracle Database)

To create a statistics repository, you must:

•	Run the load_as_sys.sql script to create the schema.

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

Prerequisites

•	The login details for the SYSDBA user and the schema owner are available.

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

To execute the database scripts

1	Since the password of the schema owner is the same as the schema owner user name, we recommend that you change the password in the load_as_sys.sql script.

2	Open the appropriate Oracle tool. For example, Oracle® SQL Developer or SQL*Plus (requires Oracle® Database Instant Client).

3	Log in as the SYSDBA user.

4	Run the load_as_sys.sql script.

5	Log in as the schema owner configured for the statistics repository.

6	Run the load.sql script.

Post requisites

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

•	Since the scripts contain passwords, we recommend that you delete the scripts after you have created the statistics repository.

•	You must now connect the application domains to the statistics repository. See Connecting application domains to the statistics repository.