Schema Sizes
The schema sizes must be monitored constantly and increased as required.
The following table lists the schema sizes.
| Schema | Database | Description |
|---|---|---|
| SSM and PGM | Oracle or DB2 | +10% of current size |
| Sourcing | Oracle or DB2 | +10% of current size |
| SLM | Oracle or DB2 | +10% of current size |
| Contracts | Oracle or DB2 | +10% of current size |
| Contracts RUSER | Oracle or DB2 | 0 - this schema has no objects |
| Contracts Reporting | Oracle or DB2 | 30-50% of OLTP schema |
| Cognos | Oracle or DB2 | +10% of current size |
| InfoSphere DataStage schemas | Oracle or DB2 |
|
| Spend | MySQL | Depends on the installation |
Consider the following points for the schema size.
- Consider 5G for each schema if the projected size has not been estimated.
- For a new installation, the seed data for each schema is between 100M – 200M.
- If you are planning on migrating content from legacy systems, monitor the data growth as you gradually import users, organizations, contracts, and so on and adjust your size projections accordingly.
Memory configuration for the DB2 database
Use the values in the following table as guidelines for memory configuration for the DB2 database.
| Server Requirements | Small | Medium | Large |
|---|---|---|---|
| Total DB size | 10G | 50G-100G | 100G-500G |
| Memory | 16 GB | 32 GB | 64 GB - 128 GB |
| CPU | 4 | 8 | 12 |