Implementing Siebel eBusiness Applications on DB2 UDB for z/OS and OS/390 > Customizing a Development Environment > Creating Custom Extensions to the Siebel Schema >
Applying Schema Extensions to the Development Database
Once your customizations are completed, you are ready to update your local DB2 UDB for Windows or UNIX environment. NOTE: Siebel 7 does not support customized database triggers. If you have created customized triggers on your Siebel base tables, you must disable them before updating the logical database schema. You must re-create the triggers after the update is finished.
To update your local environment
- In Siebel Tools, select the table from which you want to apply changes to the database.
- Click Apply in the Object List Editor.
A message box appears, alerting you that you are about to connect to a local database and asking if you want to continue.
- Click OK.
The Apply Schema message box appears.
- Fill in the fields as shown in the following table, and then click Apply.
|
|
Tables |
Select one of the following options from the drop-down menu:
- All. Update the database to reflect all changes made to the dictionary. This option forces each database object to be compared with the data dictionary, and updated if required.
- Current Query. Update the database to reflect modifications made to the tables in the current query only.
- Current Row. Update the database to reflect modifications made to the table in the current row only.
|
Table space |
Leave blank. |
16K table space |
Leave blank unless you are creating a large extension table that requires a 16-KB table space. |
32K table space |
Leave blank unless you are creating a large extension table that requires a 32-KB table space. |
Index space |
Leave blank. |
Table groupings file |
Specify the complete path for the storage control file. This file is provided by the DBA and is specific to your database. |
Privileged user id |
Enter the ID of a database user with CREATEDBA or DBADM privileges. The schema qualifier is read from tools.cfg . |
Privileged user password |
Enter the password of a database user with CREATEDBA or DBADM privileges. |
ODBC data source |
Verify that the ODBC connection specified in the ODBC Data Source text box is correct for your environment. You cannot apply schema changes to any database other than the one you are currently connected to (for example, by specifying the ODBC name of a different database). |
- To activate extensions to EIM tables, select the appropriate tables, and then click Activate.
|