The sample ASE device creation script file RAP_DB_Devices.sql is installed in the %SYBASE%\Risk Analytics Platform 2.0\Model\ASE folder. This script contains SQL statements that set up ASE database devices, create the two temporary databases (rapt and rapq), and map segments to multiple devices.
Edit the <PATH> placeholder in the RAP_DB_Devices.sql script to include the pathnames to your devices. If possible, create your database devices on different physical devices. The script initializes and stripes the databases across four data devices; add or delete disk init commands in the script to match the number of devices available in your environment.
The RAP_DB_Devices.sql script
creates devices to accommodate the RAP sample data. When you create
devices for your own data, change the number and size of the devices
to suit your data and environment. See the Adaptive Server Enterprise
15.0 System Administration Guide: Volume 2 for more
information.
After you modify RAP_DB_Devices.sql, log into the ASE server and execute the script to create the devices and temporary databases. The rapt and rapq databases now contain the Risk Analytics Platform tables, indexes, and other database objects that were created in the model database in the previous section.
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
