Table 21. Example of Steps in a Development Environment Upgrep
|
|
|
Determine collation sequence of database. |
Not applicable |
Determines database sort order. |
Verify repository name |
rename_existing_repositories.sql |
Renames Siebel Repository to Prior Customer Repository. |
Remove interface tables |
dropif-db.sql |
Removes all Siebel Enterprise Integration Manager tables. |
Remove database triggers |
trigdrop-db.sql |
Removes all dynamically created triggers. |
Remove database-level functions and procedures |
drop_db_func_proc.sql |
Removes the exchange rate function: exrate. |
Prepare for table creation |
pret.sql |
Removes specified tables. Performs DDL operations such as adding columns to tables. Performs DML operations such as revising date formats. |
Create temporary tables for SIA |
- ddlimp utility
- ddl_temp_sia.ctl as input
|
The input file specifies the structure of the tables to be created or updated. These tables are used to perform data migration and other DML changes. |
Prepare for table creation for SIA |
pret_sia.sql |
Drops specified tables. Performs DDL operations such as adding columns to tables. Performs DML operations such as revising date formats. |
Create and update tables |
- ddlimp utility
- ddl.ctl as input
|
The ddl.ctl file specifies the structure of tables to be created or updated. |
Create temporary tables for stored procedures |
- ddlimp utility
- ddlsptbl.ctl as input
|
The input file specifies the structure of temporary tables to be created or updated. |
Household data migration for FINS |
Household_Mig_Fins.sql |
Creates and populates specified temporary tables. Then migrates data to them and performs DML operations. Migrates data back to primary tables. Drops temporary tables. |
Prepare for index creation |
preschm.sql |
Performs DML operations. Moves data between tables. Changes data in existing fields based on specified conditions. |
Prepare for index creation for SEA |
preschm_sea.sql |
Same as preschm.sql. |
Prepare for index creation for SIA |
preschm_sia.sql |
Same as preschm.sql. |
Create indexes |
- ddlimp utility
- ddl.ctl as input
|
The input file specifies the structure of indexes to be created. |
Delete old license key |
delappkey.sql |
Deletes the Siebel license key from S_APP_KEY. |
Import seed data |
- dataimp utility
- seedupg0.inp as input
- seedupg1.inp as input
- seedupg_locale.inp as input
|
Prior to importing seed data, dataimp deletes existing seed data. The seedupg* files contain filters that dataimp uses to prevent deleting seed data that you have modified or seed data meeting specified criteria. Unmodified seed data has a last update date (LAST_UPD) of 1980-01-01. Dataimp does not delete records where LAST_UPD is later than this date. |
Upgrade data after seed data import |
upg_data_afterseed.sql |
For customers who have not converted to UTC time, sets the UTC value in S_SYS_PREF to False. For customers who have converted to UTC time, the script takes no action. |
Upgrade data after seed data import SIA |
upg_data_afterseed_sia.sql |
None. |
Set system preference for codepage for DB |
set_codepage.sql |
Sets the database codepage in the S_SYS_PREF. |
Set system preference for Unicode codepage for DB |
set_unicode.sql |
Sets the Unicode codepage to UTF-8 in S_SYS_PREF. |
Update version component information |
upd_upgcomp.sql |
Updates the S_UPG_COMP table with the product release level. Also updates location of the SRF file. The S_UPG_COMP table stores version information for application executables. |
Run Oracle-specific DDL commands |
ddlora.sql |
Creates Oracle-specific DDL information, such as default storage parameters for docking objects, repository objects, and seed objects. |
Import common ancestor repository |
- repimexp utility
- Standard Siebel Repository as input
|
Imports the Standard Siebel Repository into S_REPOSITORY. For example, if you are upgrading from Siebel 8.1.x, then this command imports the standard Siebel 8.1.x repository. |
Remove EIM columns and indexes |
rmv_anc_eim_proc_col_ind.sql |
Removes Siebel Enterprise Integration Manager processing columns and indexes from the Prior Customer Repository and the common ancestor repository (Standard Siebel Repository). This prevents the repository merge from preserving Siebel Enterprise Integration Manager columns incorrectly. The merge will preserve only those Siebel Enterprise Integration Manager columns shipped with the new release. |
Update Siebel database version |
- update_ver.sql
- seeduver.sql
|
The update_ver.sql script creates a temporary table, S_APP_VER_TEMP, which contains new version information for the database schema. The seeduver.sql script updates S_APP_VER with this information. |
Import new Siebel Repository |
- repimexp utility
- Imports New Siebel Repository
|
Imports the New Siebel Repository into S_REPOSITORY. Revises schema version information in S_APP_VER. |
Import New Customer Repository |
- repimexp utility
- Imports New Customer Repository
|
Imports the New Customer Repository into S_REPOSITORY. Revises schema version information in S_APP_VER. |
Restore database version |
restore_ver.sql |
Uses S_APP_VER_TEMP to update the schema version information in S_APP_VER. Drops S_APP_VER_TEMP. |
Upgrade repository data SIA |
repos_upgrade_sia.sql |
None. |
Upgrade repository data |
repos_upgrade.sql |
Makes specific repository-related changes to repository records and to other tables. |
Set repository workflow domains to MLOV |
set_multilingual.sql |
None. |
Install SQL packages |
seeduver.sql |
Verifies that versions are set correctly in S_APP_VER. |
ifstrg.sql |
Sets storage parameters for Siebel Enterprise Integration Manager tables. |
ifindxstrg.sql |
Sets storage parameters for Siebel Enterprise Integration Manager table indexes. |
pkgseq.sql |
Adds a suffix to row IDs in the S_SEQUENCE table. Ensures that row IDs are unique. |
pkgldel.sql |
Defines s_txn_log_del_proc. Procedure periodically deletes transactions from S_DOCK_TXN_LOG. Also deletes rows from S_DOCK_TXN SET. Prevents need for large rollback segment. |
trgreset.sql |
Ensures that denormalized rows in S_TERR have correct values. |
ddlseq.sql |
Sets sequence numbers for specified tables. |
pkgvis.sql |
Creates function that modifies how Oracle optimizer does visibility check. |
delete_dock_rules.sql |
Deletes Prior Customer Repository routing rules from S_DOC_VIS_RULE that meet specified conditions. Attempts to preserve rules added using Docking Wizard. |
Create database-level functions and procedures |
db_func_proc.sql |
Creates or replaces the currency exchange rate function: exrate. |
Set primary children in data tables |
gen_primary1.sql |
Sets primary child for S_DOC_QUOTE. |
gen_primary2.sql |
None. |
gen_primary3.sql |
Sets primary child for S_LOY_PROMO. |
gen_primary4.sql |
None. |