Siebel Database Upgrade Guide > Preparing an IBM DB2 Database for a Siebel Upgrade >
Analyzing IBM DB2 Custom Tablespace Requirements for a Siebel Upgrade
Environments: Development, production test, production. Databases: IBM DB2 only. There are four standard database managed tablespaces (DMS) that hold Siebel tables and indexes: a 4-KB, 16-KB, 32-KB tablespace, for tables, and a tablespace to hold indexes. The upgrade process moves tables between these spaces as required. If you have placed Siebel tables in other tablespaces, then the upgrade process will not move these tables if they grow to exceed the tablespace size during the upgrade. If one of these tables has an estimated page size after upgrade greater than its current page size, then it will not fit in its tablespace after the upgrade, and the upgrade will fail. Oracle provides a sizing utility that determines whether tables will increase in size to the point that they must be moved to a larger tablespace. Run the utility before upgrading the database. If the sizing utility reports any problems, then you must resolve them before you proceed with the upgrade. To analyze tablespace requirements for DB2
- Navigate to the following directory:
Windows: SIEBEL_ROOT \bin
UNIX: $SIEBEL_ROOT/bin
- Type the following command line:
tblsize /U TABLEOWNER /P PASSWORD /C ODBC_DATASOURCE /F DDL_FILE
/B DEFAULT_TABLESPACE /X DEFAULT_INDEXSPACE /K 16K_TABLESPACE /V 32K_TABLESPACE /Q REPORT_FILENAME /L LOG_FILENAME
where:
TABLEOWNER is the tableowner
PASSWORD is the tableowner password
ODBC_DATASOURCE is the data source of the database
DDL_FILE is the absolute path to the DDL file (This file is called ddl.ctl , and it is located in the dbsrvr/DB2 directory.)
DEFAULT_TABLESPACE is the name of the 4-KB page standard Siebel tablespace
DEFAULT_INDEXSPACE is the name of the standard Siebel index space
16K_TABLESPACE is the name of the 16-KB page standard Siebel tablespace
32K_TABLESPACE is the name of the 32-KB page standard Siebel tablespace
REPORT_FILENAME is the name of the report generated by the utility
LOG_FILENAME is the name of the log file (The default name is custtbl.log .)
Example:
tblsize /U siebel /P siebel /C ssia /F d:/sea77/dbsrvr/DB2/ddl.ctl /B siebel_4k /X siebel_idx /K siebel_16k /V siebel_32k /Q d:/sba82/dbsrvr/DB2/report.txt /L $SIEBEL_ROOT/log/tblsize.log
- Review the report generated by the utility to determine whether the estimated table pagesize postupgrade is larger than the size of the actual custom table pagesize.
An example of the report generated by this utility is displayed in the following example:
Table Name = S_EVT_ACT
Custom Tablespace Id = 5
Custom Tablespace Name = CUST_TBS_EVT_ACT
Custom Tablespace Pagesize = 4096
Estimated Table Pagesize (postupgrade) = 5067
Status = Does not fit in its custom tablespace
- For each table that has
Status: Does not fit in its custom tablespace , you must create a larger custom tablespace that is larger than the estimated table pagesize postupgrade.
- Move the tables from their old tablespaces to the new ones by running
ddlmove .
ddlmove is a utility for moving tables from one tablespace to another tablespace. This utility is located in the following directory:
Windows: SIEBEL_ROOT \bin
UNIX: $SIEBEL_ROOT/bin
- To run
ddlmove , submit the following arguments:
ddlmove /U TABLEOWNER /P TABLE_PASSWORD /C ODBC_DATASOURCE /E STOP_ON_DDL_ERROR
/G GRANTEE /B TABLESPACE /X INDEX_TABLESPACE /M TABLE_NAME /L LOG_FILENAME
/Z UCS2_DATABASE
where:
TABLEOWNER is the tableowner of the database (Required)
TABLE_PASSWORD is the password of the tableowner of the database (Required)
ODBC_DATASOURCE is the data source of the database (Default environment variable: SIEBEL_DATA_SOURCE)
STOP_ON_DDL_ERROR is the stop on DDL Error parameter (Default: Y)
GRANTEE is the grantee for tables
TABLESPACE is the name of the tablespace that you are moving the table to
INDEX_TABLESPACE is the name of the index space that you are moving the table to
TABLE_NAME is the Table Name Like Support value (Default: N)
LOG_FILENAME is the name of the log file (The default name is ddlmove.log.)
UCS2_DATABASE is the default value of N)
|