About the application group

Before adding the application group, review the database and storage management requirements.

Database requirements

Database requirements can be grouped in two categories: database tables and the database fields.

Database tables

  • A database table contains index data from one or more reports
  • An annotation field is not required in the database
  • The date field is the segment field for the application group

Database fields

  • Three database fields: account number, customer name, and report date
  • Account number is the index, data type string, 16 bytes. However, only 13 bytes should be stored in the database, removing the - (dash) characters from the account number string.
  • Customer name is a filter, data type string, 30 bytes
  • Report date is a filter, data type date

Storage management requirements

The storage management requirements determine where, how, and how long IBM® Content Manager OnDemand maintains the report and index data.
  • Maintain a report for five years
  • Copy documents to disk and maintain them for 60 days
  • Copy documents to archive storage when the report is loaded into the system
  • Delete each report's data and indexes separately