Bookshelf Home | Contents | Index | Search | PDF |
Implementing Siebel eBusiness Applications on DB2 UDB for OS/390 and z/OS > Configuring the Database Layout > About the Siebel Database Storage Configurator >
Calculating Space
To calculate space for table spaces and indexes, you need to know your approximate row count. You can use the Row Count spreadsheet in dbconf.xls to enter a list of tables and corresponding row counts.
NOTE: If you already have a valid storage control file (if it already exists and it contains all the values for your configuration), then you do not need to use the import function.
Another option is to create a file that contains a list of tables and row counts. A sample file, row_count.ctl, is delivered with your Siebel eBusiness Application. This file contains the tables and row counts for a fresh install.
The row_count.ctl file only includes tables with a significant number of rows. For all other tables, default sizes are acceptable.
The following example illustrates what row count looks like in the row count spreadsheet.
S_ACT_EMP , 18319
S_APP_VIEW_RESP , 145573
S_APPL_WEB_TMPL , 26617
S_APPL_WTMPL_IT , 380123
S_APPLET , 13836
S_APPLET_INTL , 12178
S_AUDIT_ITEM , 13405
S_BOCOMP , 15380
S_BUSCOMP_UPROP , 21078
S_CM_CMD_PARM , 13005
S_COLUMN , 149196
The dbconf.xls spreadsheet provides several functions for calculating space.
- Import function. Use the import function to import an existing row count file (you can use the sample file, row_count.ctl). After you update the spreadsheet, use the export function to created a new row count file. Store this spreadsheet in a file that you can use as the input for future space calculations if changes are made.
- Space calculation. To calculate space for your installation, use the Import function to import the following files:
- Storage control file. This is the modified version of the storage control file—the version that contains your real values instead of object name variables.
- Logical schema. This is the ddl.ctl file. This information is used to get the index names as well as calculating row length and key length.
- Row count file. This file contains table names and estimated row counts.
The Import function will import the files listed above and then calculate your existing space.
Bookshelf Home | Contents | Index | Search | PDF |
Implementing Siebel eBusiness Applications on DB2 UDB for OS/390 and z/OS Published: 18 April 2003 |