Siebel Remote and Replication Manager Administration Guide > Implementing Siebel Remote Server > Generating a New Database Template >

Running the Generate New Database Component


You should always use an SQL Anywhere transaction log file when creating the database template. The SQL Anywhere transaction log significantly reduces the time required to create the database template.

Use the Siebel Server Manager to run the Generate New Database component.

To generate a new database template (GenNewDb)

  1. From the application-level menu, choose View > Site Map >Server Administration >Enterprise Operations.
  2. Click the Component Requests tab.
  3. Click New.
  4. In the Component /Job field, select Generate New Database.
  5. Specify the server name in the Server field.
  6. In the Component Request Parameters list, click New.
  7. In the Name field, select SQL Anywhere Database from the pick list.
  8. The Value field typically defaults to sse_utf8.dbf and appears automatically.

  9. Modify the values of other parameters as necessary by repeating Step 6 and Step 7.
  10. Table 9 lists the parameters and default values for the Generate New Database component.

    You should set the UseDdlFile parameter to FALSE only when you run the Generate New Database component after a schema change.

  11. In the Component Requests form, click the menu button and then click Submit request.
  12. A new database file is generated. Typically, this take a few minutes.

Table 9 shows the start-up parameters for generating new database components.

Table 9. Selected Parameters for the Generate New Database Component
Name
Alias
Required/Optional
Default Value and Usage Notes
SQL Anywhere Database
DbfFile
Required
SQL Anywhere database filename to initialize. It is recommended that you use the default value, sse_utf8.dbf. This unicode file is provided with the system and supports all languages.
DBA Password
DbaPwd
Optional
Password for the DBA account. Default for SQL Anywhere is SQL. Set the DbaPwd parameter to the password for the DBA user ID in the empty database template file.
Table Space
TSpace
Optional
Space name in DB template to store Siebel tables. Do not specify the Table Space parameter unless you intend to build a custom empty database file using the specified table space.
Index Space
ISpace
Optional
Space name in DB template to store Siebel indexes. Do not specify the Index Space parameter unless you intend to build a custom empty database file using the specified index space.
Use Transaction Log File
UseTxnLog
Optional
Use when creating a new template file. The default is TRUE.
Use DDL File
UseDdlFile
Optional
Use when creating a new template file. The default is FALSE—it means that the schema is read directly from the database.
If the value is set to TRUE, it means the schema is read from the DDL file.
When a schema change takes place in your environment, set the UseDDLFile parameter to FALSE. GenNewDb will then read the latest schema from the database rather than the DDL file.
Interface Tables
IFaceTbls
Optional
Create interface tables and indexes. The default is FALSE.
Warehouse Tables
WarehouseTbls
Optional
Create Warehouse tables and indexes. The default is FALSE.
Client Db Type
ClientDbType
Optional
Client database engine type. The default is SQL Anywhere.


 Siebel Remote and Replication Manager Administration Guide, Version 7.5, Rev. A 
 Published: 18 April 2003