Creating a new database repository
To create a new FastDB database you must specify the database location in the configuration files. At installation, the default database contains the Demo database, and is located at:
C:\Program Files\BIRTAnalytics\data\FastDB\databases
How to create a new repository
1 Stop Dubnium Server.
1 In Windows➛Start, type:
services.msc
Services appears, as shown in Figure 6‑10.
2 In Services, select Dubnium Server, and choose Stop from the right-click menu.
2 In Windows Explorer, create a new folder where you want to store the Dubnium database. For example:
C:\Production\SalesData
3 Set privileges for the user running the Dubnium server to this folder.
1 In Windows Explorer, select the folder, and choose Properties from the right-click menu.
2 In Properties, choose Security.
3 In Security, choose Edit.
4 In Group or user names, select the user running the Dubnium server, as shown in Figure 6‑11. If the user is not in the list, choose Add and select the user to be added.
5 In Permissions for <user>, in Full control, select Allow. Choose Apply. Choose OK.
In Security, choose OK.
In Properties, choose OK.
Figure 6‑11 Setting folder privileges
4 Open Windows Explorer, and navigate to:
C:\Program Files\BIRTAnalytics\data\FastDB\databases
5 Open the engine_configuration.ini file in Notepad. The file looks like the one in Listing 6‑3.
Listing 6‑3 engine_configuration.ini
[engine]
repository = C:\Program Files\BIRTAnalytics\data\FastDB\databases
[log]
path = C:\Program Files\BIRTAnalytics\log\engine.log
verbosity = 6
[server]
admin_file_path = C:\Program Files\BIRTAnalytics\data\FastDB\admin.sqlite
[memory]
maxmemorysystem = 2048
maxmemorythread = 1024
6 Modify the following line:
repository = C:\Program Files\BIRTAnalytics\data\FastDB\databases
to:
repository = C:\Production\SalesData
7 Save and close the file.
8 In Services, select Dubnium Server and choose Start from the right-click menu.