Search documentation:
	Help  Advanced
Published 08/08/2002

Chapter 3

Setting Up Databases

This chapter explains how to create and configure Risk Manager's databases.

Creating the Databases

You can create a single database, to be shared by the Administration Server and the Decision Server, or you can create a separate database for each server. If you create separate databases and run each one on a different server, your Decision Server can continue to process transactions even if you need to restart the Administration Server.

Select an owner of each database and configure the permissions for your users.

Oracle Considerations

The database Block Size parameter (db_block_size) value must be at least 4096.

Note  Depending on your operating system and the tool used to create the database, the default value may be 2048; do not use this default value.

Running the Database Scripts

You must run scripts to set up the Administration Server and Decision Server databases. The scripts are available in the scripts/ directory on your installation CD.

Running the Administration Server Scripts

1. Create the Administration Server database.

For SQL Server, use the SQL Server Enterprise Manager.

Note  Make sure to note whether you create a Unicode or a non-Unicode database.

For Oracle, use the Oracle Database Configuration Assistant.

2. Run the table creation script against the Administration Server database.

For SQL Server (Unicode database):

Admin_Schema_SQLServer_2000_Unicode.sql

For SQL Server (non-Unicode database):

Admin_Schema_SQLServer_2000.sql

For Oracle:

Admin_Schema_Oracle_8i.sql

3. Run Admin_Init.sql against the Administration Server database.

Running the Decision Server Scripts

1. Create the Decision Server database.

For SQL Server, use the SQL Server Enterprise Manager.

For Oracle, use the Oracle Database Configuration Assistant.

2. Run the table creation script against the Decision Server database.

For SQL Server (Unicode database):

Decision_Schema_SQLServer_2000_Unicode.sql

For SQL Server (non-Unicode database):

Decision_Schema_SQLServer_2000.sql

For Oracle:

Decision_Schema_Oracle_8i.sql