Bookshelf Home | Contents | Index | Search | PDF |
Upgrade Guide for UNIX > Preupgrade Tasks > Preparing the Database for a DB2 Upgrade >
Determining Tablespace Page Size for DB2 UDB
There are four standard database managed tablespaces (DMS) that hold Siebel tables and indexes—a 4-KB, 16-KB, 32-KB tablespace, for various sized tables, and a tablespace to hold indexes. However, in some cases, you may have Siebel tables in custom tablespaces. Siebel tables in custom tablespaces remain in the same tablespaces after the upgrade; they are not moved to standard tablespaces.
If a custom table has an estimated page size greater than its current tablespace page size, it will not fit in its tablespace after the upgrade, and the upgrade will fail. The following utility determines whether each of your current custom tables will increase in size to the point that it requires a move to a larger tablespace.
This utility must be run prior to the upgrade, before any steps of the upgrade are executed.
To determine tablespace page size requirements for DB2 UDB
- From the
siebsrvr/bin
directory, type the following command line:
tblsize /U $
TABLEOWNER
/P $
PASSWORD
/C $
ODBC_DATASOURCE
/F $
DDL_FILENAME
/B $
DEFAULT_TABLESPACE
/X $
DEFAULT_INDEXSPACE
/K $
16K_TABLESPACE
/V $
32K_TABLESPACE
/Q $
REPORT_FILENAME
/L $
LOG_FILENAME
TABLEOWNER
= Tableowner
PASSWORD
= Tableowner password
ODBC_DATASOURCE
= Data source of the database
DDL_FILENAME
= Name of the DDL file (This file is called
ddl.ctl
, and it is located in thedbsrvr/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
.)- 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 provided below:
Custom Tablespace Name = CUST_TBS_EVT_ACT
Custom Tablespace Pagesize = 4096
- For each table that has
Status: Does not fit in its custom tablespace
, you must create a larger custom tablespace which 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 under the$
SIEBEL_ROOT
/siebsrvr/bin
directory.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
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)
NOTE: If there are problems reported by the sizing utility, you must resolve the tablespace page sizes before you proceed with the upgrade.
Bookshelf Home | Contents | Index | Search | PDF |
Upgrade Guide for UNIX Published: 20 October 2003 |