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.
- AUDIT_LOG (not partitioned in DB2 z/OS)
IBM Sterling Control Center Monitor supports database table partitioning for the following database server types:
- Microsoft SQL Server (MSSQL)
- IBM DB2 for Linux, UNIX, and Windows
- IBM DB2 z/OS
Consult your database administrator to determine whether extra features or setup are required to support partitioning.
- EVENTS DATE_TIME column
- CD_STATS_LOG LOG_DATE_TIME column
- CE_STATS_LOG LOG_DATE_TIME column
- EVENT_COMMENTS 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.