Increasing tablespace for the Labor Budgeting Module
Labor Budgeting processes large volumes of data from the forecast tables and their respective forecast location summaries. Consequently, tablespaces must be increased in size as the table sizes increases.
Important tips:
- Allocate about 25 percent of the index tablespace for data.
- In DB2, most of the data initially occupies the 4K tablespace, but as historic data grows, data begins to accumulate in the 8K tablespace.
- The 4K tablespace should be allocated with the space from the calculations.
- The 8K tablespace should initially be allocated with about 25% of the space required for the 4K tablespace.
- Growth of all tablespaces varies, depending on usage patterns.
- Space should be regularly monitored, and tablespaces should be expanded as required.
By modifying the installation scripts, space allocations can be increased before the database is created, or altered after that database has been created. Use these database commands to make modifications:
| Database | New Installation |
|---|---|
| DB2 | release root\WB5.0\DefaultDatabase\Schema\DB2\Core rdwb01dv_crts.sql (Windows) rdwb11dv_crts.sql (AIX) |
| Oracle | release root\WB5.0\DefaultDatabase\Schema\Oracle\DB Create Scripts UNIX\9i\004-create_wb_tbsp.sql UNIX\10g\004-create_wb_tbsp.sql Windows\9i\tablespace\create_wb_tbsp.sql Windows\10g\tablespace\create_wb_tbsp.sql |
| DB2zOS | release root\WB5.0\DefaultDatabase\Schema\DB2zOS\CRMODBDS |
| SQL Server | No new tablespaces |
These examples are commands that you can use to increase DB2 tablespaces:
ALTER TABLESPACE WB_BDG04K01_REG RESIZE (ALL CONTAINERS NNNNNN) ;
ALTER TABLESPACE WB_BDG08K01_REG RESIZE (ALL CONTAINERS NNNNNN) ;
ALTER TABLESPACE WB_BDG04K01_IDX RESIZE (ALL CONTAINERS NNNNNN) ;where NNNNNN represents the number of pages in each container.
These examples are commands that you can use to increase Oracle tablespaces:
ALTER DATABASE DATAFILE '/fsdata/oradata/dbname/WB_BDG_DATA01.dbf' RESIZE 300M;
ALTER DATABASE DATAFILE '/fsindx/oradata/dbname/WB_BDG_INDX01.dbf' RESIZE 300M;For large installations, you may need to add files (containers in DB2) to the tablespaces to allow for larger volumes.