Example: Calculating the Db2 storage space for logical items

The following example illustrates how to calculate the DB2® database storage space required for a report that contains logical items, such as statements. In this example, the system indexes 1 million items per month and keeps the index data in the database for 36 months. Table 1 lists information about the database fields.
Table 1. Database storage for a report that contains logical items
Field Name Field Type Field Size Index or Filter
Account Number Fixed String 12 bytes Index
Report Date Date 4 bytes Filter
Customer Name Variable String 20+4 bytes Filter

The following list shows the results of the calculations for the example values:

  • TableSize = ( 12 + 4 + ( 20 + 4 ) ) = 40
  • IndexSize = ( 12 + 8 ) = 20
  • DatabaseSize = ( ( 40 + 40 ) * 1.5 ) + ( 20 * 1.5 ) ) = 150

In this example, Content Manager OnDemand requires approximately 5.4 GB of storage space to store 36 months of report index data in the database.