Siebel Database Upgrade Guide > Preparing an IBM DB2 Database for a Siebel Upgrade >
Analyzing IBM DB2 Custom Tablespace Requirements for a Siebel Upgrade
Upgrades from: All Supported Siebel releases. Environments: Development, production test, production. Databases: IBM DB2 only. This topic is part of an upgrade process. See How to Perform a Siebel Database Upgrade. 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, 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, 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, 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 = Tableowner
PASSWORD = Tableowner password
ODBC_DATASOURCE = Data source of the database
DDL_FILE = Absolute path to the DDL file (This file is called ddl.ctl , and it is located in the dbsrvr/db2udb directory.)
DEFAULT_TABLESPACE = Name of the 4-KB page standard Siebel tablespace
DEFAULT_INDEXSPACE = Name of the standard Siebel index space
16K_TABLESPACE = Name of the 16-KB page standard Siebel tablespace
32K_TABLESPACE = Name of the 32-KB page standard Siebel tablespace
REPORT_FILENAME = Name of the report generated by the utility
LOG_FILENAME = Name of the log file (The default name is custtbl.log .)
Example:
tblsize /U siebel /P siebel /C ssia /F d:/sea77/dbsrvr/db2udb/ddl.ctl /B siebel_4k /X siebel_idx /K siebel_16k /V siebel_32k /Q d:/sea77/dbsrvr/db2udb/report.txt /L $SIEBEL_ROOT/log/tblsize.log
- Review the report generated by the utility to determine if 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 = Tableowner of the database (Required)
TABLE_PASSWORD = Password of the tableowner of the database (Required)
ODBC_DATASOURCE = Data source of the database (Default environment variable: SIEBEL_DATA_SOURCE)
STOP_ON_DDL_ERROR = Stop on DDL Error (Default: Y)
GRANTEE = Grantee for tables
TABLESPACE = Name of the tablespace that you are moving the table to
INDEX_TABLESPACE = Name of the index space that you are moving the table to
TABLE_NAME = Table Name Like Support (Default: N)
LOG_FILENAME = Name of the log file (The default name is ddlmove.log.)
UCS2_DATABASE = (Default: N)
|