Table 9. Information Required for the Database Configuration Wizard — Extract and Merge Option
|
|
Siebel Gateway Name Server Address Enterprise Server name |
The Siebel Gateway Name Server machine name and the Enterprise Server name. |
Siebel Server Directory |
The absolute path of the directory where the Siebel Server is installed, for example, C:\sba80\siebsrvr (Windows) or siebel/siebsrvr (UNIX). For UNIX, do not enter the string $SIEBEL_ROOT. |
Siebel Database Server Directory |
The absolute path of the directory where the Siebel Database Configuration Utilities are installed—for example C:\sba80\dbsrvr (Windows) or siebel/dbsrvr (UNIX). |
RDBMS Platform |
Choose IBM DB2 for z/OS. |
Siebel Database Operation |
Choose Run Database Utilities. |
Database Utilities Options |
Choose Configure Database |
Database Configuration Options |
Choose Extract Storage File to extract a storage control file. |
Extract Options |
Choose the Extract from Catalog and Merge with Template option. This option preserves your existing layout. This option merges storage layout information from the database you specify with information that you already entered into a storage control file, only taking objects from the template that do not already exist in the catalog. NOTE: The first time that you run an upgrade, you must use the Extract from Catalog and Merge with Template option, thereby preserving your existing layout.
|
ODBC Data Source Name |
Verify the ODBC name for connecting to the staging Siebel database. Windows: To find the name of your ODBC data source, navigate to Start > Settings > Control Panel > Administrative Tools > Data Sources (ODBC). Click the System DNS tab to find the name of your ODBC data source. UNIX: To find the name of your ODBC data source, type: vi $ODBCINI. |
Database User Name |
Enter the user name and password for the Siebel administrator of the staging database. NOTE: The staging database user name (user ID) needs to have authorization to set CURRENT SQLID.
|
Siebel Schema Qualifier |
Enter the eight-character identifier that designates the Siebel schema for your staging database. This is also an authorization ID. The schema qualifier must start with a letter, cannot contain special characters, and must be entered in uppercase. |
Database Encoding Scheme |
Specify whether your database is UNICODE or Non-UNICODE. When you are upgrading to Siebel 8.0, choose Non-UNICODE. |
Code Page Encoding Scheme |
Indicate whether your DB2 subsystem is ASCII or EBCDIC. |
Environment Type |
Indicate whether your database environment is production or development. |
Storage Control File Layout |
Choose Siebel Schema without Partitioning if you want all tables only in segmented table spaces. Choose Siebel Schema with Partitioning if you want a layout that includes a set of tables that is recommended for partitioning. The remaining nonpartitioned tables are in segmented table spaces. |
Default Tablespace |
Enter the name of the default table space. |
Storage Group for Tablespaces Storage Group for Indexes |
Indicate the values for the following parameters: Storage Group for Tablespaces. Enter the name of the table storage group. Storage Group for Indexes. Enter the name of the index storage group. |
4KB Buffer Pool Name 8KB Buffer Pool Name |
Indicate the values for the following parameters: 4KB Buffer Pool Name. Enter the 4-KB buffer pool name for your table spaces or accept the default name, BP1. This buffer pool must already be activated and have access to it granted by the DBA. 8 KB Buffer Pool Name. Enter the 8-KB buffer pool name for your table spaces or accept the default name, BP8K1. This buffer pool must already be activated and have access to it granted by the DBA. |
16KB Buffer Pool Name 32KB Buffer Pool Name |
Indicate the values for the following parameters: 16KB Buffer Pool Name. Enter the 16-KB buffer pool name for your table spaces or accept the default name, BP16K1. This buffer pool must already be activated and have access to it granted by the DBA. 32KB Buffer Pool Name. Enter the 32-KB buffer pool name for your table spaces or accept the default name, BP32K1. This buffer pool must already be activated and have access to it granted by the DBA. |
Index Buffer Pool Name Database Name Prefix |
Indicate the values for the following parameters: Index Buffer Pool Name. Enter the buffer pool name for indexes or accept the default name, BP2. This buffer pool must already be activated and have access to it granted by the DBA. Database Name Prefix. Enter the prefix for your target database name. The default prefix is SIDB. This prefix consists of up to four of the first characters in the names of your logical Siebel Databases. This prefix must start with a letter and cannot contain any special characters. All database names end in numbers. |
Storage Control File |
Enter the directory path and name for the storage control file created by this process. You must accept the default value displayed in the Storage Control File field; this varies depending on the type of upgrade you are performing:
- Development environment upgrade: storage_upg_dev.ctl
- Production environment upgrade: storage_upg_prod.ctl.
|
Log Output Directory |
Accept the default or enter the directory name. If the directory does not exist, it will be created. Do not use special characters such as spaces, slashes, or symbols in the name of the log output. |