Partition overview

Table partitioning is a data organization scheme where table data is divided across multiple storage that is called data partitions or ranges, according to values in one or more table columns. Partitioning improves performance and simplifies data management.

Partitioning has the following advantages:

  • Improved manageability for large tables.
  • Increased query performance through data partition elimination. For example, if a query includes date, do not look in partitions that do not include that date.
  • Fast online data roll in and roll out.
  • Better optimization of storage costs.
  • Larger table capacity.
  • Fewer rows in each partition table.
  • Smaller indexes on each partition table that provide faster seeks.
  • Greater scalability.
IBM® Control Center supports database table range partitioning, which is a type of horizontal partitioning. IBM Control Center supports partitioning for the following tables:
  • EVENTS
  • CD_STATS_LOG
  • CE_STATS_LOG
  • AUDIT_LOG (not partitioned in DB2 z/OS)
  • EVENT_COMMENTS
  • EVENTS_EXT
  • CX_STATS_LOG
  • QF_STATS_LOG
  • MQ_STATS_LOG
  • AF_STATS_LOG
  • BP_STATS_LOG
  • FG_STATS_LOG
  • CC_ALERT
Attention: The tables supported for partitioning also use LOG_DATE_TIME as partitioned columns.

IBM Control Center supports database table partitioning for the following database server types:

  • Oracle
  • Microsoft SQL Server (MSSQL)
  • IBM DB2 for Linux, UNIX, and Windows
  • IBM DB2 z/OS
  • MySQL

Consult your database administrator to determine whether extra features or setup are required to support partitioning.

Important: Partitioning is suggested for large database environments. Oracle suggests partitioning for tables greater than 2 GB and for tables that contain historic data.
For databases, the tables use the following partition column:
  • EVENTS DATE_TIME column
  • CD_STATS_LOG LOG_DATE_TIME column
  • CE_STATS_LOG LOG_DATE_TIME column
  • EVENT_COMMENT S LOG_DATE_TIME column
  • AUDIT_LOG LOG_DATE_TIME column

Database table partitioning is supported only for the production database.

Change your archiving process to archive the production database tables. See Archiving data in a partitioned environment for more information on setting up archiving.