|
Developing and Deploying Siebel Business Applications > Setting Up a Developer's Local Database > Generating a New Database Template >
Running the Generate New Database Server Component
The following procedure explains how to generate a new database template. To generate a new database template (GenNewDb)
- From the application-level menu, choose Navigate > Site Map > Administration - Server Management > Jobs.
- In the Jobs list, click New.
- In the Component/Job field, select Generate New Database.
- In the Requested Server field, enter the name of the server on which to run the GenNewDb job.
After the job completes, the Execution Server field displays the name of the server that actually ran the job.
- In the Job Parameters list, click New.
- In the Name field, click the select button and use standard query techniques to select SQL Anywhere Database, and then click OK to return to the main window.
The Value field typically defaults to sse_utf8.dbf and appears automatically. To use an encrypted template file, replace this value with sse_encr.dbf.
- Modify the values of other parameters as necessary by repeating Step 5 and substituting different parameter names in Step 6.
Table 8 lists the parameters and default values for the Generate New Database component.
Set the UseDdlFile parameter to FALSE only when you run the Generate New Database component after a schema change.
- In the Jobs list, with the Generate New Database job still selected, click Start.
A new database file generates. Typically, this takes a few minutes.
Table 8 shows the start-up parameters for generating new database components.
Table 8. Selected Parameters for the Generate New Database Component
|
|
|
Default Value and Usage Notes |
SQL Anywhere Database |
DbfFile |
Required |
SQL Anywhere database filename to initialize. The default value, sse_utf8.dbf, is a Unicode file that supports all languages. Alternatively, sse_encr.dbf provides standard Sybase encryption of the local database template. |
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. |
New DBA Password |
NewDbaPwd |
Optional |
The password assigned to the local database administrator account on the Mobile Web Clients. A parameter value specified at component run time is used only for the current run of the Generate New Database component. If no value is specified at run time, the value specified in an administrative view is used. If no value is specified at component run time or in an administrative view, the default value is the first 8 characters of the enterprise name. If the enterprise name has less than 8 characters, the name is padded with consecutive digits, for example 1234... |
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 then reads 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. |
|
