Siebel Remote and Replication Manager Administration Guide > Extracting and Initializing a Remote Database > Initializing the Local Database >

Options for Initializing the Local Database

This topic describes some of the options that are available when you initialize the local database.

Initializing the Local Database as a Nonadministrative User When Using Microsoft Windows

This topic describes how to allow a user who does not possess administrator privileges to initialize the local database when the remote client runs on Microsoft Windows.

To initialize the local database as a nonadministrative user when using Microsoft Windows

1. Log in to the Siebel Server with administrator privileges.

   For more information, see Logging in to the Siebel Server as an Administrator.

2. Configure the remote client.

   For more information, see Process of Configuring the Remote Client

3. In Windows Explorer, right-click the folder for the remote client, choose Properties, and then click the Security Tab.
4. Choose the Group or User name.
5. Add the nonadministrative user.
6. Give full permissions, and then click OK.
7. Initialize the local database.

   For more information, see Initializing the Local Database.

Initializing the Local Database from a CD-ROM

You can initialize the local database from a CD-ROM. For more information, see 475730.1 (Article ID) on My Oracle Support. This document was previously published as FAQ 1231.

To initialize the local database from a CD-ROM

1. Add the following line to the [Local] section of the configuration file on the remote client computer:

   DbinitLocalSource = path

   where:

   • path is the CD drive and folder on the remote client where the files are stored.

     For example, if the files on the CD are in a folder named db_extract\username, and if the CD is mounted on the E: drive, then you add the following line to the [Local] section of the configuration file:

   DbinitLocalSource = E:\db_extract\username

   For more information, see Modifying the Siebel Configuration File and Specifying the Folder That Stores Files.

2. Initialize the local database.

   For more information, see Initializing the Local Database.

Initializing the Local Database When Using IBM DB2 for z/OS

If you use an RAS connection with IBM DB2 for z/OS, then you must set the Database Connection Timeout parameter before you initialize the local database.

To initialize the local database when using IBM DB2 for z/OS

1. Set the Database Connection Timeout parameter of the Synchronization Manager server component to a value that is less than the actual timeout of the connection.

   For example, you might modify the DBConnectionTimeout parameter to 360. For more information, see Parameters of the Synchronization Manager Server Component.

2. Initialize the local database.

   For more information, see Initializing the Local Database.

Improving the Performance of a Local Database Initialization

To improve the performance of a local database initialization, you can increase the size of the local database template file. Rather than specifying the number of pages, it is recommended that you specify the DBSPACE parameter. The following example increases the size of the space for the server database by 400 megabytes:

ALTER DBSPACE system ADD 400 MB

In the past, the mobile database was set to less than 500 MB. With the advent of larger mobile databases, it is more feasible to increase the value for the DBSPACE parameter. It is recommended that you use the following guidelines:

• Add 320 MB for a mobile database that is less than 1 GB in size.
• Add 20 percent more DBSPACE for a mobile database that is greater than or equal to 1 GB in size.

NOTE:  For Siebel Innovation Pack 2015, the local database for Siebel Mobile Web Client uses SAP SQL Anywhere. SAP SQL Anywhere is not available for new deployments after September 2015. For more detailed information on how this change affects Siebel Tools and Siebel Remote, see Siebel Release Notes on My Oracle Support for Innovation Pack 2015 (Doc ID 1996273.1).

To improve the performance of a local database initialization

1. On the Siebel Server, make a backup copy of the sse_utf8.dbf file that resides in the SIEBEL_ROOT\DBTEMPL folder.
2. Using dbisqlc.exe, connect to the sse_utf8.dbf file.

   This utility might also reside in the SIEBEL_ROOT\bin folder. For more information on how to log on to an SAP SQL Anywhere local database, see 475652.1 (Article ID) on My Oracle Support. This document was previously published as FAQ 1210.

3. Run the following command:

   ALTER DBSPACE SYSTEM ADD 80000

   The ALTER DBSPACE command allocates space in the SAP SQL Anywhere database in 4KB pages. For example, if you add 80000, then this command allocates 320MB, where 80,000 multiplied by 4KB equals 320MB.