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)
- From the application-level menu, choose View > Site Map >Server Administration >Enterprise Operations.
- Click the Component Requests tab.
- Click New.
- In the Component /Job field, select Generate New Database.
- Specify the server name in the Server field.
- In the Component Request Parameters list, click New.
- In the Name field, select SQL Anywhere Database from the pick list.
The Value field typically defaults to sse_utf8.dbf and appears automatically.
- Modify the values of other parameters as necessary by repeating Step 6 and Step 7.
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.
- In the Component Requests form, click the menu button and then click Submit request.
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.
|
