Bookshelf Home | Contents | Index | Search | PDF

Siebel Data Warehouse Installation and Administration Guide > Administering and Troubleshooting the Siebel Data Warehouse > Optional Customization Procedures >

Improving Performance of Full_Load_Siebel_DW

---

To improve the performance for the Full_Load, drop and recreate the query indexes. The query indexes that are used for analysis purposes can be dropped and recreated before and after the full load workflow.

To drop the indexes before running the full load, use ODBCSQL utility and the file drop_query_indexes.sql found in the dwrep folder to drop the indexes. Usage:

c:\sea700\dwdb\bin\odbcsql /s [ODBCName] /u [TableOwnerName] /p [TableOwnerPassword] /l [LogFileName] /a /c "--" c:\sea700\dwdb\dwrep\drop_query_indexes.sql

where ODBCName is the ODBC Entry created for the Siebel Data Warehouse. Use the Siebel-provided ODBC drivers or native ODBC database drivers.

Table 23 lists the flags used in the odbcsql command.

Table 23.  odbcsql Flag Explanations

Flag	Description
/a	Turn on ODBC auto-commit for session
/c	Specify string which begins a comment (at BOL)
/l	Specify file to write error and status to
/p	Specify user password to login to database
/s	Specify ODBC source to use for database
/u	Specify user name to login to database

To recreate indexes after completing the Full Load, use the ddlimp utility found in the \dwdb\bin folder.

The usage of ddlimp is shown in the following example:

c:\sea700\dwdb\bin\ddlimp /u [TableOwnerName] /p [TableOwnerPassword] /c [ODBCName] /G SSE_ROLE /f c:\sea700\dwdb\bin\dwrep\ddlsme.ctl /b [TableSpaceName] /x [IndexSpaceName]

where ODBCName is the ODBC Entry created for the Siebel Data Warehouse. Use the Siebel-provided ODBC drivers or native ODBC database drivers.

Table 24 lists the flags used in the ddlimp command.

Table 24.  ddlimp Flag Explanations

Flag	Description	Comment
/U	Username	Required
/P	Password	Required
/C	ODBC Data Source	Default Env Variable: SIEBEL_DATA_SOURCE
/F	DDL Filename
/I	Create and Merge Indexes	Default: Y
/G	Grantee for Tables
/B	Default Tablespace
/X	Default Indexspace
/K	16K Page Tablespace
/V	32K Page Tablespace
/Q	SQL Filename
/L	Log Filename	Default: ddlimp.log
/W	UTF8 Database	Default: N
/Z	UCS2 Database	Default: N

This utility creates the indexes in a single tablespace as specified above.

NOTE:  In addition to reading this section, you should also see Technical Note 406, located on SupportWeb.

Bookshelf Home | Contents | Index | Search | PDF