Installing a Multi-User Configuration (Sybase)

A typical network configuration involves a database server, a file server, and one or more client workstations. To establish this configuration, follow the procedures outlined below.

If you are using the same computer in more than one role, you follow the procedures outlined below, only you perform these steps on the same computer rather than on different ones.

Step 1: Install the Database Server

On the computer that will act as the database server, install Adaptive Server Anywhere, using the instructions that came with your Sybase documentation.

Step 2: Start the Database on the Server

Use the procedures below to get your ARCHIBUS project running on your database server computer.

Step 2A: Copy the Project Database

Copy the project database file from the \databases\sybase folder of the release DVD to your database server.

If you wish to start the Headquarters sample project, use the Windows Explorer File/New/Folder command to make a project folder on the database server. For example, \archibus\projects\hq\data

Next, use the Windows Explorer Cut and Paste commands to move the hq.db file to this new folder on your database server machine.

If you wish to start your own project, use the Windows Explorer New Folder command to make a project folder on the database server. For example, \archibus\projects\myproject\data

Next, use the Windows Explorer Cut and Paste commands to copy the schema.db file to this new folder.

Use the Windows Explorer Rename command to rename this Schema.db file to the name of your project, such as, myproject.db.

Step 2B: Create a Log File

Create a log file for the database using the Sybase Central interface. In the case of an error, having a log file gives you some added protection for recovering changes made to the database since the last time you backed it up.

Start the Sybase Central utility by selecting Programs/Sybase/Adaptive Server Anywhere/Manage Adaptive Server Anywhere.
Under "Utilities", select the "Change Log File Information" utility.
Supply the database name (\archibus\projects\myproject\data\myproject.db), state that you wish to create the log file, and name the log file after the project database (such as, MyProject.log). You do not need a mirror log file or any Replication Server settings.

Step 2C: Create a Network Service

The database runs as an operating system service on the database server. When the computer is started, it can start automatically and log into an account without supervision. To instruct the computer to handle this startup, you create a network service for running the database.

Still in Sybase Central, under Services, select Add Service.
On the Service Type dialog, choose Network Server.
On the Name and Startup dialog, name the service after the project, such as myproject. To have the service start automatically when the computer starts, choose Automatic .
On the Path Name dialog, accept the default path of dbsrvXX.exe .
On the specify parameters dialog, enter your parameters. A typical list of parameters is as below.

gp 4096 -p 4096 -x tcpip,ipx,netbios -n myproject C:\users\public\archibus\projects\hq\data\hq.db

The meaning of these switches is as follows:

gp 4096 -- Sets the maximum page size in bytes.
-p 4096 -- Sets the maximum network packet size in bytes.
-x tcpip,ipx,netbios -- Sets the list of low-level communications protocols for connecting with clients. Remove any protocols you do not use on your network.
-n <file name> -- Specifies the name of the database service that the client computers will use to connect to it. The database name specification is the folder and name of the database (.db) file on the server computer's hard disk.

On the Choose Account dialog, select the Local System Account or specify another account that will run the database. Be certain that this is an account that has both read and write access to the database (.db) file itself.
On the Choose Options dialog, choose to allow the service to interact with the desktop, and start the service when created.

In the future, should you need to start, stop, or change the service yourself, do the following: start Sybase Central, select the service, and use the right-click menu to access the appropriate command.

Step 3D. Set the Cursor and Statement Counts

If you have not set the cursor and statement count for this database, you should do so at this time. Once the database is started, from Utilities, select Interactive SQL. Log into the database with system manager rights. The default for this is user name DBA; the password is SQL. Execute the following statements:

SET OPTION Public.max_cursor_count = 0;
SET OPTION Public.max_statement_count = 0;
COMMIT;

Exit Interactive SQL.

Step 3: Create your Project Preferences List Entry

Create the project preferences list entry per the instructions in this topic Adding a New Project.

Restart your application server to have the ARCHIBUS application connect to this new project.