1. Database Upgrade Guide
  2. Analyzing IBM DB2 Custom Tablespace Requirements for a Siebel Upgrade

Analyzing IBM DB2 Custom Tablespace Requirements for a Siebel Upgrade

Environments: Development, Test and Production.

Databases: IBM DB2 only.

There are four standard database managed tablespaces (DMS) that hold Siebel tables and indexes: a 4-KB, 8-KB, 16-KB, and 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 IBM DB2

  1. Navigate to the following directory:

    Windows: SIEBEL_ROOT\bin

    UNIX: $SIEBEL_ROOT/bin

  2. 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 /Z UCS2_DATABASE /A DEBUGMODE

    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 (default: custtbl.log).

    • UCS2_DATABASE specifies whether the database uses Unicode or Non-Unicode (default: N).

    • DEBUGMODE retrieves the logs in detail (default: N).

    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 /Z Y /A Y

  3. 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
    Caution: 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.

  4. 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

  5. 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 (SSE_ROLE).

    • 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 (default: ddlmove.log).

    • UCS2_DATABASE specifies whether the database uses Unicode (default: N).